Detect and diagnose SQL Server performance issues

When you can diagnose SQL Server performance issues quickly and accurately, ensuring a healthy database infrastructure is not just possible, but easy.

Console Features

Spotlight Heatmap

Heatmap

A simple ‘at-a-glance’ method for monitoring your connections.

The quickest way to communicate important information regarding a server is to associate a color with the severity of the issue. The heatmap takes this a step further by displaying each server as a tile and then aggregating all of the status for a server and assigning a size to that tile.

Clicking a heatmap item displays a list of alarms for the connection, so you can quickly understand the issues that require resolution.

From this view you can drill down on a particular control to see detailed diagnostics and trace the problem to its source.

Homepage

The Spotlight Home Page provides a unique view of the activity of the system. The Spotlight Home Page highlights obvious bottlenecks and problem areas. Related server statistics are grouped together on panels that are connected by a series of graphical flows and icons. Spotlight updates these flows in real time so you can see how quickly data is moving through the system.

The display is based on the SQL Server architecture diagram. For more information about this, see A review of the SQL Server architecture

Alarms

When a collected value falls outside its "normal" range of values an alarm is raised. This range is defined by setting thresholds and severities for the alarm. A new alarm is raised whenever the severity for the alarm changes. When the severity returns to normal, the alarm is canceled. Alarms critical to your operation can be configured to remain on view until they are acknowledged.

All alarms, including Diagnostic Server and operational alarms, can be configured. You can edit the settings that determine when an alarm is raised and what action is taken. You can disable alarms, apply different severities to individual keys in an alarm, and ignore certain values.

Email Notifications

Using Alarm Actions you can manage critical alerts for your SQL Server environment and be notified by email. When configuring an Alarm Action you can specify the conditions under which an Alarm is fired based on several factors. Then when the alarm occurs you can add an action that sends an email notification.

Spotlight Developer
FREE

Sign up now

You can now monitor your server connections for FREE within SQL Server Management Studio using Spotlight Developer.

Spotlight on SQL Server Enterprise
Enterprise

Sign up now

Spotlight on SQL Server Enterprise delivers simplicity without compromise by providing unmatched monitoring, diagnosis and optimization of your SQL Server environments, ensuring peak performance around the clock.

Spotlight
Mobile

Sign up now

Anywhere , Anytime, from any device

Spotlight on SQL Server Enterprise users can now monitor remotely via mobile devices at no additional cost! Using your favorite mobile device, you can view a heatmap of your connections, see all of your alarms and snooze or acknowledge them.