Try Spotlight Cloud ProSign in

Documentation for Spotlight Tuning Pack

For SQL Server Management Studio

Spotlight Extensions currently includes the Spotlight Tuning Pack a powerful tool for Query Plan Analysis and SQL Optimization within SSMS. Documentation about how to get Spotlight Extensions up and running is available below.

Spotlight Tuning Pack

Is your SQL running slower than you'd like it to? Tune it SQL within SQL Server Management Studio (SSMS) using our Spotlight Tuning Pack.

Identify issues in your SQL Statements and optimize  them to improve execution time.

For information about the features in the Spotlight Tuning Pack and how to get started please see the details below.

Watch these short videos to get up and running

install-thumbInstalling Spotlight Extensions
Learn how to install Spotlight Extensions for SQL Server Management Studio


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 Extensions 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 Extensions 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 Extensions view Spotlight Extensions Third Party Components.