Comprehensive SQL Server Monitoring | SQL Diagnostic Manager for SQL Server

Performance Monitoring
Alerting
Diagnostics and Analytics
Enterprise Management
Cloud

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.
Customize counters

Tailor your systems’ monitoring and reporting with custom counters. Get application-specific monitoring with Windows Performance Monitor counters and SQL queries.
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.
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.
Manage availability groups

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

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

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

Alert based on best practices

Get 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.
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 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.
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.
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.
Automate alert response actions

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

Help admins 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.
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, and deadlocks.
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.
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.
Set up multiple baselines

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

Quickly remedy one of the most common causes of performance degradation: View statistics on fragmentation to identify indexes that may need defragmentation.
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).
Run PowerShell scripts

Get even more control over SQL Diagnostic Manager by deploying Microsoft PowerShell, and automatically respond to alerts with PowerShell scripts.
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 causes of problems. Get flexible SQL Server monitoring by specifying multiple dashboards per instance.
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.
Access on mobile devices

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

Export and import configuration files to efficiently share customized dashboards, counters, alert templates, and reports with other users across your organization.
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.
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.
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.

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.
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 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 managed SQL Server cloud databases

Extend your cloud capabilities with monitoring for Azure SQL Database and Amazon RDS for SQL Server.
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).

Monitor, alert, diagnose, and report on database availability and performance

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, 1,000 or more SQL Server databases

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 & Local Government, Sweden, 100 to 499 SQL Server databases

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, 100 to 499 SQL Server databases

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, 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

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

of customers say they would recommend SQL Diagnostic Manager.

of customers report greater database administrator efficiency.

Monitor SQL Servers and analyze continuously

Customize counters

Deploy for physical, virtual, and cloud environments

Manage jobs

Manage availability groups

Monitor operating systems

Monitor tempdb

Alert based on best practices

Quickly deploy alerts across instances

Alert to different audiences

Alert from baselines

Set up maintenance mode

Automate alert response actions

Smooth and snooze alerts

View recommendations for alert thresholds

View locks, blocks, and deadlocks

Browse historical data

View activity timelines

Set up multiple baselines

View fragmentation

Integrate with SCOM

Run PowerShell scripts

Plan capacity

See overview and drill down

Deploy via web browser

Access on mobile devices

Share configurations

Apply granular application security

Report comprehensively

Deploy for hybrid cloud

Install on cloud virtual machines

Access mapped cloud drives

Monitor SQL Server on cloud virtual machines

Monitor managed SQL Server cloud databases

Monitor hybrid environments with a single tool

Let's get started.

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

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

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

SQL Diagnostic Manager for SQL Server Datasheet

University of Notre Dame Enriches Student Services

Find and Fix SQL Server Deadlocks

Five Key Features of SQL Diagnostic Manager for SQL Server

Performance Tune Like an MVP

The Top 4 Performance Makers and Breakers for SQL Server

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