Monitor performance for physical, virtual, and cloud environments
Establish criteria for capturing queries and filter the results to analyze the returned queries. Automatically reduce all active queries to signatures with stripped parameters, present all queries exactly as collected, track the history of the
performance of a query over time, and display the queries with the longest wait times.
Configure alerts to inform and warn about approaching issues using custom thresholds. Automatically send an email notification, display a message in the Windows taskbar, write an event to the Windows Event Log, execute a SQL and PowerShell script, escalate to System Center Operations Manager, and more.
Identify and resolve performance problems by generating expert recommendations for improving performance including executable scripts. Target some of the most common areas of performance problems, such as queries, server configuration, security, database objects, memory, and more. The intuitive interface makes this feature accessible to a broad range of users.
Display, diagnose, alert, and report on critical performance statistics from a central point of control. Monitor instances, sessions, queries, resources, databases, and services. Gather diagnostic information in real time with the unique agentless
architecture, and replay historical data.
Continuously check in real-time the availability, health, and performance of SQL Server instances. Analyze metrics across hundreds of instances.
Monitor the performance of physical servers, virtual servers, and cloud deployed servers to get a complete view of the SQL Server environment.
Manage the topology of high availability groups. Monitor and alert on clusters, mirrors, and replication to safeguard instances during failover.
Identify and resolve contention and performance problems of the tempdb system. Check and display the space and performance information of tempdb.
Add custom counters for monitoring and reporting. Include any Windows Performance Monitor counters and any SQL queries for application-specific monitoring.
Monitor and alert on the success, failure, cancellation, and retry of jobs. View all jobs and their last known status, and the complete history of jobs. Also, start and stop jobs.
Collect performance metrics at the level of the operating system using Windows Management Instrumentation, and Object Linking & Embedding.