7.1 SQL Log (Revision #16)

The SQL Log is visual log tool for recording any SQL queries executed by Aqua Data Studio.  It will record all queries manually executed in the Query Analyzer by you the user and any of Aqua Data Studio's internal queries for displaying information within the GUI. When the SQL Log is opened, it immediately begins recording and provides a much more detailed capture of database interaction than the SQL History alone. If the Schema Browser is used to expand a database object to view its content, the SQL Log instantly displays the query the application uses to retrieve that information. When the SQL Log is opened, it immediately begins recording. This makes it an effective tool for monitoring the execution of statements within Aqua Data Studio.

SQL Log

Opening the SQL Log

First, select Help from the main application menu, then choose SQL Log from the dropdown. The SQL Log will open in a separate window and begin recording immediately. As it captures activity it begins to display its recordings in a grid, directly from memory with the newest item at the top by default. Clicking on a row displays the full contents of the query with syntax highlighting in its query pane. The Save as Text button at the top left of the SQL Log window allows you to save all of the items as a single text file.  The View As Spreadsheet button launches your default spreadsheet application with the contents of selected items displayed.  To stop the SQL Log from recording Events, click the red square in the SQL Log toolbar. Once clicked the the green record button becomes gray. To begin recording again, click the grayed out record button so that it becomes green.

SQL Log Menu	Log Items	Save as Text	View as Spreadsheet	Stop Event Capture	Start Event Capture