SQL Server Monitoring

SQL Diagnostic Manager

Helps IT Teams Monitor SQL Server Activity

Best-in-Class

SQL Server Reporting

Reduced availability and performance of Microsoft SQL Server can severely impact the critical applications that it supports. SQL Diagnostic Manager for SQL Server provides robust SQL Server monitoring functionality that covers the performance of the entire SQL Server environment and provides the most comprehensive diagnostics on the market.

Three dashboards of SQL Server monitoring within the SQL Diagnostic Manager for SQL Server software
  • Monitor physical, virtual, and cloud environments.
  • Track queries and plans to fix blocks and locks.
  • Alert predictively and avoid false alerts.
  • View expert advice with executable scripts.

With SQL Diagnostic Manager, we have caught more in-progress events and been able to take action before our clients were impacted.

Patrick Hurst, Senior Database Administrator, iQmetrix Software Development Corp.

(small business, computer software, Canada)

SQL Diagnostic Manager provides us with overall better control over our database instances, very useful baselines, and better performance and bottleneck control.

Stefan Haglund, IT Specialist, ltkalmar.se

(state and local government, Sweden)

It has excellent performance and capacity monitoring capabilities that identify historical issues and help with trending.

Tony Hayes, IT Manager, Howdens

(large enterprise, professional services, United Kingdom)

Tata Consultancy Services Limited decreased unplanned downtime and mean time to resolution by more than 75% with SQL Diagnostic Manager.

Marco Antonio Pacheco, IT Administrator, Tata Consultancy Services Limited

(Global 500 company, computer services, Ecuador)

SQL Diagnostic Manager can help to quickly identify query performance issues and generate alerts before problems occur.

Don Mo, SQL Server Administrator, Boston University

(educational institution, USA)
81%

of surveyed customers report improved visibility into database health and performance.

Survey of users of SQL Diagnostic Manager for SQL Server

87%

of customers say they would recommend SQL Diagnostic Manager.

Survey of users of SQL Diagnostic Manager for SQL Server

69%

of customers report greater database administrator efficiency.

Survey of users of SQL Diagnostic Manager for SQL Server

  • Monitor SQL Server

    Monitor SQL Servers 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. Generate reports from your SQL Server database to stay apprised of health and performance.

  • SQL Server Monitoring for Multiple Environments

    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.

  • SQL Server High Availability

    Manage availability groups

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

  • SQL Server TempDB

    Monitor tempdb

    Identify and resolve tempdb contention and performance problems, and check and display the space and performance information of your tempdb.

  • SQL Server Performance Monitoring

    Customize counters

    Tailor your systems’ monitoring and reporting with custom counters. Get application-specific monitoring with Windows Performance Monitor counters and SQL queries. Enable data collection to monitor application performance in real-time.

  • SQL Server Job History

    Manage jobs

    Monitor and alert on your jobs—success, failure, cancellation, or retry. View all jobs and their last known status, and the complete history of jobs. Also, conveniently start and stop jobs from the same interface.

  • Operating System Monitoring

    Monitor SQL Server at an OS-level

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

  • CPU Monitoring

    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.

  • Alert based on best practices

    Get SQL Server monitoring alerts customized for your industry and your enterprise. Choose from over 100 predefined alert settings based on industry best practices. Modify your configuration settings for greater flexibility and optimization.

  • 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.

  • Set up maintenance mode

    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.

  • 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.

  • Quickly deploy alerts across instances

    Easily put your custom alerts in place across your infrastructure. Add and modify metrics to alerts for multiple servers with the default alert configuration and the copy-to operation.

  • 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.

  • 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.

  • View recommendations for alert thresholds

    Avoid alert fatigue. For metrics that always alert, view flags that indicate needed changes—with suggestions for new limits.

  • View locks, blocks, and deadlocks

    For easy problem identification and resolution, view the complete blocking chain by identifying real-time and historical session locks, blocks, bottlenecks, and deadlocks.

  • View activity timelines

    Understand events faster and more intuitively by viewing color-coded performance events on your server on a timeline calendar instead of only as a list of events. Use a sliding scale to zoom in to specific times.

  • View fragmentation

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

  • Run PowerShell scripts

    Get even more control over SQL Diagnostic Manager by deploying Microsoft PowerShell, and automatically respond to alerts with PowerShell scripts.

  • Browse historical data

    Reduce future problems by understanding the multiple factors behind SQL Server database issues. Examine historical trends and drill down to the precise point in time a problem emerged.

  • Set up multiple baselines

    Compare the performance baselines that matter to your business by defining and scheduling multiple baseline periods.

  • Integrate with SCOM

    Share data with IT operations for efficiency by propagating the status, health, and events of monitored instances to Microsoft’s System Center Operations Manager (SCOM).

  • Plan capacity

    Confidently plan the future of your storage infrastructure. View charts and create reports with trends and metrics to help forecast future capacity needs.

  • See overview and drill down

    View your entire environment in the customizable dashboard and drill down to find the root causes of problems, reducing time spent troubleshooting. Get flexible SQL Server monitoring by specifying multiple dashboards per instance.

  • Access on mobile devices

    View real-time and historical performance—and diagnose and resolve performance issues—from anywhere, with smartphone or tablet access.

  • Apply granular application security

    Smoothly address varying access needs with access to your servers and instances via fine-grained security permissions for different groups of people.

  • Deploy for hybrid cloud

    Consolidate vital information and plan for the cloud-centric future by deploying SQL Diagnostic Manager to simultaneously monitor your on-premises databases, databases on cloud virtual machines, and managed cloud databases.

  • Deploy via web browser

    Avoid the installation and maintenance of desktop consoles, and reach a diverse pool of users and endpoints, by deploying SQL Diagnostic Manager access via a web browser.

  • Share configurations

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

  • Report comprehensively

    Gain insights about your data quickly with predefined and customized reports. Report on performance trends and forecasts for capacity planning. Deploy reports to SQL Server Reporting Services using the industry’s best SQL Server reporting software.

  • Install on cloud virtual machines

    Unify your control by running SQL Diagnostic Manager for SQL Server on cloud virtual machines with Windows—such as Amazon Elastic Compute Cloud (EC2) and Azure virtual machines.

  • Monitor SQL Server on cloud virtual machines

    Monitor your SQL Server instances running on cloud virtual machines with virtualization software that is compatible with VMware and Microsoft Hyper-V—such as Amazon EC2 and Azure virtual machines.

  • Monitor hybrid environments with a single tool

    Save time by using the same SQL Server performance monitoring tool for SQL Server databases on-premises (on your physical and virtual machines); in the private, public, and government cloud (on virtual machines); and in the public and government cloud (as managed databases).

  • Access mapped cloud drives

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

  • Monitor managed SQL Server cloud databases

    Extend your cloud capabilities with monitoring for Azure SQL Database and Amazon RDS for SQL Server.

Let’s get started.

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

Commercial licenses are not supported with this trial download. To update to the latest version, please access IDERA’s customer support portal.

If you would like to speak with a representative, then please call +1 (713) 523-4433.

SQL Diagnostic Manager Add-ons

SQL Workload Analysis for SQL Server

Get detailed wait state analysis for applications and transactions with SQL Workload Analysis for SQL Diagnostic Manager

SQL Query Tuner for SQL Diagnostic Manager

Optimize SQL Server queries with SQL Query Tuner for SQL Diagnostic Manager

See how SQL Diagnostic Manager can help you monitor the performance of your entire SQL Server environment.

Datasheet

SQL Diagnostic Manager for SQL Server
Datasheet

Everything you need to know, all in one downloadable PDF

Case Study

University of Notre Dame Leverages Improved SQL Server Performance Analysis

See how SQL Diagnostic Manager allows the University of Notre Dame to anticipate outages before they occur

White Paper

Find and Fix SQL Server Deadlocks

Learn how to monitor, alert, diagnose, and report on SQL Server deadlocks with SQL Diagnostic Manager

Play

Value of SQL Diagnostic Manager for SQL Server

Learn about the benefits of SQL Diagnostic Manager for SQL Server for you and your organization

Webcast

Performance Tune Like an MVP

Daniel Janik shares tips and techniques for how to monitor SQL Server performance

White Paper

The Top 4 Performance Makers and Breakers for SQL Server

Mindy Curnutt discusses the common errors that can make or break database performance metrics in SQL Server

You can view the list of all resources for SQL Diagnostic Manager for SQL Server in the Resource Center.

Frequently-Asked Questions

What is SQL Server performance monitoring?
SQL Server monitoring allows enterprises and database administrators to stay apprised of the health and performance of a server. Monitoring consists of periodic snapshots of current performance, leveraged to quickly identify and pinpoint the root cause of any problems. Idera SQL Diagnostic Manager is a comprehensive SQL Server performance monitoring tool with the most robust diagnostics on the market.
What is SQL Server performance monitoring?
SQL Server monitoring allows enterprises and database administrators to stay apprised of the health and performance of a server. Monitoring consists of periodic snapshots of current performance, leveraged to quickly identify and pinpoint the root cause of any problems. Idera SQL Diagnostic Manager is a comprehensive SQL Server performance monitoring tool with the most robust diagnostics on the market.
What database performance monitoring tools are best?
The best database performance monitoring tools enable database administrators to take a proactive, rather than reactive, approach to server performance. Identifying potential warning signs before they impact performance is critical to overall server health, which is why Idera SQL Diagnostic Manager relies heavily on diagnostics, analytics, and alerts to help enterprises act quickly at the first sign of trouble. In addition, because there’s no one-size-fits-all database performance monitoring solution, the best tools — like Idera SQL Diagnostic Manager — are highly customizable to allow enterprises to build a solution that best fits their needs.
How do I analyze SQL query performance?
Slow-running queries are one of the most common and troublesome pain points for enterprises dealing with large quantities of data, and they’re frequently one of the problems these organizations are most eager to solve with improved SQL Server monitoring. That’s why SQL Diagnostic Manager can be upgraded with SQL Query Tuner, a best-in-class tool specifically designed to target and alleviate this pain point for faster, more efficient queries.
How can you monitor database performance?
There are numerous ways to track database performance, but not all are built equally. Databases are increasingly critical to enterprises’ most important business functions, and as the volume and complexity of data continues to grow, it’s more important than ever to rely on a robust, functional, and advanced database monitoring tool like Idera SQL Diagnostic Manager.
What are the most important metrics for SQL Server performance monitoring?
While there are countless SQL Server metrics that serve as indicators of performance and overall health, most enterprise organizations rely on a handful of KPIs to take the temperature of their database. Some of these metrics include page reads/min, cache hit ratio, top queries by CPU and I/O, average lock wait time, and number of virtual log files, though a comprehensive tool like SQL Diagnostic Manager will allow you to stay apprised of any metric your enterprise deems important to operations.

Learn more about how SQL Diagnostic Manager can help your organization monitor SQL Server activity.