SQL Server
Product Community
Join the community to connect with world-renowned IT experts, discuss current trends, help shape products, and more!
Join now »

Spotlight on SQL Server Enterprise

Operational Monitoring, Diagnostics, Administration and Automated Tuning for SQL Server

Spotlight® on SQL Server Enterprise provides in-depth physical, cloud, and virtual SQL diagnostics. Intuitive overviews of enterprise health and performance, automated alerts and actions, and an integrated Xpert tuning module ensure optimal performance for your SQL Server, Analysis Services, VMware ESX and SQL Azure database environments. Spotlight makes it easy to:

  • Understand your SQL Server infrastructure health at a glance
  • Monitor SQL Server’s relational engine, Analysis Services, Windows, VMware ESX and SQL Azure from a single console
  • Customize built-in metrics and alarms
  • Automate performance metric analysis
  • Resolve issues quickly, including long-running processes, blocking locks, deadlocking and more
  • Gain insight into the health of your SQL Server environment with the free health check tool
  • Go mobile and monitor your environment anywhere, anytime on any device with the free Spotlight mobile tool

Features

  • Gain insight into the health of your SQL Server environment with the free health check tool and compare your experience with other users
  • Go mobile and monitor your environment anywhere, anytime on your mobile device with the free Spotlight mobile tool
  • VMware Memory Diagnostics – Analyze virtual memory with charts that are similar to those used for virtual CPU analysis
  • Top SQL and Real-Time Query Plans – Pinpoint critical SQL statements based on index utilization, resource consumption, or query efficiency, and review run-time query plans
  • High-Availability Support – Get in-depth information on your SQL Server clusters, replication, database mirroring, and log-shipping activities and environments
  • Diagnostic Drilldowns – Automate CPU and I/O performance diagnosis and resolution
  • Custom Performance Counters – Track and alarm on service level-specific processes as though they were metric counters to proactively handle performance issues
  • Historical Playback – Navigate through up to two weeks of performance diagnostics and alarm data to resolve recent performance issues from any Spotlight management screen
  • Custom Reporting and Trending – Understand health, activity, and capacity trends of your SQL Server enterprise with management and performance views, client-side reports, and the Spotlight on SQL Server Enterprise Report Pack
  • SQL Analysis and Xpert Tuning – Highlight long-running queries and bad code and tune, benchmark, and investigate indexing strategies through integration with Quest SQL Optimizer for SQL Server (comes with Spotlight on SQL Server Xpert)
  • Spotlight Statistics Repository – Configure long-term metric data storage for historical trending and capacity planning initiatives
  • Integrated Link to SQL Server Pedia – Get up-to-the-minute, context-specific advice on the performance issues you’re diagnosing from the experts
  • Wait-Stat Analysis – Diagnose wait statistics to determine where waits are occurring and what is causing the event
  • Deadlock Detection and Review – Gain full visibility of deadlock events and the conditions that caused them
  • Windows-Only Connections Views – Add Windows-only connections to Spotlight’s views

Sys Reqs

Spotlight Client

Before installing the Spotlight client, ensure your system meets the following minimum hardware and software requirements:

Platform1 GHz Pentium 4 PC
Memory1 GB RAM
Hard Disk Space200 MB
This space should exist on a local disk drive rather than a network drive.
Operating SystemMicrosoft Windows 2000 (Professional, Server, Advanced Server, Datacenter server) with Service Pack 4
Microsoft Windows Server 2003 (32-bit and 64-bit)
Microsoft Windows Server 2008 (32-bit and 64-bit)
Microsoft Windows Server 2008 R2 (64-bit)
Microsoft Windows XP (32-bit and 64-bit)
Microsoft Windows Vista (32-bit and 64-bit)
Microsoft Windows 7 (32-bit and 64-bit)
Additional Software
SQL Server Client Tools
To use the Discovery Wizard to locate SQL Servers on your network the SQL Server Client Tools must be installed on the Spotlight client. The SQL Server Client Tools can be found on the installation disk for Microsoft SQL Server 2000, 2005, or 2008.
Install .NET 2.0 or later
To use the Spotlight Report Viewer, .NET 2.0 or later must be installed on the Spotlight client machine.
Microsoft Internet Explorer 6.0 or later.
Microsoft Data Access Components (MDAC)
MDAC includes the ODBC and other components that enable a connection to be established to a SQL Server database. The database may be local or remote. Your client machine must have MDAC 2.7 (or later) installed.
MDAC is available from the Microsoft website: www.microsoft.com/downloads
To find out the version of MDAC that you are currently running, you can download an application from the Microsoft website called comcheck. Review the following Microsoft Knowledge Base article for more information:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;3012022
Other RequirementsCD-ROM drive or Internet connection (required for installation only).
A monitor capable of supporting a resolution of 1280 x1024 or greater.

Diagnostic Server

Before installing the Diagnostic Server, ensure your system meets the following minimum hardware and software requirements:

Platform2 GHz Pentium Dual Core
Memory2 GB RAM
Hard Disk Space300 MB
If the Diagnostic Server’s connection to the Spotlight Statistics Repository or playback database is interrupted, the Diagnostic Server will cache data to the local disk. In this event, an extra 2 MB per hour, per monitored server is required.
Operating SystemMicrosoft Windows XP Service Pack 2 or later (32-bit and 64-bit)
Microsoft Windows Server 2003 (32-bit and 64-bit)
Microsoft Windows Server 2008 (32-bit and 64-bit)
Microsoft Windows Server 2008 R2 (64-bit)
Microsoft Windows 7 (32-bit and 64-bit)
Additional Software.NET 3.5 or later must be installed on the Diagnostic Server machine.
SQL Server Client Tools
To use the Discovery Wizard to locate SQL Servers on your network the SQL Server Client Tools must be installed on the Diagnostic Server. The SQL Server Client Tools are on the installation disk for Microsoft SQL Server 2000, 2005, and 2008.
To use Spotlight on Analysis Services the Client Connectivity tools must be installed.
SQL Server Management Tools
To use Spotlight on Analysis Services, Spotlight on SQL Server Replication, and Session Trace and SQL Analysis in Spotlight on SQL Server, SQL Server Management Tools must be installed on the Diagnostic Server.
The SQL Server Management Tools are available from any SQL Server 2005 or SQL Server 2008 edition except SQL Server Express and SQL Server Compact. The version required corresponds to the latest version of SQL Server that you are monitoring. Note, if you are monitoring SQL Server 2000 servers, you need the Management Tools from SQL Server 2005.

Monitoring

SQL ServerSpotlight can diagnose SQL Server instances of the following versions:
  • SQL Server 2000 (Service Pack 3 or later)
  • SQL Server 2005 (32-bit and 64-bit)
  • SQL Server 2008 (32-bit and 64-bit)
  • SQL Server 2008 R2 (32-bit and 64-bit)
  • SQL Server 2012
Spotlight on SQL Server also supports MSDE (2000), SQL Express (2005) and SQL Server 2008 Express Edition. Note that use of these versions to host playback or Spotlight Statistics Repository databases is not supported.
Spotlight cannot diagnose earlier versions of SQL Server (version 7.x and earlier).
Spotlight supports all SQL Server sort orders, including case-sensitive and binary sort orders. Spotlight cannot connect to SQL Server instances where the instance name contains non-US ASCII characters.
Database Cloud ServiceSpotlight supports SQL Azure.
Operating SystemsSpotlight can diagnose the following operating systems:
  • Microsoft Windows 2000 (Professional, Server, Advanced Server, Datacenter server) with Service Pack 4
  • Microsoft Windows Server 2003 (32-bit and 64-bit)
  • Microsoft Windows Server 2008 (32-bit and 64-bit)
  • Microsoft Windows Server 2008 R2 (64-bit)
  • Microsoft Windows XP (32-bit and 64-bit)
  • Microsoft Windows Vista (32-bit and 64-bit)
  • Microsoft Windows 7 (32-bit and 64-bit)
Note: On each monitored instance, Spotlight requires the network setting "File and Print Sharing" to be enabled and any firewall to be configured to:
  • open port 1434 for UDP packets
  • open the SQL Server TCP port (default is 1433)
VirtualizationSpotlight on SQL Server can monitor virtual guest machines in a VMware ESX infrastructure. The following versions are supported:
  • VMware vCenter 2.5 (or later)
  • VMware ESX Server 4.0 (or later)
Connection LimitThis version of Spotlight on SQL Server is designed to monitor a maximum of 100 SQL Server, Analysis Services, or Replication instances and 100 Windows servers. Monitoring more than this recommended limit may result in poor performance or product instability.

Spotlight Statistics Repository

Before installing the Spotlight Statistics Repository, ensure your system meets the following minimum requirements:

Database sizingBy default, the size of the Spotlight Statistics Repository is set to 1000MB (data size) and 250MB (log size). These sizes are flexible and can be changed by running the Spotlight Statistics Repository creation script.
The script is located in the install directory as follows:
..\Plug-ins\Diagnostics Server\Scripts
Hard Disk SpaceApproximately 1.2 GB for each monitored SQL Server instance and the corresponding monitored Windows host on which the SQL Server instance resides.
This estimate assumes default configuration in an average environment. Actual space used will depend on your environment and any data collection/storage configuration changes that are made. For more information, see the Spotlight on SQL Server Sizing Wizard. You can access the wizard from the Spotlight Installation Center.
Recommended SQL Server versionTo use Spotlight Reporting and Trending, it is recommended that the Spotlight Statistics Repository is installed on SQL Server 2005 or SQL Server 2008.
Installing the Spotlight Statistics Repository on SQL Server 2000 can result in errors being displayed and no data being shown in some views. Installing the Spotlight Statistics Repository on SQL Server 2000 is not recommended.
Note: Due to the size of the Spotlight Statistics Repository, it is recommended that this database is not installed on a SQL Express instance.
Other RequirementsThe SQL Browser service must be running on the machine where the Spotlight Statistics Repository is installed. Alternatively you can use the host and port number of the (named) SQL Server instance you want to connect to, when creating a connection and connecting to the Spotlight Statistics Repository.
The TCP protocol must be enabled on the instance where the Spotlight Statistics Repository resides.
For more information, see the Spotlight on SQL Server Deployment Guide.
MaintenanceIt is highly recommended that regular maintenance is performed on the Spotlight Statistics Repository. The recommended maintenance plan is outlined in the online help and in the Spotlight on SQL Server Deployment Guide.

Playback Database

Before installing the playback database, ensure your system meets the following minimum requirements:

Database sizingBy default, the size of the playback database is set to 500MB (data size) and 125MB (log size).
Hard Disk SpaceRequires approximately 270 MB for each monitored SQL Server instance and the corresponding monitored Windows host on which the SQL Server instance resides.
Retains 7 days of historical data for each connection in the playback database by default. This is configurable.
Assumes default configuration in an average environment. Actual space used will depend on your environment and any data collection/storage configuration changes that are made. For more information see the Spotlight on SQL Server Sizing Wizard. You can access the wizard from the Spotlight Installation Center.
Recommended SQL Server versionDue to the size of the playback database, it is recommended that this database is not installed on a SQL Express instance.
Other RequirementsThe SQL Browser service must be running on the machine where the playback database is installed. Alternatively you can use the host and port number of the (named) SQL Server instance you want to connect to, when creating a connection and connecting to the playback database.
The TCP protocol must be enabled on the instance where the playback database resides.
For more information, see the Spotlight on SQL Server Deployment Guide.
MaintenanceIt is highly recommended that regular maintenance is performed on the playback database. The recommended maintenance plan is outlined in the online help and in the Spotlight on SQL Server Deployment Guide.


Language Supported:

  • US English

Videos

Screenshots

Spotlight on SQL Server Enterprise View

Spotlight on SQL Server Enterprise View

Shows enterprise health at a glance, including information on the top alarms experienced by individual instances.

Instance Home Page

Instance Home Page

Identifies SQL server instance health at a glance. SQL Server instances running on a VMWare guest OS image show the amount of CPU overhead to identify the impact of virtualization on SQL Server performance.

Diagnostic Drill-downs

Diagnostic Drill-downs

Automatically evaluate the root cause of resource contention including information, bringing together information from the database and operating system perspective on one screen.

Full Support for SQL Server Replication

Full Support for SQL Server Replication

Allows DBAs to easily identify any issues in their replication environment.

Robust Windows Dashboards (like this Operating System Home Page)

Robust Windows Dashboards (like this Operating System Home Page)

Identify Windows server health at a glance - Windows servers running on a VMWare host show the amount of CPU overhead the guest image is experiencing to identify the impact of virtualization on Windows performance.

Monitor SQL Server Analysis Services (SSAS)

Monitor SQL Server Analysis Services (SSAS)

Includes intuitive dashboards like this Analysis Services instance homepage.

Monitor SQL Azure Databases

Monitor SQL Azure Databases

Overlook your environment in the same intuitive manner other SQL Server connection types are displayed to show the health of your SQL Azure databases at a glance.

Spotlight Heat Map view

Spotlight Heat Map view

Instantly see the severity of alarms and mouse over a SQL Server instance to drill into performance issues.

Docs

Case Studies

Colorado Springs Implements Foglight (third party) Data Technology Consultants Relies on Quest Tools to Proactively Monitor Client Environments and Provide Backup Compression and Encryption Debenhams Depends on Quest's Spotlight and Foglight to Dramatically Improve System Performance and Availability Fulton County School System Sees Future of Student Information System with LiteSpeed Markel Gains Confidence Moving from Oracle to SQL Server with Quest’s SQL Server Performance Health Check Quest Cleans Up Greenstar's SQL Server Performance Monitoring and Delivers Diagnostics Times Savings of 80% Quest Delivers Immediate ROI and Prevents Costly Upgrade for Morefield Communications Quest Tools Ensure Peak SQL Server Performance for the City of Colorado Springs Quest’s SQL Server Performance Monitoring Nets ESOS an 80 Percent Savings in DBA Time SAIF Reduces SQL Server Problem Resolution Time by 87 Percent with Foglight Performance Analysis and Spotlight on SQL Server Enterprise SD Worx Discovers that Quest Solutions Work to Resolve Application Issues in Record Time Singapore American School Achieves a Quantum Leap in Productivity with Quest's SharePoint and SQL Server Solutions Spotlight Eliminates the Need for Shoreline Communications to Spend $100K in System Improvements Spotlight on SQL Server Enterprise Helps LA Weight Loss to Shape Up SQL Server Performance Temporary Employment Agency Adecco Monitors its Databases with Spotlight on SQL Server and Increases the Performance of its ERP System with Performance Analysis for SQL Server Wilbur Smith Associates Is on the Road to Success with Quest's Solutions for SQL Server back to top