|

Spotlight on SQL Server Enterprise

Deal of the Week!
Act fast and save 40% on a PC for your business today. Shop Now ›

Monitor, diagnose and optimize performance.

Get unmatched monitoring, diagnosis and optimization of your database environments to ensure peak performance around the clock.


 

 

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 provides you with unmatched SQL Server monitoring, diagnosis and optimization of your database environments to ensure 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.

Benefit from these key features with Spotlight on SQL Server Enterprise:

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.
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, then tune. Benchmark, and investigate indexing strategies through integration with Dell™ 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

Wait-stat analysis
Diagnose wait statistics to determine where waits are occurring and what’s 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

System health check with powerful analytics
Obtain a holistic view of the health of your system with the free health check 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)

Mobile device support
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.
  • Spotlight client

    Platform
    1 GHz Processor

    Memory
    1 GB RAM recommended

    Hard disk space
    200 MB
    Note: 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)

    Software
    SQL Server® Client Tools
    Note: 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.

    .NET 2.0 or later
    Note: To use the Spotlight Report Viewer, .NET 2.0 or later must be installed on the Spotlight client machine.

    Required Browser
    Microsoft Internet Explorer® 6.0 or later

    Display
    1280 x1024 or greater

    Diagnostic Server

    Platform
    2 GHz Dual Core Processor

    Memory
    4 GB RAM

    Hard disk space
    300 MB
    Note: 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 system
    Microsoft 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)

    Required Software
    .NET 3.5 or later
    SQL Server Client Tools
    SQL Server Management Tools

    Monitoring

    SQL Server
    Microsoft SQL Server 2000 (Service Pack 3 or later)
    Microsoft SQL Server 2005 (32-bit and 64-bit)
    Microsoft SQL Server 2008 (32-bit and 64-bit)
    Microsoft SQL Server 2008 R2 (32-bit and 64-bit)
    Microsoft SQL Server 2012
    Microsoft SQL Server 2014

    Also:
    MSDE (2000)
    Microsoft SQL Express (2005)
    Microsoft SQL Server 2008 Express Edition
    Note: 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).

    Note: Spotlight cannot connect to SQL Server instances where the instance name contains non-US ASCII characters.

    Database Cloud service
    Microsoft SQL Azure

    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)

    Virtualization
    VMware vCenter 2.5 (or later)
    VMware ESX Server 4.0 (or later)

    Connection Limit:
    This 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

    Database sizing
    1000MB (data size) and 250MB (log size)

    Hard disk space
    1.2 GB (approximate for each monitored SQL Server instance and the corresponding monitored Windows host on which the SQL Server instance resides)
    Note: For more information, see the Spotlight on SQL Server Sizing Wizard. You can access the wizard from the Spotlight Installation Center

    Recommended SQL Server version
    Installing the Spotlight Statistics Repository on SQL Server 2000 or SQL Express is not recommended

    For more information, see the Spotlight on SQL Server Deployment Guide

    Playback database

    Database sizing
    500MB (data size) and 125MB (log size).

    Hard disk space
    270 MB for each monitored SQL Server instance and the corresponding monitored Windows host on which the SQL Server instance resides.

    Recommended SQL Server version
    It is recommended that this database is not installed on a SQL Express instance.

    For more information, see the Spotlight on SQL Server Deployment Guide

    Language supported
    US English
DocumentsDocuments
Download printable materials to gain insight on how this product can help you simplify IT challenges.
  
EventsEvents
Peruse webcasts and in-person activities near you to explore the technology behind this product.
  
CommunitiesCommunity
Get the most from this product as you join your peers and Dell experts to access tools and learn best practices.
Dell Software | Contact Us

Contact a Dell Expert

Get help with all your business needs.

Learn More
Dell Software | Support

Software Product Support

Single location for all your product needs.

Learn More
close
 
 
CS06