Users of SQL Server Management Studio can monitor all their connections via a heatmap, alarms list and realtime diagnostics for FREE.
Once installed and configured, users can monitor their connections immediately. The powerful monitoring features communicate important information regarding the status of connections. Severity is color coded so it’s easy to see at a glance what needs your attention.
Following customer feedback we’ve also made it easy to connect Spotlight Extensions to your Spotlight on SQL Server Diagnostic Server. This makes it possible for you to take advantage of data collections for all your connections in Spotlight on SQL Server.
You also get a FREE System health Check, Performance Health Analysis and comprehensive information about your most expensive queries.
Spotlight Extensions monitors SQL Server 2008, 2008r2, 2012, 2014 and 2016. However it can only be installed in SSMS versions 2012, 2014 and 2016View Frequently Asked Questions Installation Guide
Upload performance data from Spotlight Extensions to the Spotlight website and you’ll have access to a cloud-based set of Spotlight productivity tools to gain insight into the health of your SQL Server environment.Learn more about Spotlight health checks