SQL Diagnostic Manager

24x7 SQL performance monitoring, alerting and diagnostics

  • Performance monitoring for physical and virtual SQL Servers *Learn More
  • Deep query analysis to identify excessive waits and resource consumption
  • History browsing to find and troubleshoot past issues
  • Adaptive & automated alerting with 100+ pre-defined and configurable alerts
  • Capacity planning to see database growth trends and minimize server sprawl
  • NEW - SCOM management pack for integration with System Center
Watch this video to learn about how SQL Diagnostic Manager can help you to plan, forecast, and stay notified about the status of your SQL Server environment.
Loading the player...

[Your trial is fully functional for 14 days]

Physical and Virtual Performance Monitoring

Easily monitor and view the performance of both physical and VMware server environments
to get a complete view of SQL Server databases. View performance metrics and alerts for VMs
and their related ESX hosts including CPU, memory, disk usage, network, etc. to get a complete performance picture of the SQL Server environment.

Read more about SQL Diagnostic Manager's virtual monitoring capabilities

Query Performance Monitoring

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. The thresholds can be configured on each individual server allowing for greater flexibility. The interface makes it very easy to see the most costly queries by looking at individual query executions (by statement) or by looking at query signatures which roll-up and summarize multiple executions.

History Browsing

Drill down to the precise point-in-time an error occurred to view historical SQL Server and
OS metrics and better understand the multiple factors which could have contributed to an error.

Predictive Alerting

Avoid false alarms with adaptive alerting functionality and set alert thresholds based on
built-in historical statistical analysis of your server performance data.

The system has embedded heuristic analysis of event trends and behaviors and presents a percentage of likelihood that various events are likely to happen later in the day, because there has been a trend in the behavior in the past. This can help the database administrators to be better prepared to diagnose, drill down, and resolve the issue quickly and effectively in case of a problem.

Capacity Planning

Understand trends and view forecasts of your SQL Server environment to better plan for
future needs and get a handle on SQL Server sprawl with database growth reporting.

Mobile Access

Access SQL diagnostic manager from anywhere. Use any mobile device, such as iPhone, Android, Blackberry or Tablet to view real-time and historical SQL Server performance data. Plus, view or kill sessions, start/stop jobs and run queries to resolve or diagnose issues remotely while on-the-go. 

View a demo of SQL diagnostic manager mobile.

*NEW* Integration with SCOM 

The SQL Diagnostic Manager Management Pack provides easy integration with Microsoft’s System Center Operations Manager (SCOM). The Management Pack propagates the current status, health and events of all monitored instances up to Operations Manager, allowing the DBA and IT Operations staff to share data at a higher level across their enterprise. The management pack is easy to install and does not incur any additional monitoring overhead.

Read the FAQ and watch a quick 5 minute video to learn more.

[Give it a try! Your trial is fully functional for 14 days]

With SQL diagnostic manager’s centralized console, filtering capabilities, and data repository, I'm able to see what's happening to all of my SQL Servers now or 2 months ago, with the click of a button. I now have more time to plan and tune my environment -- and it’s a lot easier and faster than trying to collect the data myself.  Great job Idera!

- SQL Database Administrator, Boston Medical Center Health Net Plan

We have been using SQL diagnostic manager since 2003, it's our virtual teammate who never ever sleeps and continuously monitors over the performance of our SQL Server production systems. We especially love the alerting capabilities because it is very reliable, immediate, and allows us to customize the alerts we really need.  It’s much better than any other SQL Server monitoring tools we’ve seen.

- DBA manager, QuickenLoans Inc.

Our company runs primarily purchased, third-party applications. This presents several tuning, troubleshooting, and performance challenges because we did not design the applications.  SQL diagnostic manager gives us both deep and immediately visible performance data that allows us to immediately see what's going on inside the vendors' databases, to diagnose performance issues, and to keep things running smoothly. It’s a great tool.

- Database Administrator, American Management Services