Chat now with support

Get Live Help
Complete Registration

Sign In

Request Pricing

Contact Sales

FREE TRIALS

Spotlight on SQL Server 9.5.2 - Getting Started Guide

Table of Contents

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 Windows Alarms

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

CPU - Average CPU Usage Alarm (page 1)

CPU - Individual CPU Usage Alarm (page 1)

CPU - Processor Queue Length Alarm (page 1)

Custom Counters Alarm (page 1)

Disks - Percentage Used Alarm / Free Space Alarm (page 1)

Disk Queue Length alarm (page 1)

File - Exceeded Set Size Alarm (page 1)

Memory - Free System Page Table Entries Alarm (page 1)

Memory - Percentage Free Virtual Memory Alarm (page 1)

Memory - Physical Memory Available Alarm (page 1)

Network - Percentage Bandwidth Alarm (page 1)

Paging - Disk Activity Alarm (page 1)

Paging - File Collision Alarm (page 1)

Services - Service Not Running 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)

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating