Spotlight on SQL Server 10.0.3 - Getting Started Guide

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

Back Up Spotlight Configuration Data

Collect Additional Diagnostic Information

The following alarms are configurable to collect (not collect) additional diagnostic information. When configured to collect additional information and the alarm is activated to the severity to trigger data collection then data is captured in the playback database.

You may choose to enable or disable this data collection using the instructions that follow on from this table.

Alarm Name	Severity to trigger data collection	Data Collection Default	To show this drilldown: select the alarm in the alarm log and click Diagnose.		For additional information: select the alarm in the playback database and navigate to this drilldown.
Compiles - Percentage Recompilations	High	On	SQL Server	SQL Activity \| Summary SQL Activity Drilldown (page 1)	SQL Server	SQL Activity \| Sessions SQL Activity Drilldown (page 1)
CPU - Average CPU Usage	High & Medium	Off	Windows	Processes Processes Drilldown (page 1)
CPU - Average CPU Usage	High	Off			SQL Server	Diagnose CPU Pressure Diagnostics Drilldown (page 1)
CPU - Individual CPU Usage	High & Medium	On	Windows	Processes Processes Drilldown (page 1)
I/O Wait Time	High	Off	SQL Server	Diagnostics \| IO Diagnostics Drilldown (page 1)
Locks - Blocked Processes	High	On	SQL Server	SQL Activity \| Blocking SQL Activity Drilldown (page 1)	SQL Server	SQL Activity \| Sessions SQL Activity Drilldown (page 1)
Locks - Deadlocks	High	On	SQL Server	SQL Activity \| Deadlocks SQL Activity Drilldown (page 1)	SQL Server	SQL Activity \| Sessions SQL Activity Drilldown (page 1)
Memory - Buffer Cache Hit Rate	High & Medium & Low	On	SQL Server	Memory \| Buffer Cache Memory Drilldown (page 1)	SQL Server	SQL Activity \| Sessions SQL Activity Drilldown (page 1)
Memory - Free System Page Table Entries	High & Medium	On	Windows	Memory \| Summary Memory Drilldown (page 1)	Windows	Processes Processes Drilldown (page 1)
Memory - Page Life Expectancy	High & Medium	On	SQL Server	Memory \| Buffer Cache Memory Drilldown (page 1)	SQL Server	SQL Activity \| Sessions SQL Activity Drilldown (page 1)
Memory - Percentage Free Virtual Memory	High & Medium	On	Windows	Processes Processes Drilldown (page 1)
Memory - Physical Memory Available	High & Medium	On	Windows	Processes Processes Drilldown (page 1)
Memory - Procedure Cache Hit Rate	High	On	SQL Server	Memory \| Procedure Cache Memory Drilldown (page 1)
Memory - Procedure Cache Hit Rate	High & Medium	On			SQL Server	SQL Activity \| Sessions SQL Activity Drilldown (page 1)
SQL - Long Running SQL	High & Medium & Low	On	SQL Server	SQL Activity \| Sessions SQL Activity Drilldown (page 1)	SQL Server	SQL Activity \| Sessions \| Session Details SQL Activity Drilldown (page 1)
SQL Agent - Alerts	High & Medium	On	SQL Server	Support Services \| SQL Agent Alerts Support Services Drilldown (page 1)

To configure the collection of data

Click Configure | Alarms.
Select the connection:
- Select the connection name to configure an individual connection.
- Select Default Settings to configure all connections.
Select the alarm.
Select Override the default settings for the alarm.
To collect data select Collect additional diagnostic information.

To disable the collection of data clear Collect additional diagnostic information.

请选择您的产品：

为向您提供更好的服务，请填写'Purpose of your Chat'（联系目的）：

针对您的问题建议的解决方案

Spotlight on SQL Server 10.0.3 - Getting Started Guide

Collect Additional Diagnostic Information