Sign in

Documentation for Spotlight Tuning Pack

Spotlight Tuning Pack is a powerful tool for Query Plan Analysis and SQL Optimization within SSMS (SQL Server Management Studio). Is your SQL running slower than you'd like it to? Tune SQL within SSMS using Spotlight Tuning Pack. Identify issues in your SQL Statements and optimize them to improve execution time.

Which Spotlight Tuning Pack is right for you? See Compare Plans and Pricing.

View and update your current subscription.

Download and install the Spotlight Tuning Pack

Read the Installation Guide and watch the video.

install-thumbInstall Spotlight Tuning Pack
Learn how to install Spotlight Tuning Pack for SQL Server Management Studio

 

Using the Spotlight Tuning Pack

Launch SSMS and sign in with your Quest account to use Spotlight features.  If you don't have a Quest account, sign up. It only takes a second.

Plan-viewerSpotlight Plan Viewer
The plan viewer makes the navigation and interpretation of complex query plans easy.

 

Plan-advisor-thumbPlan Advisor
See how it examines execution plans and provides advice on optimizing these plans.

 

sql-optimizer-thumbSQL Optimization
We'll show you how our AI engine rewrites your SQL to reduce execution time.

 

If possible, we recommend that Spotlight Tuning Pack be run on Windows 10, Windows Server 2016 or Windows Server 2019 as older operating systems (Windows 7, Windows 8 and Windows Server 2012) fall back to using TLS 1.0 which can introduce an encryption weakness.  Running Spotlight Tuning Pack on Windows 10, Windows Server 2016 or Windows Server 2019 utilizes TLS 1.2, eliminating the older and weaker TLS protocols.

 

Third Party Components

To see a list of third party components used by Spotlight Tuning Pack view Spotlight Tuning Pack Third Party Components.