Logging Query Execution Statistics

Determining the cause of slow running queries can help you tune the performance of your TDV environment.

To log query execution statistics

1.

Enable the logging of purged request statistics from the Studio Configuration window. For example, Administration > Configuration and navigate to SQL Engine > Logging > Query Statistics Logging

Configuration Parameter	Description of Value
Maximum Number of Logged Purged Requests	Use to refine the number of query execution records retained in the log files.
Log Purged Request Query Statistics	Use to turn the logging of query execution statistics on or off.

2.

Open the Studio Manager.

3.

Navigate to the Requests Panel.

4.

At the bottom of the Requests panel, select the Include Logged Requests check box.

5.

Review the generated log files.

6.

Determine what if anything can be adjusted to improve the performance of the queries that appear to be running slow.