Use Views to analyze and investigate long-term SQL Server data for planning purposes, to identify trends, or to determine potential performance issues. Views display data stored in the Spotlight Statistics Repository in the form of charts and tables. The charts and tables are grouped into logical categories, called Views, that help you analyze the collected data. Views are different to drilldowns in that they show long-term data collected over time, not real-time data.
Note: You have some control over how the data is collected.
To open a view
Click Select Connections. Select the connection(s) to view.
Click Refresh.
| Click | To do this... |
|---|---|
 Select Repository |
Select a different Spotlight Statistics Repository. |
 Time Range |
Select the time frame for the view. |
 Filter Data |
Filter the data in the view. |
 Export |
Export the view. Grids are exported as .csv files. Charts are exported as .bmp files. You cannot change the name of the exported files so if you have previously exported a view and you don't want to overwrite the files, either rename the exported files (via Windows Explorer) or export the new files to a different location. |
| Configure | Custom Counters | Create the data for the Custom Counters view. |
| Configure | Diagnostic Server | Configure the Spotlight on SQL Server. |
For descriptions of the views available, see the online help.
