Spotlight Extensions for SQL Server Management Studio includes two great tools: Spotlight Developer and the Spotlight Tuning Pack. Spotlight Developer provides powerful monitoring and diagnostics and the Spotlight Tuning Pack gives you unparalleled Query Plan analysis and automated SQL Tuning.
It's FREE to use the monitoring, diagnostics and Query Plan analysis functionality. Simply download and install to begin.Learn more about Spotlight Developer Learn more about the Spotlight Tuning Pack
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
We’ll analyze your SQL right within SQL Server Management Studio. The analysis will indicate whether the Query Plan can be tuned to improve performance, or whether the SQL Statement can be rewritten to optimize its efficiency.
If the SQL is a candidate for optimization you simply click the "Optimize" button and our rewrite engine creates a number of variations of the SQL. From these variations we then select the SQL that improves execution time the most and display the results for you to review.Learn more about Plan Analysis Learn more about optimizing your SQL