Chat now with support
Chat with Support

Spotlight on SQL Server Enterprise 11.7 - Release Notes

New Connection Details

This dialog may be opened from Configure | Connections on request to add a new connection.

Select Diagnostic Server

In a federated system you will be prompted to select the Spotlight Diagnostic Server. The new connection will be monitored by this Spotlight Diagnostic Server.

TIP: A SQL Server instance should be monitored on the same Spotlight Diagnostic Server as the SQL Server host.

Where Windows hosts are in a virtual environment the Windows host should be monitored by the same Spotlight Diagnostic Server as the associated Hyper-V / VMware server.

A single Spotlight Diagnostic Server is designed to monitor a maximum of 100 SQL Servers, Analysis Services or Replication instances and 100 Windows servers. Exceeding this recommended limit on 32 bit environments may result in poor performance or product instability, due to the 1 Gb memory limit. On 64 bit environments theoretically more connections can be monitored as the 1 Gb limit no longer applies, however testing of this has been limited.

 

Select connection type

If requested, from the drop-down list, choose the type of connection you want to add.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating