SQL Diagnostic Manager

Find and fix database performance problems
for SQL Server and MySQL on-premises and in the cloud

for SQL Server START FOR FREE
for MySQL

START FOR FREE
  •  
  • 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 Azure SQL Database and Amazon RDS for SQL Server

Find query bottlenecks

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.

Alert predictively

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.

View expert advice

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.

View top issues and alerts

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.

 
PERFORMANCE MONITORING

Monitor and analyze continuously

Continuously check in real-time the availability, health, and performance of SQL Server instances. Analyze metrics across hundreds of instances.

Deploy for physical, virtual, & cloud environments

Monitor the performance of physical servers, virtual servers, and cloud servers to get a complete view of the SQL Server environment. Monitor Azure SQL Database and Amazon RDS for SQL Server.

Manage availability groups

Manage the topology of high availability groups. Monitor and alert on clusters, mirrors, and replication to safeguard instances during failover.

Monitor tempdb

Identify and resolve contention and performance problems of the tempdb system. Check and display the space and performance information of tempdb.

Customize counters

Add custom counters for monitoring and reporting. Include any Windows Performance Monitor counters and any SQL queries for application-specific monitoring.

Manage jobs

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.

Monitor operating systems

Collect performance metrics at the level of the operating system using Windows Management Instrumentation, and Object Linking & Embedding.

ALERTING

Alert based on best practices

Choose from over 100 predefined alert settings based on industry best practices. Modify configuration settings for greater flexibility.

Quickly deploy alerts across instances

Add and modify metrics to alerts for multiple servers with the default alert configuration and the copy-to operation.

Alert to different audiences

Send alerts to different groups of people based on metrics, time-of-day, instance, and more with advanced notifications.

Alert from baselines

Capture baselines of past performance to configure baseline alerts that automatically calibrate to changes to avoid excessive noise and false positives.

View recommendations for alert thresholds

For metrics that constantly alert, view flags that indicate needed changes with suggestions for new limits.

Smooth and snooze alerts

Prevent recurring alerts while problems are being worked on by snoozing alerts. Delay the first alert by smoothing problematic metrics that occasionally spike.

Set up maintenance mode

Disable monitoring and alerting during maintenance periods for on-demand, one-time, and weekly scheduled maintenance periods to avoid false positives.

Automate alert response actions

Set up automated alert response actions for system notifications, email, SQL scripts, PowerShell scripts, and more.

DIAGNOSTICS AND ANALYTICS

View locks, blocks, and deadlocks

Identify real-time and historical session locks, blocks and deadlocks and view the complete blocking chain for easy identification and resolution.

Browse historical data

View historical trends and drill down to the precise point-in-time a problem occurred to understand better the multiple factors that may contribute to the problem.

View activity timelines

Visualize server performance events as a timeline calendar instead of only as a list of events. View color-coded events. Use a sliding scale to zoom in to specific times.

Set up multiple baselines

Define and schedule several baseline periods to differentiate various situations. View baseline performance and compare baselines.

View fragmentation

View statistics on fragmentation to identify indexes that may need defragmentation to remedy one of the most common causes of performance degradation.

Integrate with SCOM

Propagate the status, health, and events of monitored instances up to Microsoft’s System Center Operations Manager (SCOM) to share data with IT operations.

Run PowerShell scripts

Use Microsoft PowerShell scripts to manage SQL Diagnostic Manager. Also, run PowerShell scripts for automatic alert response actions.

Plan capacity

View charts and create reports with trends and forecasts of metrics to plan for future capacity needs.

ENTERPRISE MANAGEMENT

See overview and drill down

View entire environments in the customizable dashboard and drill down to find the cause of problems. Also, specify multiple dashboards per instance.

Deploy via web browsers

Deploy SQL Diagnostic Manager via web browsers to large and diverse audiences to avoid the installation and maintenance of desktop consoles.

Access on mobile devices

Access SQL Diagnostic Manager remotely from anywhere with smartphones and tablets to view real-time and historical performance, and to diagnose and resolve performance issues.

Share configurations

Export and import configuration files to share customized dashboards, counters, alert templates, and reports with other users across the organization.

Apply granular application security

Set up the access to servers and instances via fine-grained security permissions for different groups of people.

Deploy agentless and with low impact

Deploy SQL Diagnostic Manager without installing anything on monitored systems. Monitor production systems with low impact and risk.

Report comprehensively

Create predefined and customized reports. Report on performance trends and forecasts for capacity planning. Deploy reports to SQL Server Reporting Services.

Deploy for hybrid cloud

Deploy SQL Diagnostic Manager to monitor on-premise databases, databases on cloud virtual machines, and managed cloud databases.

CLOUD

Install on cloud virtual machines

Run SQL Diagnostic Manager for SQL Server on cloud virtual machines with Windows – such as Amazon Elastic Compute Cloud (EC2) and Azure Virtual Machines (VMs).

Access mapped cloud drives

SQL Diagnostic Manager for SQL Server can access cloud storage that is mapped as network drives or removable drives on Windows. For example, map to Amazon Simple Storage Service (S3) and Azure Blob Storage.

Monitor SQL Server on cloud virtual machines

Monitor instances of SQL Server running on cloud virtual machines with virtualization software that is compatible with VMWare and Microsoft Hyper-V – such as Amazon EC2 and Azure VMs.

Monitor managed SQL Server cloud databases

Monitor the managed SQL Server cloud databases Azure SQL Database and Amazon RDS for SQL Server.

Monitor hybrid environments with a single tool

Avoid learning new tools by using the same performance monitoring tool for SQL Server on-premise on physical and virtual machines, in the private, public, and government cloud on virtual machines, and in the public and government cloud as managed databases.

Since using SQL Diagnostic Manager for SQL Server Howdens’s organization has experienced reduced risk and increased confidence with migrating to databases to the cloud.
Tony Hayes, IT Manager, Howdens
(Large Enterprise, Professional Services, United Kingdom, 100 to 499 SQL Server Databases) TVID B6D-0B3-B6B
  •  
  •  
  •  
  •  

Resources

SQL Diagnostic Manager Datasheet

Everything you need to know, all in one downloadable PDF

DOWNLOAD DATASHEET

SQL Diagnostic Manager Case Study

See how a family-owned recycling company streamlined SQL Server management

DOWNLOAD CASE STUDY

SQL Diagnostic Manager for the Hybrid Cloud

Learn how to monitor SQL Server performance in the cloud

DOWNLOAD SOLUTION BRIEF

Why Use SQL Diagnostic Manager?

Get excellent SQL Server performance with SQL Diagnostic Manager

VIEW INFOGRAPHIC

Five Key Features of SQL Diagnostic Manager

Join IDERA and Mark Slavens as he demonstrates SQL Diagnostic Manager key features

VIEW WEBCAST

Compare SQL Server Monitoring Tools

See key features and functionalities of the top SQL Server monitoring tools the market has to offer

COMPARE NOW
SQL Diagnostic Manager

Cover all your bases with
SQL Diagnostic Manager PRO

For more advanced application transaction monitoring and SQL query optimization capabilities, consider SQL Diagnostic Manager Pro, which includes the SQL Workload Analysis and SQL Query Tuner add-ons.

Learn More →

Platform Support

Version History
  • General: Microsoft Windows with .NET Framework and Internet Explorer
  • Repository: Microsoft SQL Server on Windows and Linux
  • Monitored Database Instances: Microsoft SQL Server on Windows and Linux, Microsoft Azure SQL Database, Amazon RDS for SQL Server
  • Mobile Console Server: Microsoft Windows with .NET Framework and Internet Information Services
  • Mobile Devices: Google Android, Apple iOS, BlackBerry RIM, Microsoft Windows Phone
  • Desktop Devices: Microsoft Internet Explorer, Google Chrome, Mozilla Firefox, Microsoft Edge
  • Cloud: SQL Diagnostic Manager runs on cloud virtual machines (such as Microsoft Azure VM and Amazon EC2) with Microsoft Windows. It monitors Microsoft SQL Server instances on cloud virtual machines (such as Microsoft Azure VM and Amazon EC2). It supports managed cloud databases (that is, Microsoft Azure SQL Database and Amazon RDS SQL Server).
more details

SQL Diagnostic Manager for SQL Server does not require the installation of any additional databases, dynamic-link libraries (DLLs), scripts, stored procedures, and tables on the monitored SQL Server instances.

SQL Diagnostic Manager for SQL Server Version History

Version 10.4

  • Visual query plan in desktop console
  • Improved extended event estimated plan collection
  • Exploit SQL Server's Query Store for query and plan collection
  • Improved web console
  • Support SQL Server 2019 CTP (experimental) for monitoring and repository

Version 10.3

  • Reduced privilege requirements for monitoring
  • New Operator security role in between Read Only and Instance Admin roles
  • Added grooming and aggregation options
  • Support SQL Server 2017 for Windows & Linux

Version 10.2.2

  • New Session Details report
  • Improved IDERA Dashboard performance and install experience

Version 10.2

  • Improved time-based drill-down
  • Refined history range control
  • Optimized performance for scalability and user productivity
  • Various bug fixes

Version 10.1

  • Global tags and improved installation flow in IDERA Dashboard
  • Configuration of heatmap calculation to modify coefficients and weigh the importance of instances by tags
  • For PowerShell integration: Query plan collection, enabling and disabling of query waits, administrator functionality (such as the friendly name of a certificate and the job activity monitor), and alert response actions
  • Response actions for query waits
  • Independent scheduling of baselines
  • Generation of SCOM alerts and events
  • Support for SQL Server 2016

Version 10.0

  • Integrated SQL Doctor expert recommendations
  • Multiple baselines
  • Federated overview screens
  • New Alert timeline view by category
  • Dashboard enhancements
  • User defined dashboards
  • 18 new widgets
  • Collapsible side panels
  • Improved Heat Map view
  • Query waits by time and duration
  • Multiple DB selections including TempDB
  • Bug fixes and enhancements

Version 9.1

  • Export and import configuration files to share custom counters, reports, and alert templates
  • Alerting for filegroup space used
  • New dashboard widgets to aggregate statistics across multiple instances across Diagnostic Manager repositories
  • Improved instance overview and heatmap views
  • New custom reports for top 10 lists for metrics
  • Monitoring additional SQL Server services
  • Bug fixes and enhancements

Version 9.0

  • Enhanced query plan monitoring and diagnostics - SQL DM now captures query execution plans and provides new query plan viewing and diagnostic capabilities
  • The new Main query view provides high-level query performance information across applications, databases, and users with drill down capabilities into individual queries with two additional new views
  • Query details view shows SQL text, execution plan XML, and a graphical view of the execution plan
  • Query signature view rolls matching queries into a query signature
  • Official release of the SQL DM web dashboard - The web dashboard capabilities that were introduced in DM 8.5 as a tech preview are officially released in DM 9.0. There are three primary views; Today, Top X, and Alerts
  • Today includes status of instances and groups with drill down into single instances. It shows active alerts, top issue occurrences, and can show data by thumbnail, list, and heat map views
  • Top X provides a number of configurable widgets to show the top occurrences of various performance issues
  • Alerts rollup all active alerts being generated with detailed viewing, filtering, and grouping capabilities
  • Bug fixes and enhancements

Version 8.6

  • SQL Server Express Support - SQL DM has extended support to cover the SQL Server Express edition
  • New database alert for Availability Group Preferred Replica - SQL DM triggers an alert whenever the primary role changes to a different replica
  • Query Waits Enhancements
  • New Query Wait Statistics Report
  • Query Waits information is now extended in the Top Servers and Top Databases reports

Version 8.5

  • Hyper-V support - SQL DM has extended virtual support to Hyper-V, providing insight into the performance of your virtual system more effectively. Users can track and monitor Hyper-V specific performance metrics for a complete view of the virtualized server and the physical host.
  • Ability to set up Alert Response that is triggered only after multiple user defined metric thresholds have been breached
  • Inclusion filters for Query monitors – Adds the ability to do query monitoring on selected applications
  • Tech Preview of the new SQL DM Web Console - Rapidly and easily identify problems. The SQL DM web console is designed to provide quick access to the overall status of the SQL Server environment to help diagnose any issues.
  • Quickly view status of a single instance or instance groups
  • Access from any connected browser. No SQL DM Desktop Console required
  • Stand-alone web application with no need for IIS
  • Provide an easy to use web console to non-DBAs without giving access to entire management console so they can check on status for SQL Server environment.
  • Bug fixes and enhancements

Version 8.0

  • SQLdm Management Pack for Microsoft's Systems Center Operations Manager - integrates the key monitors and alerts of SQL Server performance metrics from SQL dm into Microsoft's System Center console.
  • Always-On availability group monitoring – SQLdm will monitor the performance of Always-On availability groups that are set up and will send alerts as needed to ensure the SQL Server is running on the designated node in the event of failover to a secondary replica. This feature includes a high-level view, 8 new alerts, and 2 reports. SQL dm can also run on an availability group as well.
  • Auditing configuration changes - audit configuration changes that show up in the change log as an event to keep track of what users are doing. These changes are also captured in a new report to provide an audit trail if needed.
  • Experimental Support for SQL Server 2014 - SQLdm has been tested to work with pre-release copies of SQL Server 2014. Any possible areas where monitoring works unexpectedly are noted in the documentation.
  • Manageability and scalability enhancements - performance improvements have been made to the repository, reporting and alerting so data is inserted more quickly.

Version 7.5

  • New Server Dashboard Panel Gallery and Templates - Users can customize their Server Dashboard to see the performance information that is the most relevant for their environment. Dashboards can be saved as templates and shared across servers or among console users.
  • Server Activity Timeline - Visualize server performance events in the form of a timeline calendar—instead of simply as a list of events—to identify trends and streamline diagnostics and resolution. Events are color-coded for easy differentiation on the timeline, with a sliding scale at the bottom to zoom in to a desired timeframe.
  • Enhanced Performance Baselines - Define and report on SQL Server performance baselines. Users can view the Server baseline performance values and compare a server's baseline over time ranges, as well as across different servers. Reports will now show the baseline in the given performance metric's graph or chart, allowing for better capacity planning for new servers.
  • Per-Database and Per-Disk Alerts - Users can now get alerts on such items as OS Disk Full, OS Database Full, and OS Log Full shown for specific sizes in GBs or MBs as well as a percentage of the total size of the database.

Version 7.2

  • Monitoring SQL Server Virtual Environments - Get complete insight into the performance of your virtualized SQL Server databases. Monitor and track VMware specific performance counters allowing you to get a complete performance picture of the SQL Server environment.
  • SQLdm Mobile views - New server dashboard specifically for tablets and incorporated VMware monitoring data.
  • SQL Server 2012 Support

Version 7.1

  • New SQL Server Dashboard - Completely redesigned dashboard dramatically expands the display of the performance data simplifying the display of the overall health of a SQL Server.
  • New tempdb Monitoring - Quickly identify and resolve tempdb performance related issues with our new tempdb monitoring and diagnostic views.
  • New SQLdm mobile views - Three new views make diagnosing performance issues while you're on-the-go even easier.
  • Blocking Chain View
  • Sessions > Top Wait Consumers View
  • tempdb Monitoring View

Version 7.0

  • New SQL diagnostic manager Mobile - New web interface displays real-time SQL Server performance data on a wide-variety of mobile devices including iPhone/iPad, Android, Blackberry, Windows 7 Phone.
  • New Idera Newsfeed - New revolutionary technology uses social networking paradigms to build a community of users and SQL Server system objects. Enables more effective collaboration, communication, management and faster problem resolution.
  • New Alert Templates - Easily save default alert settings into an alert template that can be quickly applied to an individual or group of SQL Servers.
  • Informational Alerts - Accurately represent the overall health of your servers by specifying particular alerts as 'informational'.

Version 6.6

  • Identify Database File Disk Activity – Immediately identify and track which database files are causing the most disk activity to be performed on a particular drive.
  • Monitor Additional Job Statuses and Steps - Monitor additional job completion statuses such as success, retries, as well as, complete job step monitoring.

Version 6.5

  • Predictive Alerting – Prevent SQL Server performance problems by finding out what alerts are likely to occur in the next 12 hours, based on past performance and current activity.
  • Enhanced Query Monitoring – Easily identify worst performing queries for a particular system resource such as CPU, I/O, Reads, or Writes and drill down to view the query details and history.
  • SNMP Traps – Capture and send SNMP alerts to a Network Management System, allowing for easy integration with enterprise monitoring solutions.

Version 6.2

  • Additional Disk Counters - Collect, alert on and display Disk Reads/Writes/Transfers per Second.
  • Customizable Views - Customizable disk view allows users to select the disk performance counters that are most relevant to their particular environment.
  • Identify Server Resource Bottlenecks - Quickly determine which resources the server is waiting on throughout the day and causing the biggest bottleneck on your system.
  • Identify Query Resource Bottlenecks - Immediately identify what databases, application, statements, or users are waiting the most for resources and what particular wait stat is the biggest bottleneck.

Version 6.1

  • Enhanced Cluster Monitoring - Quickly respond to cluster failovers with our new cluster monitoring alerts. Be notified when the active node of a clustered server changes or the SQL server active node is not the preferred configuration. Eliminates the need for additional cluster monitoring solution for SQL Server.
  • Deadlock Monitoring (SQL 2005/2008 only) - Receive notification about deadlocks, no matter when they occur. SQL diagnostic manager will then let you see the deadlocked details and easily export the details to a deadlock XML (.xdl) file.
  • Enhanced Replication Environment Monitoring - Track performance in your replication environment with our revised and enhanced monitoring method and new management view. View the overall replication environment topology and key replication performance metrics.

Version 6.0

  • Automated Problem Resolution and Alert Integration - Automatically takes corrective action in response to receiving an alert saving time and improving productivity.
  • Perform backup to truncate logs in response to an alert the log file is full
  • Turn on Query Monitor in response to high SQL Server CPU usage
  • Launch a particular program to synchronize alerts with a help desk or other monitoring application
  • Reports 2.0 - New reporting interface, as well as enterprise and server summary reports, forecasting reports, interactive drill-down, automatic integration with SQL Server Reporting Services, and Email Scheduling.
  • Monitor Database Mirroring Environment - Monitor mirrored databases and notify users of changes in role or performance issues affecting their mirroring environment.
  • PowerShell Snapin - Quickly and easily script many of the SQL diagnostic manager management tasks using the new PowerShell Snapin.

Let's get started.

Start your 14-day trial, no credit card required (but all fields are)

*
*
*
*
*

Purchase Now

Includes first year of maintenance.
Volume discounts available.

Add to Cart request a quote

Product Demo

See SQL Diagnostic Manager
in action with a seasoned pro.

Request a Demo