Spotlight® Extensions

for SQL Server management Studio
Download now

Plan analysis

Spotlight Extensions for SQL Server Management Studio

Powerful SQL tuning within SQL Server Management Studio for FREE

Every time you execute SQL we’ll analyze it and let you know if we find any issues that need your attention. We’ll also calculate how much improvement can be achieved by adding an index and provide the script to create it.

This powerful Plan Analysis is combined with a new intuitive execution plan visualization to make it quick and easy to see where the most expensive operations are occurring in your executed SQL.

SQL TUNING VIDEO

Watch a video demonstration of SQL tuning

This video shows you how the Plan Analysis tool in Spotlight Extensions can assist you with tuning your SQL statements.

We demonstrate how the tool analyzes your SQL statements, locates issues, calculates how much improvement can be made and finally provides a script to create any missing indexes.

By completely redesigning the execution plan visualization we’ve made it easy to see which operations have the highest cost and made viewing large plans far more manageable.

PLAN VISUALIZATION

Connecting analysis to the execution plan visualization

With a single click you can see how the analysis relates to specific operations in the execution plan.

Whenever you have a batch query we provide a summary indicating the top 3 plans by cost so you can compare them at a glance.

By completely redesigning the execution plan visualization we’ve made it easy to see which operations have the highest cost and made viewing large plans far more manageable.

Query History

Track changes to your SQL

Each time you execute a SQL Statement we save the SQL and any analysis that’s been performed.

This enables you to track the changes to your SQL over time and compare how the latest version a query performs with an older version.

The statements are time stamped and grouped by date so they are easy to locate.

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