Spotlight® Developer

for SQL Server management Studio
Get it now

Overview

Spotlight Developer for 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 Developer 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 Developer 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

QUERY PLAN ANALYSIS

SQL tuning within SQL Server Management Studio

Everytime you execute SQL we’ll analyze it and let you know if we find any issues that need your attention. We’ll also calculate how much improvement can be acheived by adding an index and provide the script to create it.

This powerful SQL Analysis is combined with a new intuitive execution plan visualization to make it quick and easy to see where the most expensive operations are occuring in your executed SQL.

Learn more about Plan Analysis

CLOUD SERVICES

Want a health check for your environment?

Upload performance data from Spotlight Developer to the Spotlight website and you’ll have access to a cloud-based set of Spotlight productivity tools to gain insight into the health of your SQL Server environment.

Learn more about Spotlight health checks

Spotlight Developer
FREE

Sign up now

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

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.