Ensure peak performance around the clock with unmatched monitoring, diagnosis and optimization of SQL Server environments. Spotlight provides access to the details you need for optimal fitness of your SQL Server databases. Get intuitive overviews of health and performance, automated alerts and actions, and mobile device support.
Establish around-the-clock agentless monitoring from a centralized diagnostic server for a single view across multiple clients, with alarms and notifications when performance deviates from pre-set operating thresholds.
Install quickly and monitor large environments easily. Template configurations, automated alerts and customizable actions make configuration a breeze. Intuitive overviews and mobile device support deliver the data you need where and when you need it.
Create multiple diagnostic workflows, including detailed wait stat/workload analysis and deadlock detection, with over 70 diagnostic drilldowns. Correctly recognize the symptoms to correctly deal with the root cause of any diagnostic challenge.
Get a complete picture of everything that affects your SQL Server performance including SQL Server itself, the underlying operating system, its VM layer, SQL Azure, high availability, replication and analysis services — all available in one package for one price.
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.
Analyze 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.
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.
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.
Utilize the integration with SQL Optimizer to highlight long-running queries and sub-optimal code. Immediately tune, benchmark and investigate indexing strategies.
Understand the health, activity and capacity trends of your SQL Server environment with integrated management and performance views and client-side reports.
Obtain a holistic view of the health of your system and benchmark results with other users.
Users of PagerDuty can now send Spotlight alarm notifications to a PagerDuty dashboard.
For large-scale SQL Server deployments, Spotlight provides custom views and template configuration to make monitoring your environment easy at any scale.