Open the Spotlight Cloud Connection Manager

Open the Spotlight Cloud Diagnostic Server App. You will find the app on the desktop of the computer where Spotlight Cloud is installed. Double click the desktop icon.

Spotlight Cloud Diagnostic Server App

Sign in with your Quest account, and then from the Configuration panel, click Connections.

Configure Connections

This opens the Spotlight Connection Manager

Add new Connection…

  1. From the Spotlight Connection Manager, select the connection type to add.
  2. Double click Add new Connection.
  3. You will be prompted to fill in the connection properties.

The Connection Discovery Wizard is used to locate resources on the network and add those resources as Spotlight connections. The Connection Discovery Wizard can be used to locate SQL Server instances or Windows Servers.

Enter Connection Details

The connection details are required. The details are dependent on the connection type.

Click on the connection type for more detail:

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.

Add Connection Tags

Connection Tags are optional. 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.