SQL Log Capture (Revision #22)

Most relational database vendors have features to write log files of your SQL queries and other database maintenance operation, but reading the logs are quite difficult. Aqua Data Studio 11.0 introduces a visual log GUI named SQL Log, to capture all SQL queries executed in the Query Analyzer. Once you  execute queries in the Query Analyzer, you can view the log data in the GUI or view in Excel spreadsheet. You can also save the log as a text file and open with ADS text editor. SQL Log is a powerful tool that provides a syntax highlighter as well as support for Exceptions in queries.

Analyze SQL Statements and view database transactions

The SQL Log for faster access to view time and duration of the SQL statements to finish executing with a single click. 

What's New?

 SQL Log GUI

Aqua Data Studio 11.0 features a new Option to view the SQL log files under Help --> SQL Log

 Start Event Capture

Displays the status of the SQL statements

 Stop Event Capture

Displays the status of the SQL statements

 Status

Displays the status of the SQL statements

 Time and Duration

Option to view the time of execution and the duration of the SQL statements

 Server

Displays the Database Server Connections and the corresponding SQL statements executed

 Username 

Displays the username with the corresponding SQL statements executed.

 Statements executed

Option to view the SQL statements executed

 Exceptions 

Option to view the SQL exceptions

 View as Spreadsheet 

Option to view log as spreadsheet

 Save Log as Text file 

Option to save the log as text files

 Clear Display

Clears the display of executed statements and exceptions

 Filter

Filter helps you to search and find the executed SQL queries very easily