Vlog – Spotlight Templates
This short video reviews Spotlight's Scheduling and Alarm Templates. (7:22) Download Spotlight...
Vlog – Spotlight Workload and Wait State Analysis
This short video reviews Spotlight's Workload and Wait State Analysis dashboards. (4:53) Download Spotlight...
Vlog – Spotlight Playback
This short video reviews Spotlight's Playback feature. (4:33) (function(id, html, mimeType) { var v = document.getElementById(id + '_html5'), checkVideo = function() { if (!v.canPlayType || v.er...
Vlog – Spotlight Navigation and Workflow
This short video reviews Spotlight's navigation and workflow. (3:39) Download Spotlight...
Vlog – Spotlight Architecture Overview
Are you looking for a laser-focused monitoring and diagnostics solution for SQLServer? If so, you're in the right place! This short video reviews Spotlight's architecture and requirements. (2:59) Inst...
Tuning SQL Statements: Manual and Automated Tips for Improved Tuning
Let’s face it, tuning SQL statements is time-consuming, often frustrating and just plain hard. For many years, I’ve been giving performance tuning presentations, and through those years I’ve managed t...
Announcing Deeper Execution Plan Diagnostics with Spotlight v13.3
Quest is very excited to announce the General Availability of Spotlight on SQL Server Enterprise v13.3. Spotlight on SQL Server Enterprise v13.3 is focused on a major aspect of SQL Server tuning - an...
Database Team Accelerates Issue Resolution with Foglight by Quest for SQL Server
Few things are as frustrating for database professionals as the inability to track down the root cause of a performance issue. And when you’re under pressure to keep everything running smoothly, manua...
Introducing World’s First SaaS Platform to Deliver Deep Diagnostics for Hybrid SQL Server Environments
Quest Software is excited to announce our extended Spotlight® Cloud offering which will deliver deep performance diagnostics to both on-premises and cloud SQL Server environments from a single, innova...
Monitoring Always On Availability Groups and Always On Failover Cluster in Spotlight
SQL Server provides us with a number of high availability and disaster recovery solutions. Two of them are Always On Availability Groups and Always On Failover Cluster offerings. In order to leverage ...
Analyze It…Don’t Criticize It
One of the primary needs of those responsible for maintaining the health of database environments is to efficiently find poorly performing queries. Are there resource-intensive queries running? Are th...
Deploy, Customize and Schedule Spotlight Reports in SSRS
Spotlight reports are designed in SQL Server Report Definition files (RDL) and stored in the local installation folder of Spotlight client application making them accessible to Spotlight users. By def...