SQL Diagnostic Manager

Achieve 24/7 SQL Monitoring

  • Performance monitoring for physical and virtual environments
  • Query plan monitoring to see the causes of blocks and deadlocks
  • Transactional SQL Server application monitoring with SQL Workload Analysis
  • Integrated SQL Doctor expert recommendations
  • Predictive alerting with settings to avoid false alerts
  • Web-based dashboard with at-a-glance views of top issues and alerts

פרולוג'יק היא המפיצה הרישמית של מוצרי IDERA בישראל.
כמו כן פרולוג'יק מספקת חבילת מוצר מושלמת הכוללת אינטגרציה, ליווי והדרכה.

Physical and Virtual Performance Monitoring

Easily monitor and view the performance of both physical server and VMware or Hyper-V virtual server environments 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.

Query Performance Monitoring

Identify and monitor inefficient and poor performing SQL queries, batches, statements and stored procedures causing blocks and deadlocks, such as long or most frequent queries or queries consuming unusually high CPU or I/O. Thresholds can be configured on each individual server allowing for greater flexibility, and the interface makes it very easy to see the most costly queries by looking at individual query executions or query signatures.

Quick Overeview - Idera SQL diagnostic manager - SQL Server Monitoring

*NEW* Transactional SQL Server Application Monitoring with SQL Workload Analysis

Now available in the Pro version of SQL Diagnostic Manager
SQL Workload Analysis focuses on wait state and application transaction monitoring and analysis by continuously sampling queries and plans. It significantly upgrades the wait state analysis capabilities.

Combine the operational monitoring from SQL Diagnostic Manager and transactional monitoring with SQL Workload Analysis to view instance properties and alerts, receive prescriptive recommendations for operational diagnosis, analyze workloads for transactional diagnosis, and arrive at a comprehensive root cause analysis.

Integrated SQL Doctor Expert Recommendations

Expert recommendations from IDERA SQL Doctor are now integrated into SQL Diagnostic Manager. Enhance performance and speed up problem resolutions with built-in tuning advice and best practices developed by SQL Server MVPs. These updated recommendations are integrated into analysis workflows and provide specific guidance to address problem issues including automatic corrective scripts and links to related online content to supercharge your SQL Server performance.

Predictive Alerting

Avoid false alarms with adaptive alerting functionality and set alert thresholds based on built-in historical statistical analysis of your server performance data. Read more…

Capacity Planning

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

Mobile Access

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

View a demo of SQL Diagnostic Manager mobile.

Web Dashboard

Log in from anywhere and quickly check the status of monitored server instances to identify and diagnose issues. View the current status of monitored instances, drill down into single instance details, view the top occurrences of performance issues, and see a rollup of all active alerts. Customize your display with eighteen new widgets, enhanced heat map view, and query wait state visualizations. Create any number of individually configured dashboards to address the needs of the entire organization.

Integration with SCOM

The SQL Diagnostic Manager Management Pack provides easy integration with Microsoft’s System Center Operations Manager (SCOM). The Management Pack propagates the current status, health and events of all monitored instances up to Operations Manager, allowing the DBA and IT Operations staff to share data at a higher level across their enterprise. The management pack is easy to install and does not incur any additional monitoring overhead.Read the FAQ and watch a quick 5 minute video to learn more.

Performance Monitoring

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 and Virtual Database Monitoring

Easily monitor and view the performance of both physical server and VMware or Hyper-V virtual server environments 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 contention and performance related issues with the tempdb monitoring and corresponding diagnostic views. Monitor and display Tempdb space and performance related information including: Read more…

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.

Enterprise Management

Customizable & Scalable Desktop Console

Maintain ‘single pane of glass’ monitoring via an intuitive, easy to use Windows-based console. Some of the key areas highlighted in the console include: Read more…

Easy to Deploy Web-based Dashboard

Easily deploy SQL Diagnostic Manager via a web-based dashboard. 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.

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: Read more…

Dashboard Templates

Custom dashboards 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. Read more…

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.

Diagnostics & Analytics

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.

PowerShell Snap-in

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

SQL Workload Analysis

Continuous Wait State and Transaction Monitoring

Monitor wait state and capture transactions of applications. Get a real-time view of the entire database with continuous sampling and high granularity as fast as 1 second.

Quick Drill-down for Actionable Advice

Easily drill-down to quickly isolate problems. View details of the captured transactions – such as top CPU activity, waits, databases, and statements versus top logins, machines, and applications – to pinpoint problems. Display and tune execution plans with expert recommendations, illuminate demanding transactions, and resolve locks and latches.

Historical Query Plan Trends

SQL Workload Analysis delivers valuable real-time and historical data to help tune queries. Investigate historical query plan trends in SQL Server 2005 and newer systems.

Integration with SQL Diagnostic Manager

SQL Workload Analysis integrates with SQL Diagnostic Manager to provide wait state and transaction monitoring. Further isolate the transaction causes of SQL Diagnostic Manager alerts for quick resolution.

Simple Web-based Dashboard

SQL Workload Analysis provides a single web-based interface that can be accessed via a browser from any machine that can access the framework machine. The dashboard displays a high-level overview of statistical analysis and SQL activity trends, and top database activity. Quickly isolate slow SQL statements and analyze execution plans in a sorted, easy to use table.

Desktop Console

  • Windows Server 2003 SP2, Windows Server 2008 SP1+, Windows Server 2012, Windows Vista SP1+, Windows 7, Windows 2008 R2, Windows 8 & 8.1, Windows 10
  • .Net 4.0+ and MDAC 2.8
  • Monitor resolution of 1280×800 with small text resolution.

Web Dashboard

  • Windows Server 2003 SP2, Windows Server 2008 SP1+, Windows Server 2012, Windows Vista SP1+, Windows 7, Windows 2008 R2, Windows 8 & 8.1, Windows 10
  • .Net 4.0
  • Browsers: Internet Explorer IE 9.x+, Chrome, Firefox.

Services and Data Repository

  • Windows 2000 SP4, Windows Server 2003 SP2, Windows Server 2008 SP1+, Windows Server 2012, Windows Vista SP1+, Windows 7, Windows 2008 R2, Windows 8 & 8.1, Windows 10
  • .Net 2.0 SP2+ and MDAC 2.8
  • Repository: SQL Server 2005 SP1+, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, SQL Server 2016.

Supported monitored SQL Servers

  • SQL Server 2000 SP4, SQL Server 2005 SP1+, SQL Server 2008 SP1, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, SQL Express (2005+), SQL Server 2016
  • Supports monitoring of images hosted on virtualized or cloud IaaS environments such as Microsoft Azure and Amazon EC2

SQL diagnostic manager does not install any components, DLLs, scripts, stored procedures or tables on the SQL Server instances being monitored.

Mobile Requirements

  • Services and Web Server OS: Windows Server 2003 SP2, Windows Server 2008 RTM+, Windows Server 2012, Windows Vista SP1+, Windows 7, Windows Server 2008 R2, Windows 8 & 8.1, Windows 10
  • .Net Framework: .Net 4.0
  • Repository: SQL Server 2005 SP1+, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, SQL Server 2016
  • Web Server: IIS 7.2+

Mobile and Desktop Devices

  • Mobile device: Android v2.1+, iOS v3.2+, RIM v6.0+, Windows Phone 7+, Edge
  • Desktop Browsers: IE 9.x+, Chrome, Firefox