Spotlight on SQL Server monitors the activity of SQL Server instances. Spotlight displays a visual representation of the status of the databases in your enterprise, enabling you to drill down to graphical flows that illustrate the rate at which data is moving between server components. Icons display the value of key statistics and measurements. A range of visual graphs and tabular grids provide you with detailed information about your SQL Server instance.
The components and dataflows change color to show you the source of any problem. When Spotlight on SQL Server detects a condition that it considers is a potential problem, it not only informs you about it, but advises you what you could look at to diagnose the problem further and suggests corrective actions.
Spotlight on SQL Server seamlessly combines data from several disparate sources into a single user interface. It collects and combines data from Windows Performance Counters, SQL Server system tables, SQL Server commands and the Windows Registry, and presents them in logically related screens.
Editions of Spotlight on SQL Server
This is a guide for Spotlight on SQL Server Standard.
Features | Spotlight on SQL Server Enterprise | Spotlight on SQL Server Standard |
---|---|---|
Architecture | Deployable with separate Spotlight Diagnostic Server and multiple clients. | Single installation |
Heat Map | Yes | Yes |
Playback Database | Yes | Yes |
Spotlight Statistics Repository and Spotlight Reporting and Trending | Yes | No |
Email notifications on alarms | Yes | No |
Upload data to Project Lucy | Yes | Yes |
Monitored Connections | ||
Microsoft SQL Server | Yes | Yes |
Microsoft SQL Server Replication | Yes | No |
High Availability | Yes | No |
Microsoft Windows | Yes | Yes |
Microsoft SQL Server Analysis Services | Yes | Yes |
Microsoft SQL Azure Database | Yes | Yes |
VMware Server | Yes | Yes |
Run the Spotlight on SQL Server installation executable.
Stages of Installation | Description |
---|---|
Spotlight on SQL Server Installation Folder |
Default (32bit machine): Default (64bit machine): Notes:
|
Spotlight Diagnostic Server Service Account |
Specify the user details for the domain user account under which the Spotlight Diagnostic Server will run. Notes:
|
Auto-Update |
Select to enable auto-update of diagnostic server components. When selected your installation of the diagnostic server will receive minor updates (scripts and configuration) automatically. When not selected, all updates to the diagnostic server will require a new version and installation of Spotlight on SQL Server. Note: An outgoing HTTPS connection to a web site is used to retrieve the updates. Enabling of Auto-update does not open a port that allows incoming connections. |
Configure the Spotlight Playback Database |
The Playback database can be on the same machine as Spotlight on SQL Server or a different machine.
|
The following information is preserved when you upgrade:
To upgrade Spotlight on SQL Server Standard
Back up the Spotlight on SQL Server Standard\Agent directory.
C:\Program Files\Quest Software\Spotlight on SQL Server Standard\Agent
Note: Spotlight on SQL Server Enterprise and Spotlight on SQL Server Standard are separate products. You cannot use this procedure to upgrade from Spotlight on SQL Server Standard to Spotlight on SQL Server Enterprise. You can use this procedure to upgrade Spotlight on SQL Server Desktop to Spotlight on SQL Server Standard.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center