Spotlight Data Collections

Spotlight offers a variety of performance health metrics with diagnostic drilldown screens for each problematic area of your server. Each drilldown screen provides detail data to help you diagnose and isolate application problems. Spotlight provides the users the capability to customize the frequency of data collection in addition to the option of storing historical date in Spotlight’s Repository database.

In order to configure Spotlight collection, the user can utilize the Scheduling feature to view and customize each collection setting.  The navigation begins from the Spotlight Client home page and then proceed by:

  1. Click Configure | Scheduling icon located on the ribbon bar.
  2. Select a template or connection name to configure.
  3. Select a collection name to modify the collection schedule.

Each collection name correlates to the data in one or more diagnostic drilldown. For example, the collections responsible for the SQL Activity drilldown are listed below:

SQL Activity Drilldown Collection Names

Page/Grid/Chart

Collection Name

Notes

Sessions

Full Session List

 

Sessions | SQL

Session Details

Non configurable    

Sessions | Session Trace

Session Trace

Non configurable

Sessions | Session Locks

Locks List

 

Summary | Access Methods charts

Access Methods

 

Summary | CPU Utilization (SQL Server)     

SQL CPU Percent

 

Locks

Locks List

 

Locks | Locks Types charts

Lock Statistics

 

Locks | Latches chart

Latches Locks

 

Blocking

Decode Wait Resource

Non configurable

Blocking

Blocking List

 

Deadlocks

Deadlock List

 

I/O by File

Virtual File Statistics

 

Custom Counters

Custom Counters - SQL Server

 

Query Execution Statistics

QueryExecutionStatistics

 

 

For a full list collections of all drilldowns see the following Help pages:

SQL Server Collections
Windows Collections
VMware Collections
SQL Azure Collections

 Download a free trial edition of Spotlight from here.

Anonymous