Spotlight on SQL Server Enterprise

loading

Spotlight on SQL Server – Simplicity Without Compromise

Spotlight on SQL Server – Simplicity Without Compromise

A simple but highly effective visualization to show the instances in most need of attention. The bigger and redder the box, the more alarms that have been raised. Simply hover over an instance to view a list of alarms.

Spotlight on SQL Server – Highly Intuitive Dashboards

Spotlight on SQL Server – Highly Intuitive Dashboards

The Spotlight highly intuitive dashboards allow you to go from viewing your entire infrastructure to drilling down to a specific problem on a specific instance with just three mouse clicks. Colour coded indicators allow DBAs of all levels to quickly follow a trail that leads them to root cause analysis.

Spotlight on SQL Server –Monitoring on The Move

Spotlight on SQL Server Enterprise Full Support for SQL Server Replication

Keep a constant eye on your SQL Server infrastructure from your mobile device with native apps on Windows Mobile, IOS and Android. If you spot an issue when you are out of the office, use playback to reconfigure all of the Spotlight dashboards and drill downs back to the point in time an alarm occurred to complete full root cause analysis… even after the fact.

Spotlight on SQL Server – Performance Health

Spotlight on SQL Server – Performance Health

Track the performance health of your instances. Identify where your SQL code is waiting on resources. Use the Statement Waits Drilldown to determine the area contributing to wait time workload.

Spotlight on SQL Server – Response Time Analysis Workflow

Spotlight on SQL Server – Response Time Analysis Workflow

Identify where your SQL code is waiting on resources. Use the Statement Waits Drilldown to determine the area contributing to wait time workload.

Spotlight on SQL Server –Get to the Detail When You Need To

Spotlight on SQL Server –Get to the Detail When You Need To

Drill down into the detailed data when you need to with over 80 different diagnostic views designed to provide context specific data that aligns with specific troubleshooting scenarios.

Spotlight on SQL Server –Windows Dashboard

Spotlight on SQL Server –Windows Dashboard

Detailed out-of-box monitoring and diagnostics of the Windows Operating System upon which your SQL Server is installed.

Spotlight on SQL Server –Replication Dashboard

Spotlight on SQL Server –Replication Dashboard

Watch for any failures or bottlenecks across your replication topology.

Spotlight on SQL Server –Analysis Services

Spotlight on SQL Server –Analysis Services

Monitor your Analysis Services instances from the Spotlight Dashboard and diagnostic drill-downs.

24 x 7 monitoring and diagnostics to optimize SQL Server performance

  • Obtain a complete view of everything that affects SQL Server performance including; SQL Server, underlying operating system, VM Layer, SQL Azure, High Availability and replication
  • Use playback to reconfigure dashboard and diagnostics to the point in time that an issue occurred
  • Resolve issues proactively, before they impact the business
  • Conduct advanced response time analysis with individual dashboards for each connection type, over 80 diagnostics views, long term performance analytics, performance and system healthchecks and collective Intelligence
  • Use customizable metrics and alarm actions to take automated actions when an alarm is raised
  • Monitor SQL Server performance from anywhere, at any time on a mobile device of your choice

Overview

When you can diagnose SQL Server performance issues quickly and accurately, ensuring a healthy database infrastructure is not just possible, but easy.  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.  With intuitive overviews of enterprise health and performance, automated alerts and actions, an integrated Xpert tuning module and mobile device support, Spotlight on SQL Server Enterprise makes it easier than ever to obtain the data you need to ensure the health of your SQL Server databases.

Detect and diagnose performance issues

Understand your SQL Server infrastructure health at a glance by monitoring SQL Server’s relational engine, Analysis Services, Windows, VMware ESX and SQL Azure from a single console. Its advanced SQL Server monitoring capabilities includes custom reporting and trending to communicate the health, activity, and capacity trends with integrated management and performance views, client-side reports, and the Spotlight on SQL Server Enterprise Report pack.

Receive instant alerts at the server level

Extend robust built-in metrics and alarms with custom collections and alerts. Using historical playback, navigate from any Spotlight management screen to see up to two weeks of performance diagnostics and alarm data to resolve recent issues more effectively.

Resolve issues proactively, before they impact the business

Analyze performance data automatically to resolve issues quickly, including long-running processes, blocking locks, deadlocking and more. Quickly identify servers where performance degradation originates and isolate root cause of a performance issue to expedite issue resolution.

Monitor database performance from anywhere, at any time

Go mobile to monitor your SQL Server environment anywhere, anytime on your mobile device. Spotlight on SQL Server Enterprise gives you the ability, but with Spotlight Express, a free option, you’ve got the mobility to view, get alerts and respond from anywhere, at any time.

Obtain free health check metrics and benchmark against community of users

Utilize a cloud-based set of Spotlight productivity tools to gain insight into the health of your SQL Server environment. Automate performance data uploads with a free SQL Server Management Studio (SSMS) plug-in.

Features

24 x 7 monitoring and diagnostics
Implement around the clock agentless monitoring from one centralized diagnostic server. Enjoy a single view across multiple clients with alarms and notifications when your SQL Server deviates from your pre-set operating thresholds
Instant prioritization across all SQL Servers
Use a single view (Heatmap) for instant prioritization of critical needs. Allocate resources in the most effective manner and react to the most pressing issues to minimize business disruption
Response time analysis
Use our dedicated response time analysis workflow to determine where waits are occurring, what’s causing the event and what SQL is associated with the wait. Combine this with unique perspectives that come from benchmarking against billions of wait statistics to determine whether the behaviour on your instance is normal
A complete picture
Monitor everything that affects your SQL Server performance including SQL Server itself, the underlying operating system, its VM Layer, SQL Azure, High Availability, Replication and Analysis Services – all available in one package for one price
Effective root cause analysis
Avoid the pitfall of addressing just the symptoms. Use individual dashboards for each connection type, over 80 diagnostics views, long term performance analytics, performance and system healthchecks and collective Intelligence to lead to the root cause of your 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
Mobile device support
Never lose sight of your SQL Server health with alerts and notifications delivered to an app build specifically for your IOS, Android or Windows mobile device
Historical playback
Never miss a beat with historical playback to ensure that when something happens when you are not at your workstation, you can playback to that point in time and reconfigure all of your dashboards and diagnostics as if you were observing the incident happen in real time. Pinpoint critical SQL statements based on index utilization, resource consumption, or query efficiency and review run-time query plans
VMware memory diagnostics
Analyse virtual memory with charts that are similar to those used for virtual CPU analysis
High-availability support
Get in-depth information on your SQL Server clusters, replication, database mirroring, and log-shipping activities and environments
Custom performance counters, custom alarm actions and planned outage
Track and alarm on service level-specific processes as though they were metric counters, to proactively handle performance issues. Use customized alarm actions to kick off a SQL or Powershell script for known issues. Use planned outage to define maintenance down time where alarms should not be raised
Custom reporting and trending
Understand health, activity, and capacity trends of your SQL Server environment 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, then tune. Benchmark, and investigate indexing strategies through integration with Dell™ SQL Optimizer for SQL Server (comes with Spotlight on SQL Server Xpert Edition)
Spotlight statistics repository
Configure long-term metric data storage for historical trending and capacity planning initiatives
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 views
System healthcheck with powerful analytics
Obtain a holistic view of the health of your system with the free healthcheck tool and compare your experience with other users, then drill down and view detail at a granular level. Access reports via the instance and database lists and receive trigger notifications in your account inbox
Detailed trending of most expensive queries
Display the top ten most expensive queries, by totals and averages of reads, writes, duration or CPU, then filter results to provide a detail page containing a trending chart, full query, and the latest execution plan (downloadable as XML)

Specifications

Spotlight client

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

Platform1 GHz Processor
Memory1 GB RAM recommended
Hard disk space200 MB
This space should exist on a local disk drive rather than a network drive
Operating system

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.
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 Dual Core Processor
Memory4 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)
Microsoft Windows 8 (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
  • SQL Server 2014
Spotlight on SQL Server also supports MSDE (2000), SQL Express (2005) and SQL Server 2008 Express Edition and SQL Server 2012 Express. 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)
  • Microsoft Windows 8 (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 200 connections per diagnostic server in a 64 bit environment. A connection can include a SQL Server, Analysis Services, Azure connection, Replication instances or 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. To use Spotlight Reporting and Trending, it is recommended that the Spotlight Statistics Repository is installed on SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 or SQL Server 2012.
Recommended SQL Server versionInstalling 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 requirements

The 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 space

Requires 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 requirements

The 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

What's New

Version 10.5

  • Response Time Analysis - Use Spotlight to analyse whether database time is being spent productively on CPU and I/O. A database with unhealthy performance spends too much time waiting for bottlenecks such as locks and latches. Use the new Statement Waits Drilldown to determine the area contributing to wait time workload
  • Planned Outages - Let Spotlight know the scheduled maintenance times for your Spotlight connections and Spotlight will expect the monitored connections to be unavailable at the scheduled times. This allows you to manage planned outages, schedule once only and reoccurring outages and resume monitoring early
  • Support for SQL Server 2014 - Spotlight now monitors SQL Server 2014 instances