Spotlight® Extensions
Spotlight Tuning Pack
Powerful SQL optimization and query plan analysis within SQL Server Management Studio
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.
SQL Optimization Video
Watch a demonstration of how to optimize your SQL
This video shows you how easy it is to optimize your SQL within SQL Server Management Studio using Spotlight Tuning Pack Professional.
We demonstrate how the tool analyzes your SQL statements, and then automatically rewrites them over and over again until it finds a variation that creates the most improvement in the execution time of the SQL.
PLAN VISUALIZATION
Compare the optimized execution plan with the original
When viewing a SQL statement that has been optimized, with a single click on the plan tab you can compare the original execution plan with the optimized one. This enables you to see the changes that the rewrite has introduced to the plan.
Optimization History
View a complete history of your Optimized SQL
Each time you start optimization of a SQL Statement it is added to the Optimization History panel and indicates how much time is left until the process is complete.
Once complete you can right click to view the optimization results. These results remain in the history so at anytime you can come back and view them again.
Spotlight
Enterprise
Try it now
Ensure around the clock SQL Server performance and availability
Spotlight Enterprise delivers simplicity without compromise by providing unmatched monitoring, diagnostics, and optimization of your SQL Server environments.
Try it now to achieve peak performance and availability for your SQL Server investment!
Spotlight
Mobile
Monitor your SQL Server environment anytime, anywhere from your favorite mobile device.
Spotlight Enterprise users can view a Heatmap of SQL Server performance and manage alarms across all instances as well as drill into a detailed view of a specific SQL Server from a mobile device.
Spotlight Extensions
Tuning Pack
Download now
Automated query tuning from inside SQL Server Management Studio
Navigate complex query plans, view plan analysis and even tune your SQL from with SQL Server Management Studio (SSMS)
Install Spotlight Extensions now to access Spotlight Tuning Pack inside SQL Server Management Studio.