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:
|
| 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.
