As a SQL Server DBA, you know that the databases you manage are the heartbeat of your company. So, how can you make sure they're always up and running and available to support your critical business applications? We have more than 15 years of expertise managing databases. And, according to IDC, we are the number one independent database development and administration vendor. Based on this, we enable you to quickly and accurately manage SQL Server performance issues.
Spotlight on SQL Server Enterprise delivers simplicity without compromise, with unmatched monitoring, diagnosis, and optimization of SQL Server environments. Spotlight provides intuitive overviews of enterprise health and performance, automated alerts and actions, powerful analysis tools, and mobile device support. You get the data you need to be proactive, so your SQL Server databases are always healthy.
Thanks to Spotlight, DBAs are saving up to 80% of the time they had spent on tasks they had to do. With Spotlight, you get more of your day back for the projects you want to do. Ready to make every second count? See how Spotlight helps you deliver peak performance from your SQL Server environment all day, every day, even when you're not in the office.

This video gives a high-level overview of some of the features available in Spotlight Developer, a free SSMS plugin from Quest. The features highlighted in the video are shown from a developer's perspective, though these tools are traditionally used by DBAs.
Spotlight Developer installation video:
http://quest.com/video/how-to-install-spotlight-developer8121467
For some of the why’s and how’s of Spotlight Developer:
https://www.quest.com/community/b/en/posts/bridge-the-monitoring-gap-with-spotlight-developer
Detailed video on Spotlight Developer’s Query plan analysis:
https://www.spotlightessentials.com/spotlight-developer/query-plan-analysis/video
Related video on SQL Optimizer:
http://quest.com/video/optimizing-sql-server-code-in-toad-for-sql-server8118469

In this short video you'll learn how to install Spotlight Developer, a free tool that helps users of SQL Server Management Studio monitor all their connections via a heatmap, alarms list and realtime diagnostics.