Performance Monitoring

Your Search for the Best Database Admin Tool Ends Here. 

IDERA SQL Diagnostic Manager 

helps IT teams of all sizes monitor their data estates’ performance more efficiently

SQL Server Performance Monitoring

Your job is to keep things running smoothly, no matter what. SQL Diagnostic Manager can help.

You have a lot on your plate, and it’s hard to make any real progress when you’re distracted by minor issues, false alerts, or trying to bring things back online in the middle of the night. Reduced availability and performance of SQL Server can severely impact the business-critical applications that it supports. You need a tool that can help you see what’s really going on in your environment, prioritize the tasks that need your attention today, and tackle the smaller issues that can be resolved through automation.

We help you focus on what really matters

Get access to reliable, real-time information on the status and health of your environment. With the help of our diagnostic tool, you can quickly pinpoint and resolve performance issues. When SQL Diagnostic Manager handles the performance speedbumps that normally derail your day, you can focus on tackling more important tasks on your to-do list.

Find out about issues before they become problems:

  • Automate responses to issues that don’t require hands-on attention.

  • Calibrate to baseline performance to avoid false positives.

  • Make database disasters easier to avoid

  • Your job is to keep things running smoothly, no matter what. SQL Diagnostic Manager can help.

  • Performance Monitoring

Monitor SQL Server and analyze continuously

Know at a glance the real-time availability, health, and performance of your SQL Server instances. Spot issues fast with metrics analysis across hundreds of instances.

Monitor tempdb

Know at a glance the real-time availability, health, and performance of your SQL Server instances. Spot issues fast with metrics analysis across hundreds of instances.

Manage availability groups

Efficiently manage the topology of high-availability groups. Even during failover, get monitoring and alerting on your clusters, mirrors, and replication.

Deploy for physical, virtual, and cloud environments

Ensure continuity by monitoring the performance of physical servers, virtual servers, and cloud servers to get a complete, continuous view of your SQL Server environment.

Monitor operating systems

Collect performance metrics for all your systems at the operating system level using Windows Management Instrumentation, and Object Linking & Embedding

Monitor CPU and memory usage

Avoid bottlenecks and deadlocks with CPU, disk space, and memory usage alerts indicating an unusually high amount of usage by SQL Server.

SQL Server Alerts

Alert based on best practices and get SQL Server monitoring alerts customized for your industry and your enterprise. Choose from over 100 predefined alert settings based on industry best practices.

Smooth and snooze alerts

Help DBAs work without distraction. SQL Diagnostic Manager can smooth problematic metrics that occasionally spike, to delay the first alert and save you stress. Snoozing alerts prevents intrusive, recurring alerts while addressing problems.

Alert to different audiences

Get the message out to the right people. Advanced notifications let you send alerts to different groups of people based on metrics, time-of-day, and instance.

Avoid false positives by selectively disabling SQL Diagnostic Manager SQL Server monitoring and alerting during maintenance periods for on-demand, one-time, and weekly scheduled maintenance periods.

Set up maintenance mode

Automate alert response actions

Give your DBAs more ways to respond, with customized, automated alert-response actions for system notifications, email, SQL scripts, PowerShell scripts, and more.

Alert from baselines

Know your business reality: Capture baselines of past performance to configure baseline alerts that automatically calibrate to changes within your system to avoid excessive noise and false positives.