Performance Monitoring from Spotlight Cloud

Dec 1, 2016

Performance Monitoring from Spotlight Cloud

The Spotlight Cloud services lets you monitor your servers on the web and mobile devices. It also analyzes your server performance data and gives health checks on your servers, evaluates their capacity and provides other insights into their performance. Furthermore, you can compare your experience to everyone else using this service.

Cloud monitoring provides some of same main benefits of the Spotlight Enterprise edition with features such as the Heatmap display of connections, Spotlight Home Page of each connection, Alarms List and Performance Health. Additionally, the Health Check feature shows the health of your system and the ability to drill down at a granular level.

To get started, first configure Spotlight on SQL Server Enterprise to upload monitoring data to Spotlight Cloud:

Visit Spotlight Cloud site and click Sign Up option to sign up your email address
From Spotlight Client application click the Configure tab on top ribbon bar
Click Spotlight Cloud option and enable feature by clicking on checkbox
Sign in to the Spotlight Cloud site by entering your email address and password from step 1
To start mobile monitoring, from mobile device download Spotlight Essentials mobile app and sign in using the same credentials

Let’s take a closer look at what Spotlight Cloud and Mobile monitoring offers:

Monitoring – Consists of the connection Heatmap display, Alarms List per connection which also allows for acknowledging and snoozing alarms, and Performance Health drilldown.

Health Check – Provides health status of your server based on the follow metrics: Guest user Access, Login Password Policy, Simple Recovery Model, Database Backups, Missed Indexes, Physical Memory Pressure, Ad-hoc Workload, Writelog Wait, SQL Best Practice and Compatibility Levels.

Waitopedia – A comprehensive resource of information about SQL Server waits. For more information on this topic visit my previous Welcome to the world of Waitopedia.

Capacity – An overview of disk space capacity of monitored servers.

Collective IQ – Collective data from Spotlight Cloud users representing the following metrics: SQL Server versions, server types, virtual vs. non-virtual servers, and percentage of users with specific number of connections.

Documentation – Instructions on how to configure Spotlight Enterprise and Mobile devices. FAQ sheet along with data handling and security information.

Feedback – Contact our Spotlight team directly on any feedback comments, questions or issues.

Here are some screens shots of Spotlight Cloud monitoring:

Heatmap: