• Monitor performance for physical, virtual, and cloud environments.
• Monitor queries and query plans to see the causes of blocks and deadlocks.
• View expert recommendations to optimize performance.
• Alert predictively with settings to avoid false alerts.
• View summary of top issues and alerts.
• Monitor application transactions.
• Optimize SQL queries.

Monitor Performance of Physical, Virtual, and Cloud Environments

Easily monitor and view the performance of physical servers, virtual servers (VMware and Hyper-V), and cloud environments to get a complete view of SQL Server databases. View performance metrics and alerts for virtual machines and their related hosts including CPU, memory, disk usage, network etc. to get a complete performance picture of the SQL server environment.

Monitor Performance of Queries

Identify and monitor inefficient and poor performing SQL queries, batches, statements and stored procedures causing blocks and deadlocks, such as prolonged or most frequent queries or queries consuming unusually high CPU or I/O. Thresholds can be configured on each individual server allowing for greater flexibility, and the interface makes it very easy to see the most costly queries by looking at individual query executions or query signatures.

View Expert Recommendations

View expert recommendations to enhance performance and speed up problem resolutions with built-in tuning advice and best practices developed by SQL Server MVPs. Analysis workflows embed this valuable information. It provides specific guidance to address problem issues including automatic corrective scripts and links to related online content to supercharge SQL Server performance.

Alert Predictively and Avoid False Alerts

Avoid false alarms with adaptive alerting functionality. Set alert thresholds based on built-in historical statistical analysis of server performance data. Present a percentage of likelihood that various events may occur later in the day based on past behavior trends via the embedded heuristic analysis of event trends and behaviors. Be better prepared to diagnose, drill down, and resolve an issue quickly and efficiently.

View Summary of Top Issues and Alerts

Log in from anywhere and quickly check the status of monitored server instances to identify and diagnose issues with the web console. View the current status of monitored instances, drill down into single instance details, view the top occurrences of performance issues, and see a rollup of all active alerts. Customize the display with widgets, a heat map view, and query wait state visualizations. Create any number of individually configured dashboards to address the needs of the entire organization.

Monitor Application Transactions

Monitor query waits, sample SQL continuously, drill down into transaction analysis, view recommendation to improve queries, tune statement plans, and resolve locks and latches with the SQL Workload Analysis add-on. Isolate application problems and receive recommended remedies. View instance properties and alerts, receive prescriptive recommendations for operational diagnosis, analyze workloads for transactional diagnosis, and arrive at a comprehensive root cause analysis.

Optimize SQL Queries

Maximize database and application performance by quickly discovering, diagnosing, and optimizing poor-performing SQL queries with the SQL Query Tuner add-on. Eliminate performance bottlenecks by graphically profiling critical metrics inside the database, relating resource utilization to specific queries, and tuning problematic SQL queries visually.

SQL Workload Analysis and SQL Query Tuner are add-ons to SQL Diagnostic Manager that are part of SQL Diagnostic Manager Pro.