24×7 monitoring and diagnostics
Agentless monitoring from a centralised diagnostic server for a single view across multiple clients, with alarms and notifications when performance deviates from pre-set operating thresholds.
Simplicity without compromise
Install quickly and easily with a highly intuitive user interface and heat map to access powerful capabilities for instant prioritization of critical needs.
Powerful root cause analysis
Create multiple diagnostic workflows, including detailed wait state/workload analysis and deadlock detection, with over 70 diagnostic drilldowns.
Never miss a beat with playback and mobile
Rewind your dashboards and diagnostic drilldowns to the time an incident occurred and step through it in slow motion. Monitor your SQL Server environment anywhere, anytime and run SQL Server diagnostics directly from your mobile device or web browser.
Analyse workload elements and wait stats by database, application, user, host or SQL statement. Establish top SQL. Drill down to determine the biggest contributors to the SQL Server workload.
Get the complete picture
Context-specific dashboards and drilldowns for the SQL Server instance, the underlying operating system, the VM layer, replication, analysis services, SQL Azure and high availability.
Customise for your environment
Set custom thresholds or create counters specific to your environment. Create rule-based custom actions or define planned outages on a one-time or recurring basis.
Tool of choice
Integrate with enterprise monitoring or issue tracking systems. Use the SCOM management pack to easily integrate Spotlight as the tool of choice for your SQL Server needs.
SQL analysis and Xpert tuning
Utilize the integration with SQL Optimizer to highlight long-running queries and suboptimal code. Immediately tune, benchmark and investigate indexing strategies.
Historical trending and reporting
Understand the health, activity and capacity trends of your SQL Server environment with integrated management and performance views and client-side reports.
System health check and collective intelligence
Obtain a holistic view of the health of your system and benchmark results with other users.