Try Spotlight Cloud ProSign in

    Spotlight Tuning Pack

    Tune your SQL right within SSMS

    Get Spotlight Tuning Pack
    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