It's one thing to know when you have a problem with your server, but once you've been alerted to it you need to be able to resolve it quickly to avoid affecting users. Spotlight Cloud is purpose built with this in mind. By prioritizing the issues you need to deal with first and showing you where the problem is occurring in a matter of minutes you can determine the underlying cause of server performance degradation.
Using Spotlight Cloud’s Heatmap and Overview page it’s quick and easy to identify where performance issues are occurring in your SQL Server environment. The Heatmap answers the question: Which monitored connections require the most urgent attention?
The Overview page provides a visual representation of the server and highlights where issues are occurring. If a high severity issue is occurring in a particular part of SQL Server this is highlighted in red and with one click you can see the alarm details and suggestions for how to resolve the alarm. With one more click on “Diagnose” you can drill-down to locate the underlying cause.
For example if a server is running slowly due to a blocked process you’ll quickly be able to see if a particular session is blocked and what the object is that is causing the blocked session. What would take all day to do manually with scripts can be achieved in Spotlight Cloud in minutes.
Watch this video to learn more about identifying locking, blocking and deadlocks.
Want to see this solution in action? Start your free 30-day trial, today.
Spotlight Cloud’s Overview screens and Smart Alarms provide detailed information and alerting on performance issues, and potential performance issues, affecting the SQL Server instance.
In-context recommendations provided in the solution, and the logical workflow, enable you to easily identify the root cause of an issue, allowing you to proactively manage issues and alleviate symptoms before they impact the performance of the SQL Server instance and end users.
Watch this video to see smart alarms in action.