Spotlight® Extensions

for SQL Server management Studio
Download now

Overview

Spotlight Extensions for SQL Server Management Studio

Two great tools in one great extension

Spotlight Extensions for SQL Server Management Studio includes two great tools: Spotlight Developer and the Spotlight Tuning Pack. Spotlight Developer provides powerful monitoring and diagnostics and the Spotlight Tuning Pack gives you unparalleled Query Plan analysis and automated SQL Tuning.

It's FREE to use the monitoring, diagnostics and Query Plan analysis functionality. Simply download and install to begin.

Learn more about Spotlight Developer Learn more about the Spotlight Tuning Pack

Spotlight Developer

Monitoring and Diagnostics within  SQL Server Management Studio

Monitor all your SQL Server connections for FREE

Users of SQL Server Management Studio can monitor all their connections via a heatmap, alarms list and realtime diagnostics for FREE.

Once installed and configured, users can monitor their connections immediately. The powerful monitoring features communicate important information regarding the status of connections. Severity is color coded so it’s easy to see at a glance what needs your attention.

Following customer feedback we’ve also made it easy to connect Spotlight Extensions to your Spotlight on SQL Server Diagnostic Server. This makes it possible for you to take advantage of data collections for all your connections in Spotlight on SQL Server.

You also get a FREE System Health Check, Performance Health Analysis and comprehensive information about your most expensive queries.

Spotlight Extensions monitors SQL Server 2008, 2008r2, 2012, 2014 and 2016. However it can only be installed in SSMS versions 2012, 2014 and 2016

View Frequently Asked Questions Installation Guide

Spotlight Tuning Pack

Optimization results and plan visualization

SQL tuning within SQL Server Management Studio

We’ll analyze your SQL right within SQL Server Management Studio. The analysis will indicate whether the Query Plan can be tuned to improve performance, or whether the SQL Statement can be rewritten to optimize its efficiency.

If the SQL is a candidate for optimization you simply click the "Optimize" button and our rewrite engine creates a number of variations of the SQL. From these variations we then select the SQL that improves execution time the most and display the results for you to review.

Learn more about Plan Analysis Learn more about optimizing your SQL
9

Spotlight Extensions
FREE

Download now

You can now monitor your server connections for FREE within SQL Server Management Studio using Spotlight Extensions.

Spotlight on SQL Server Enterprise
Enterprise

Sign up now

Spotlight on SQL Server Enterprise delivers simplicity without compromise by providing unmatched monitoring, diagnosis and optimization of your SQL Server environments, ensuring peak performance around the clock.

Spotlight
Mobile

Sign up now

Anywhere , Anytime, from any device

Spotlight on SQL Server Enterprise users can now monitor remotely via mobile devices at no additional cost! Using your favorite mobile device, you can view a heatmap of your connections, see all of your alarms and snooze or acknowledge them.