About Spotlight on SQL Server
Installation and Upgrade
Connections to SQL Servers
Use Spotlight on SQL Server
Diagnose CPU
Diagnose IO
Diagnose Blocking
View Historical Data
Identify Expensive SQL
Playback Database
Troubleshooting, Permissions & Maintenance
Turn on and configure SQL Analysis
Real-Time Data and Expensive SQL
Filter Displayed and Collected Data
Analyze Wait Statistics
Find Long Running SQL
Configure the Virtualization Overhead Guage
Spotlight on SQL Server and Firewalls
Permissions
Unable to collect data
Enabling Performance Data
WMI Issues
Spotlight on SQL Server and Windows domains
Session Trace Errors
Unable to establish a Spotlight connection to a SQL Server instance
Connection Issues
Monitor Multiple SQL Server Instances
Spotlight Diagnostic User Groups
Maintenance
Tree View
The first column in a Spotlight grid may show data as a simple text string or (if available) a hierarchical tree structure. If the data can be shown in both formats, you can choose which view to use.
To show or hide trees in tables
| » | Toggle tree view on/off |
Location Procedure More information From a drilldown page Click 
See "Drilldowns Ribbon Group" (page 1) for more information. From an Alarm page Click Monitor| Collapse All
Available from Spotlight Today and Alarms by Time. See "Alarms Ribbon Group" (page 1) for more information.
The images below show the same first column of a table in the two different formats.
|
|
|
Note: When you sort a table in tree view, the table is sorted first according to the highest level in the tree; the individual branches and sub-branches of the tree are sorted separately in the same order. See "Sort the Grid" (page 1) for more information.
[This example is shown in ascending order.]
 |
|