To see retrieved SQL statements in real-time, use Open shortcut menu on the running SQL Capture process in the Object Explorer tree. A separate panel for this SQL Capture process will open. It has SQL Capture area that displays captured SQL statement in real-time. The controls in that area are the same as for SQL Viewer Tool described below.
To see SQL statements recorded in the Sentinel repository by SQL Capture processes, use Historical Data SQL Viewer Tool. You can easily pinpoint the worst performing statements and see who and how often executes them by using the SQL Viewer Tool. You can also capture a sequence of SQL statements for a particular session and to use them to build meaningful load test scenario that replicates behavior of this session on the Load Tester's multiple virtual user sessions.
The SQL Viewer Tool allows you to specify the time interval, for which you want to review the collected statements. It also allows you to sort displayed SQL statements chronologically, or based on the estimated performance statistics. You can filter displayed statements by session ID, if you are interested in reviewing SQL executed by particular user thread chronologically.
There are multiple ways to open SQL Viewer Tool:
The SQL Viewer Tool panel consists of the selection wizard and results panel. In the selection wizard, you can specify the time interval for analysis and list of session Ids that have to be displayed.
The SQL Viewer Tool results panel consists of the following components: