Spotlight® Extensions

for SQL Server management Studio
Download now

Spotlight Cloud Tuning Pack

Optimization results and plan visualization

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 Cloud 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

Download iPhone and iPad App Download Android App

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 Cloud Tuning Pack inside SQL Server Management Studio.