Idera SQL diagnostic manager Pro

Easily monitor and view the performance of both physical server and VMware or Hyper-V virtual server 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.

Identify and monitor inefficient and poor performing SQL queries, batches, statements and stored procedures causing blocks and deadlocks, such as long 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.

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. Combine the operational monitoring from SQL Diagnostic Manager and transactional monitoring with SQL Workload Analysis to view instance properties and alerts, receive prescriptive recommendations for operational diagnosis, analyze workloads for transactional diagnosis, and arrive at a comprehensive root cause analysis.

Key Points

Product Features