What types of connections can I monitor with Spotlight Cloud? What are the requirements?

Spotlight Cloud can monitor a SQL Server instance, its host and associated virtualization server all under the one license.

Spotlight Cloud monitors the following connection types. Click on the links for connection requirements.

What are the minimum permissions required for the account used in SQL Server and Windows connections?

Ensure the database user has sufficient account permissions to retrieve performance data from the SQL Server instance and host by WMI. Typically the account will be a member of the sysadmin server role. It could be a SQL Server login (such as ‘sa’). If this is not feasible in your environment, see How to grant SQL Server account permissions to a trusted user.

What is the performance hit (footprint) on the monitored server?

The performance hit on the monitored server is minimal - less than 10%.

Are the monitoring metrics updated in real-time and can I view a history of the monitoring metrics?

The Heatmap and Spotlight Overview pages are updated in real time (Auto Refresh ON). The Alarms page is not updated once the screen is drawn (Auto Refresh OFF). Some drilldown pages are updated in real-time, some show data over a defined time span, some can show historical data. Refer to the top right corner of the monitoring page for more information.

Monitoring Page Display Description
Auto Refresh ON For pages like the Heatmap and Spotlight Overview pages, Auto Refresh is ON. The page from this display was last updated a few seconds ago.
Auto Refresh OFF Time For pages like the Alarms page, Auto Refresh is OFF. The time of the last refresh is given.
Auto Refresh OFF Time Range For some drilldown pages, Auto Refresh is OFF and the range of time involved in the data analysis is given.
History Available If the display has a down arrow to the right of the time then historical data is available. Click on the down arrow for options.
Data is real time only. Next to Auto Refresh is a button that you can click to switch Auto Refresh ON or OFF. For some pages like this one you cannot turn Auto Refresh off. Data is real time only.

Does Spotlight Cloud raise an alarm when monitoring values fall outside their normal range of values? Can I configure the default thresholds as per my needs?

Yes, the alarms for each connection type are as follows:

Yes, these alarms can be configured. For instructions, see Configure Alarms and Configure Alarm Actions.

How is data collected from monitored servers?

During setup the Spotlight Cloud Diagnostic Server is installed locally on your network. The Spotlight Cloud Diagnostic Server retrieves data from monitored connections using your network. The Spotlight Cloud Diagnostic Server uses the Internet to send this data to Spotlight Cloud for analysis and display.

How can I contact Quest in regards to Monitoring data issues or questions?

Click on the Support link from the main menu.