Use this dialog to specify the SQL statement that Spotlight uses to measure response time for a Spotlight connection.
Note: You must be a member of the Spotlight Diagnostic Administrators group to change the SQL Statement used to measure SQL Server response time.
To open the SQL Server Response Time dialog
| » | Click Configure | SQL Server Response Time. |
Settings in the SQL Server Response Time dialog
| Option | Description |
|---|---|
|
Select connection to configure |
Select the connection name to configure an individual connection. Select Default Settings to configure the default settings for all connections. |
|
Override the default settings |
Select to set the SQL statement other than the default. Clear to return the SQL statement to the default. If you are editing the SQL statement for an individual connection, clearing the check box returns the SQL statement to the one specified via Monitoring Configuration. If you are editing the SQL statement for all connections, clearing the check box returns the SQL statement to the factory default, which is Select 1 |
|
SQL Statement |
Edit or replace the SQL statement. The default statement is Select 1. |
To view the response time for the current Spotlight connection, see the Sessions panel on the Spotlight Home Page page or the SQL Summary page in the SQL Activity drilldown.
Spotlight on SQL Server Home Page (page 1)
