Spotlight on SQL Server monitors the activity of SQL Server instances.
This guide is for Spotlight on SQL Server Standard.
| Features | Spotlight on SQL Server Enterprise | Spotlight on SQL Server Standard |
|---|---|---|
| Architecture | Deployable with separate diagnostic server and multiple clients. | Single installation |
| Playback Database | Yes | Yes |
| Heat Map | 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.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center
