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.