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.
Read the Installation Guide and watch the video.
Install Spotlight Tuning Pack
Learn how to install Spotlight Tuning Pack for SQL Server Management Studio
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.
Spotlight Plan Viewer
The plan viewer makes the navigation and interpretation of complex query plans easy.
See how it examines execution plans and provides advice on optimizing these plans.
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.
To see a list of third party components used by Spotlight Tuning Pack view Spotlight Tuning Pack Third Party Components.