Tchater maintenant avec le support

Obtenir une aide instantanée
Terminer l’enregistrement

Se connecter

Demander les tarifs

Contacter le service des ventes

FREE TRIALS

Spotlight on SQL Server 10.0.3 - Getting Started Guide

Parcourir le contenu

About Spotlight on SQL Server Installation and Upgrade

Install Upgrade Uninstall

Connections to SQL Servers Use Spotlight on SQL Server

Diagnose CPU Diagnose IO Diagnose Blocking View Historical Data Identify Expensive SQL

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

Connections to VMware Servers

Playback Database

Configure the Playback Database Requirements Playback

Troubleshooting, Permissions & Maintenance

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

Spotlight on SQL Server Alarms

For information on individual Spotlight on SQL Server alarms, see the following links.

Backup Alarms (page 1)

Clusters - Failed Over Alarm

Clusters - Node Unavailable Alarm (page 1)

Clusters - Non-Preferred Node Alarm (page 1)

Compiles - Percentage Recompilations Alarm (page 1)

CPU - Average CPU Usage Alarm (page 1)

CPU - Processor Queue Length Alarm (page 1)

Custom Counters Alarm (page 1)

Databases - Data File Group Space Used Alarm (page 1)

Databases - Dynamic Data File Group Growths Remaining Alarm (page 1)

Databases - Dynamic Log File Growths Remaining Alarm (page 1)

Databases - Log File Space Used Alarm (page 1)

Databases - Log Flush Wait Time Alarm (page 1)

Databases - SQL I/O Errors Alarm (page 1)

Databases - Unavailable Alarm (page 1)

Error Log - Error Count Alarm (page 1)

I/O Wait Time Alarm (page 1)

Index Fragmentation Alarm (page 1)

Index Fragmentation Status Alarm (page 1)

LiteSpeed Backup Alarms (page 1)

Locks - Blocked Processes Alarm (page 1)

Locks - Deadlocks Alarm (page 1)

Log Shipping - Primary Backup Job Alarm (page 1)

Log Shipping - Secondary Job Alarm (page 1)

Log Shipping - Secondary Latency Alarm (page 1)

Memory - Buffer Cache Hit Rate Alarm (page 1)

Memory - Page Life Expectancy Alarm (page 1)

Memory - Procedure Cache Hit Rate Alarm (page 1)

Mirroring - State Alarm (page 1)

Mirroring - Unrestored Log Alarm (page 1)

Mirroring - Unsent Log Alarm (page 1)

Missing SQL Performance Counters Alarm (page 1)

Network - SQL Server Packets Error Rate Alarm (page 1)

Services - DT - Service Status Alarm

Services - Full Text Search Service Alarm

Services - Service Not Running Alarm

see Services - Service Not Running Alarms (page 1)

Services - SQL Mail Status Alarm / SQL Agent Mail Status Alarm (page 1)

Project Lucy Upload Failure Alarm (page 1)

SQL - Long Running SQL Alarm (page 1)

SQL Agent - Alerts Alarm (page 1)

SQL Agent - Jobs Failed Alarm (page 1)

SQL Agent - Long Running Jobs Alarm (page 1)

SQL Agent - Status Alarm, see Services - Service Not Running Alarms (page 1)

SQL Analysis - Aggregation Information Alarm (page 1)

User - Connection Count Alarm (page 1)

User - Logins Per Second Alarm (page 1)

User - Response Time Alarm (page 1)

VMware Overhead alarm (page 1)

Notes:

Click Monitor | Alarm Log to display the alarm log.
If the Spotlight Diagnostic Server is unable to collect the data required for the home page or drilldowns, Spotlight displays a small icon on the affected component, chart or grid. Click the icon to see more information about the problem.

Related Topics

Alarms Ribbon Group (page 1)

Configure Alarms (page 1)

Documents connexes

The document was helpful.

Sélectionner une évaluation

I easily found the information I needed.

Sélectionner une évaluation