Spotlight on SQL Server 9.2 - Getting Started Guide

Filter SQL Analysis Data

To filter the data displayed

Start from the data displayed in the SQL Analysis grid

Tips:

• You cannot use wildcard characters for the Database name when connected to a SQL Server 2000 instance.
• To turn off filtering, clear the Filter results checkbox.
• To edit or delete a filter select it in the filter list and click the appropriate button.

To filter the data collected

1. Click Configure | SQL Analysis.

   

2. Choose one of the following from the connection list:
   • To change the setting for an individual connection, select the connection name.

     • Select Override the default settings.

       Select Enable SQL Analysis.

   • To change the setting for all connections, select Default Settings and select Override the default settings.

3. Ensure the Filters page is selected.

   • Click Add.

     Tips: 

     • You can use the percent sign (%) and underscore (_) as wildcards.
     • You cannot use wildcard characters in the Database name field when connected to a SQL Server 2000 instance.
     • When filtering on a string field such as DatabaseName or ApplicationName, use only the "LIKE" and "NOT LIKE" operators. The other operators apply only to numeric values.

   Tips: 

   • Use the Arrow buttons to change the order of the filters.
   • Edit or delete a filter by selecting it in the filter list and clicking the appropriate button.
   • Filtering affects the average, minimum, maximum, and last values displayed in the grid, as calculations are performed only on data retrieved from the SQL Server instance.
   • To turn off filtering, on the Filters page, click Clear. This removes all filters.
4. You can specify the number and type of SQL Executions retrieved from the SQL Server instance
   1. Select the Advanced page.
   2. In the Aggregate the top n SQL statements field, enter the maximum number of SQL executions to be retrieved from the SQL Server instance.
   3. From the Sorting by list, specify the criterion you want Spotlight to use to determine what the "top" SQL statements are. Choose from Average Duration, Average CPU, or Average IO.

   Spotlight aggregates the data collected and then stores only the aggregated data.