Database Performance Monitoring for SQL Server

SQL Diagnostic Manager for SQL Server

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

Continuous Monitoring and Analysis

Continuously monitor with real-time analysis of SQL Server and OS health and performance metrics across hundreds of SQL Servers enterprise-wide, including clustered configurations.

Physical, Virtual, and Cloud Database Monitoring

Easily monitor and view the performance of physical servers, virtual servers, and virtual servers (VMware and Hyper-V) to get a complete view of SQL Server databases. View performance metrics and alerts for virtual machines and their related hosts including CPU, memory, disk usage, network etc. to get a complete performance picture of the SQL server environment.

Availability Group Monitoring

Manage the topology of high availability (HA) groups. SQL Diagnostic Manager monitors the performance of AlwaysOn Availability Groups that are set up and will send alerts as needed to ensure SQL Server is running on the designated node in the event of failover to a secondary replica. It can also run on an Availability Group as well.

Tempdb Monitoring

Quickly identify and resolve tempdb database contention and performance related issues with tempdb monitoring and its diagnostic views. Monitor and display the tempdb space and performance related information including tempdb file space, tempdb version store, session space usage of tempdb, and waits related to tempdb.

Custom Counters

Add an unlimited amount of custom counters in the monitoring process. These include any perfmon counters or any SQL queries (which can enable advanced application specific monitoring) that can be added to the list of already existing industry specified counters that SQL Diagnostic Manager will monitor. This information is also stored in the repository so a custom report can be created and stored to capture this data.

Job Management & Monitoring

Monitor and alert on job success, failure, cancelled or retry events. The Jobs view displays all jobs, their last known status, complete job history and allows users to start/stop jobs.

Monitor Replication & Mirrored Environments

Easily monitor performance problems with your mirrored or replication environments. The system also provides alerts and real-time diagnostic views to help with troubleshooting in these environments.

Monitor OS Metrics

Collect OS performance metrics using WMI or OLE automation.

Adaptive and Automated Alerting

Choose from over 100 pre-defined and configurable alert settings based on industry best practices with advanced configuration settings allowing for greater flexibility. Adding or modifying metrics to multiple servers is also simplified with the default alert configuration and the 'copy to' operation which allows for multi-server configuration. Advanced notifications allow alerts to be sent to different groups of people based on metric, time-of-day, instance, and more.

Alert Thresholds Recommendations

Capture the baselines of past performance of a monitored instance to determine if any alert thresholds are set in such a way that they may be excessively noisy or cause false positive. If it is determined that a metric is constantly alerting, it will provide flags to indicate that changes may be needed and will provide recommendations for the new thresholds.

Alert Smoothing & Snoozing

Easily "snooze" any alert or group of alerts for a specified number of minutes which prevents alerts from recurring while the problem is being worked on. For problem metrics which occasionally spike for very short durations, users can easily specify the length of time that an issue must be occurring before the first alert will be sent. This cuts back on noise and allows the database administrators to focus on issues which are representing a continuing problem worth further investigation. The changes to the settings can be done at an individual server level or in bulk for a group of servers.

Per-database & Per-disk Alerts

Users can define per-database and per-disk alerts differently. For instance, users can be alerted when disk E: is 90% full or disk F: is 80% full. Users can also 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. Alerting can also be done for filegroup space use.

Error & Agent Logs

View and receive alerts on specific conditions within the SQL Server Error Log.

Settings for Maintenance Mode

Disable data collection and alerting during maintenance periods to avoid false positives. Maintenance Mode can be on-demand, one-time or weekly scheduled maintenance periods, and can be enabled via PowerShell to allow integration with outside job scheduling. This mode can also be enabled in bulk for all servers in one shot.

Pinpoint Locks, Blocks & Deadlocks

Identify real-time and historical session locks, blocks and deadlocks and look at the complete blocking chain for easy identification and resolution. Session traces can also be run for additional diagnostics or sessions can be killed.

Blocking data includes the ability to chart blocking events, investigate lead-blockers, view the last-command run by the session, etc. Deadlocking monitoring allows the users to drill-down to view the deadlock victim and the code responsible for the deadlock.

History Browser

View historical information on sessions, locks, blocks, and performance counters. Easily diagnosis problems that happened minutes, days or weeks ago by simply selecting a past point-in-time. The console quickly changes all screens to display the SQL Server and the OS performance metrics at that point in time.

Configure Multiple Performance Baselines

Define and schedule any number of baseline periods to differentiate various situations. View server baseline performance and compare a server's baseline values and compare a server's baseline over time ranges as well as across different servers. Configure baseline alerts that automatically calibrate to changes. Generate reports that show the baseline in the given performance metric's graph or chart, allowing for better capacity planning for new servers.

Server Activity Timeline

Visualize server performance events as a timeline calendar instead of only as a list of events. Events are color-coded for easy differentiation, and a sliding scale provides the ability to zoom in to a specific timeframe. This helps correlate events happening at the same time in an easy to read format for quicker trend analysis and remediation.

Fragmentation Statistics

Statistics on fragmentation are displayed to help you identify indexes that may need attention and remedy one of the most common causes of performance degradation in SQL Server.

Integration with SCOM

Easily integrate with Microsoft’s System Center Operations Manager (SCOM) via the Management Pack. Propagates the status, health, and events of all monitored instances up to SCOM to allow the database administrator and Information Technology Operations staff to share data at a higher level across the enterprise. Easily install the Management Pack without incurring any additional monitoring overhead.

PowerShell Snap-in

Quickly and easily script many of the SQL Diagnostic Manager management tasks using the PowerShell Snap-in.

Capacity Planning

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

Customizable & Scalable Desktop Console

Maintain ‘single pane of glass’ monitoring via the intuitive, easy-to-use Windows-based console. Some of the key areas highlighted in the console include servers, federated overviews, newsfeed collaboration, reports, and administration.

With the server dashboard, display eight key areas (that is, Overview, Session, Queries, Wait Stats, Disk Counters, Databases, Services, and Logs) and highlight with color-coding the area that is triggering alerts to specific thresholds. With the federated overviews, monitor multiple deployments of SQL Diagnostic Manager from a single screen.

Monitor hundreds of servers from this single console. Multiple consoles support thousands of databases providing an unprecedented level of visibility and control of your entire SQL Server environment.

Easy to Deploy Web Console Add-on

Easily deploy SQL Diagnostic Manager via the web console add-on. View at-a-glance summaries of monitored servers, top problem occurrences, and active alerts so they can see what is going on quickly. It uses customizable widgets, filters, and groupings to organize information, and thumbnail and heat map views to identify problem areas for additional drill down and diagnosis. Users gain added flexibility in how they deploy SQL Diagnostic Manager enabling them to easily extend use to more SQL Server support staff over the web.

Mobile Remote Access

Access SQL Diagnostic Manager from anywhere. Use any mobile device (such as Apple iPhone, Android, Blackberry, and tablet) to view real-time and historical SQL Server performance data. View and kill sessions, start and stop jobs, and run queries to resolve and diagnose issues remotely while on the go.

Share Counters, Reports, and Alerts

Users can export and import configuration files to share custom counters, reports, and alert template with other users.

Central Data Repository

Store all historical performance data in a central repository enabling analysis of long-term trends, supporting capacity planning and allowing for a variety of strategic analyses.

Application Security

Flexible customization of server access and security permissions allow DBAs to have full access to one or more servers while other users such as Help Desk Operators are provided read-only access.

Agentless & Low Impact

SQL Diagnostic Manager is agentless and does not install additional services, databases, tables, extended stored procedures or anything else on the production systems. This simple architecture greatly reduces server footprint, simplifies the installation and upgrade process and eliminates risk agents on the performance of the monitored SQL servers.

Audit Transaction Logs

Audit a configuration change (e.g. kill a session) that shows up in the change log as an event. Administrators can keep track of what these users are doing and the changes are captured in a new report on configuration changes to provide an audit trail if needed.

Powerful & Comprehensive Reporting

View comprehensive reporting and trend analysis highlighting key performance trends via the easy to use reporting interface. The reports and charts cover areas such as CPU to input/output activity, physical disk activity, worst performing by application and user, logins (including unsuccessful logins), and procedure cache hit ratio.

The system also provides a series of forecasting reports that allow users to forecast database, drive and table growth based on past performance.

In addition to the over 25 reports that are provided out of the box, users have the ability to create/store a custom report based on any collected metric to identify recurring problems and prevent future occurrences. All reports can also be deployed to SQL Server Reporting Services and emails scheduled easily through the management console.

Dashboard Templates in Web Console Add-on

Custom dashboards in the web console add-on through which users can add columns/rows, select different metrics from the panel gallery, and share the dashboard among users to see the performance metrics most relevant for that user for any given database.

Users can also specify different default dashboard per instances. For instance, SQL Servers that are virtualized can be defined to have a dashboard that displays VM and Host data in the dashboard.

IntelliFeed™ Technology

Follow critical issues and share updates on SQL Server problems with other technical staff using the Idera Newsfeed social-networking paradigm.

Knowledge Base

Add custom environment-specific details as a reference point to reduce problem resolution time, increase availability, and increase internal awareness with the knowledge sharing tool provided in the UI.

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.

No credit card required! Fully functional for 14 days SQL Diagnostic Manager Repository dashboard

Buy Now

Starts at $2,495.00 $1,996.00 per instance

Save at least 20% on all online purchases.
Volume discounts available.

Add to Cart

Need pricing options?

Request a quote for SMB or
multi-license discount pricing.

Request a Quote

Live Product Demo

See SQL Diagnostic Manager in action with a seasoned pro.

Request a Demo

Pacific Life Insurance Company is very likely to recommend SQL Diagnostic Manager for this reason: “SQL Diagnostic Manager is an excellent product that provides meaningful value at a reasonable price.”
Darren Ludwig, IT Manager, Pacific Life Insurance Company (Large Enterprise, Insurance), USA. TechValidate 784-BFF-DDB.