Try Spotlight Cloud ProSign in

Spotlight Tuning Pack

Tune your SQL right within SSMS

Get Spotlight Tuning Pack
HubSpot Video
Execution Plan

Spotlight Tuning Pack provides powerful SQL optimization and query plan analysis within SQL Server Management Studio.

Why Spotlight Tuning Pack?

plan-analysis2

Plan Analysis

Our Artificial Intelligence engine will analyze your execution plan and determine how to change it so SQL Server executes the operations more efficiently.

plan-map

Execution Plan Visualization

We've improved the execution plan visualization so it's easier to understand and faster to locate the operations that are slowing down the execution of your SQL.

Optimize SQL

Automated SQL Optimization

We'll analyze your SQL and then automatically rewrite it until we find the variation that creates the most improvement in the execution time of the SQL.

identify-SQL-icon

Compare optimized and original SQL

We highlight changes in the SQL statement so you can compare the original statement with the optimized version before applying any changes.

plan-map

Compare the execution plans

Once you've optimized your SQL we show you the original plan and the optimized plan so you can compare them and see what's changed.

stats-icon

Statistics

So you can see exactly why the optimized SQL statement is executing faster than the original we provide detailed statistics to give you the full picture.

Subscription Pricing

Basic

Basic is perfect for analyzing your execution plans and providing advice and scripts to make the plans more efficient.

Professional

The whole kit and kaboodle. Our professional solution includes all the basic functionality plus the ability to automatically optimize your SQL statements using our rewrite engine.

Compare Basic and Professional

Spotlight Tuning Pack Basic FREE

$0

/moth
Billed Annually

Get Spotlight Tuning Pack
Summary of Inclusions
  • Plan Analysis and recommendations for adding indexes
  • Script for adding indexes included
  • Execution Plan viewer that makes understanding the plan easier

 

 

 

 

Spotlight Tuning Pack Professional

$15

/month
Billed Annually

Get Spotlight Tuning Pack
Summary of Inclusions
  • Automated SQL Optimization
  • SQL re-written multiple times to identify most efficient SQL
  • Plan Analysis and recommendations for adding indexes
  • Script for adding indexes included
  • Compare existing and optimized plans
  • Compare existing and optimized SQL
  • View statistics of optimized SQL