Spotlight Cloud can monitor the following on-premise connection types:
- SQL Server
- SQL Server replication (Requires Spotlight Cloud Professional)
- Windows Server
Spotlight Cloud can monitor Azure SQL Databases (Preview) in the cloud. See how to add cloud connections.
Use the Spotlight Cloud Diagnostic Server application to add on-premise connections
The Spotlight Cloud Diagnostic Server application is installed locally. Double click the desktop icon.
Sign in with your Quest account.
From the configure panel, click Connections.
This opens the Spotlight connection manager
- From the Spotlight connection manager, select the connection type to add.
- Click Add new connection.
- You will be prompted to fill in the connection details.
Enter connection details
The connection details are dependent on the connection type:
The number of instances Spotlight Cloud can monitor is dependent on your Spotlight Cloud subscription. All Spotlight Cloud subscriptions have a ‘quantity’ field measuring the number of instances Spotlight Cloud can monitor. One monitored instance equates to one database connection, one connection to the operating system host and a connection to the operating system virtual environment.
Your first Spotlight Cloud subscription is Trial Professional. When the Trial Professional subscription expires your subscription changes to Spotlight Cloud Basic. Spotlight Cloud Basic can monitor fewer instances than Spotlight Cloud Trial Professional or Professional. To increase the quantity of instances Spotlight Cloud can monitor purchase Spotlight Cloud Professional or on a Spotlight Cloud Professional subscription purchase additional monitored instances.
Connections are enabled for monitoring as they are added. When the subscription ‘quantity’ is reached connections can still be added but they are initially disabled. You can increase your Spotlight Cloud subscription or disable one connection to monitor another using the enable / disable functionality.
When the subscription changes from Spotlight Cloud Trial Professional or Professional to Spotlight Cloud Basic you may notice the most recently added / enabled connections are disabled. Fewer instances are monitored on a Spotlight Cloud Basic subscription. All SQL Server replication connections are disabled on a Spotlight Cloud Basic subscription as a Spotlight Cloud Trial Professional or Professional subscription is required to monitor SQL Server replication connections.
The Connection discovery wizard can be used to locate resources on the network and add those resources as Spotlight connections.
Connection tags are a free form organizational tool that may be applied to Spotlight connections. tag names represent a project, geographic region or other indicator of interest to you and your organization. Multiple tags can be assigned to one connection.