SpotlightTM Developer

for SQL Server management Studio
Get it now

Plan analysis

Spotlight Developer 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 Developer 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 overtime 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 Developer
FREE

Sign up now

You can now monitor your server connections for FREE within SQL Server Management Studio using Spotlight Developer.

Spotlight on SQL Server Enterprise
Enterprise

Sign up now

Spotlight on SQL Server Enterprise delivers simplicity without compromise by providing unmatched monitoring, diagnosis and optimization of your SQL Server environments, ensuring peak performance around the clock.

Spotlight
Mobile

Sign up now

Anywhere , Anytime, from any device

Spotlight on SQL Server Enterprise users can now monitor remotely via mobile devices at no additional cost! Using your favorite mobile device, you can view a heatmap of your connections, see all of your alarms and snooze or acknowledge them.