Page tree

The Technical Specifications show requirements at a high level. For more detailed information, including supported installation scenarios, see the topics listed under Installation and Deployment.

What's New

For the new features and fixed issues in the latest version of SQL Diagnostic Manager for MySQL, see SQLDM for SQL Server New Features and Fixed Issues.

System Requirements - General

SQL Diagnostic Manager 11.0 requires Microsoft SQL Server 2005 or above running on the computer that hosts the SQL Diagnostic Manager Repository database for all installations.

Tempdb monitoring is supported on SQL Server 2005 and above servers only.

To run PowerShell scripts, upgrade to PowerShell 3.0 or higher. This upgrade is required to use the PowerShell snap-in.

CPU2.0 GHz or greater
Memory1 GB
Operating SystemMicrosoft Windows 64-bit
  • 10
  • 8
  • 7
Microsoft Windows Server 64-bit
  • 2019
  • 2016
  • 2012 R2
  • 2012
  • 2008 R2
  • 2008

System Requirements - Trial

DatabaseMicrosoft SQL Server
  • 2019
  • 2017
  • 2016
  • 2014
  • 2012
  • 2008 R2
  • 2008
  • 2005 SP1
Hard Disk200 MB for all SQL Diagnostic Manager components
Microsoft Windows PermissionsYour Windows login account includes Local Administrator permissions.
Microsoft SQL Server Privileges

You must use either a Windows user account or SQL Server login that includes System Administrator privileges on the monitored SQL Server instance(s).

Operating System

Microsoft Windows
  • 10
  • 8
  • 7

Microsoft Windows Server

  • 2019
  • 2016
  • 2012 R2
  • 2012
  • 2008 R2
  • 2008 SP1
Cloud Platforms
  • Amazon Elastic Compute Cloud (EC2)
  • Microsoft Azure Virtual Machine (VM)

Monitored Database Platforms

Amazon Relational Database Service (RDS)
  • SQL Server
Microsoft Azure
  • SQL Server
Microsoft SQL Server
  • 2019
  • 2017
  • 2016
  • 2014
  • 2012
  • 2008 R2
  • 2008 SP+
  • 2005 SP+
  • 2000 SP4+
Microsoft SQL Server Express
  • 2019
  • 2017
  • 2016
  • 2014
  • 2012
  • 2008 R2
  • 2008

Version History

Version 11.0

  • SQL Diagnostic Manager includes full support for Azure SQL. This feature includes the following resources for the Azure SQL database:
    • The compatibility for Azure SQL Managed Instance with on-premises.
    • Elastic pools allow you to manage and scale multiple databases.
    • Single databases typically are used for development and small apps.
  • This release includes the completion of Azure SQL alerts that were added in previous releases. Among other features, these alerts include:
    • New alerts notify if the allocated resources are more than needed.
    • New displays for newly collected metrics.
  • New alert templates with revised thresholds and priority/rank specifically for DBaaS (Azure SQL and Amazon RDS)
  • This version includes a new server wizard that uses Azure profile credentials, allowing you to discover other Azure DB assets.
  • Azure profile credentials collect metrics from Azure monitor to extend SQL Diagnostic Manager.
  • Prescriptive Analytics improvements, including new recommendations for Azure SQL DBaaS and Amazon RDS.

Version 10.6

  • New and improved user interface: 
    • Improved workflow, easing navigation in the desktop client console.
    • Expandable Servers sidebar, allowing users to have a larger screen space.
    • Dock and undock user interface components to optimize usage in multi-monitor environments.
    • Search bar eases search of monitored instances in large scale deployments.
    • Searchable drop-down instance name navigation without changing drill-down.
    • History Range control available for historical or real-time analysis.
    • Advanced sessions filter by application adds to powerful analysis options including drag-and-drop “Group By” options.
  • Access to Azure Monitor Counters for Custom collection

Version 10.5.1

  • New Server Uptime report
  • Three new default values for History Browser range
  • The "Days since last backup" alert configuration includes option to include or exclude Read-Only databases

Version 10.5

  • Prescriptive Analysis improvements (embedded SQL Doctor), updated user interface that matches SQL Doctor workflows, and updated recommendations (specifically for Azure SQL and Amazon RDS)
  • Cloud DBaaS user interface improvements that ease management of Azure SQL and Amazon RDS management supported metrics
  • Alerting improvements:
    • New alert templates with revised thresholds and ranks
    • New conditions for Alert Responses
    • New Alert filter to avoid false positives from spikes, filter by percentage of time over a period exceeding threshold
    • PowerShell command to Apply Alert template
    • New Alerts and metrics for Azure SQL and Amazon RDS specifically
    • All alert priority levels were updated for existing alerts and for user customization.
    • New alert template reports

Version 10.4

  • Visual Query Plans available for launch in Windows Client context from any query
  • Improved collection of Extended Event query plans
  • New options to exploit Query Store collections for query waits, query plans, and query performance
  • Improved IDERA Dashboard with new alerts grid and instance lists

Version 10.3.1

There are no new features for this product version release.

Version 10.3

  • Monitor SQL Server 2017 instances running on Windows or Linux operating systems
  • New operator security role
  • New grooming and aggregation options for long term forecasting metrics for disks, databases, and tables

Version 10.2.3

There are no new features for this product version release.

Version 10.2.2

  • Cluster environment: A UNC path is set for DataPath for services in a cluster install
  • Reports:
    • Detailed Session report
    • New Deadlock Report
    • Exclude one or more disks when running Disk Space Usage report

Version 10.2.1

There are no new features for this product version release.

Version 10.2

  • SQL Diagnostic Manager: Performance improvements, focus on an extensive scalability and user productivity improvements which involve faster startup time and faster connectivity between SQL Diagnostic Manager and SQL Workload Analysis
  • SQL Workload Analysis integration:
    • Launch SQL Workload Analysis in context of monitored server from desktop console and IDERA Dashboard
    • Time-based drilldown any graph in desktop console and in web console
    • SQL Workload Analysis launch points in different components of SQL Diagnostic Manager desktop and web console
  • History browser: New History Range Control in desktop console and web console

Version 10.1.4

There are no new features for this product version release.

Version 10.1.1

  • Launch SQL Workload Analysis in context of your monitored server from desktop console and IDERA Dashboard

Version 10.1

  • General: Desktop console is no longer showing slow performance that was caused by retained data from deleted instances
  • Grooming process: Grooming process has stopped exceeding growth of SQLStatementsOverflow table
  • Monitor AlwaysOn Availability Groups:
    • Monitored Availability Group Listeners no longer have issues gathering information from primary replica
    • “Unreadable availability replica” status is no longer displaying in databases that are part of AlwaysOn Availability Groups
  • Collection service: Enabling maintenance mode for all monitored instances is no longer causing Collection Service crash
  • Troubleshoot WMI connectivity issues: After troubleshooting WMI connectivity issues “WMI is not available on the server” alert is no longer displaying.

Version 10.0.2

There are no new features for this product version release.

Version 10.0.1

There are no new features for this product version release.

Version 10.0

  • Prescriptive analysis
  • Multiple baselines
  • Multiple custom dashboards
  • Import and export alert response
  • Import and export wizard
  • Top Servers report
  • Self-service licensing model
  • Web console improvements:
    • Federated Overview screens 
    • New common Dashboard widgets 
    • New color-coded Alerts Timeline view 
    • Query Waits view enhancements
    • Databases Summary view enhancements
    • Collapsible side panel

Version 9.1.2

There are no new features in this product version release.

Version 9.1.1

There are no new features in this product version release.

Version 9.1

  • Web console improvements:
    • Aggregated views across multiple repositories
    • Launch desktop console from various views
    • Adjustable panels in key web console views
    • Improved thumbnail sub-view
    • Improved heatmap sub-view
    • New web console widgets
    • Monitoring of non-query activities with Extended Events
    • Integration with IDERA community site
  • Filegroup and Mount Point monitoring improvements:
    • Configurable database filegroup alerts
    • New Disk Size view
    • Disk Space Usage report
    • Disk Space History report
  • Monitoring of additional SQL Server services:
    • SQL Server Active Directory Helper Status
    • SQL Server Browser Service Status
    • Server Summary report supports new SQL Server monitored services

Version 9.0

  • Integration with IDERA Dashboard
  • New advanced query views
  • Improved and integrated web console 
  • Licensing and version upgrading
  • Help documentation improvements

Version 8.6

  • Full support for SQL Server Express instances
  • Reporting on Query Wait Statistics
  • Query Waits information is extended to Top Servers and Top Databases reports
  • New database alert for Availability Group Preferred Replica

Version 8.5

  • Full support for SQL Server 2014
  • Hyper-V support
  • Tech Preview of new SQL Diagnostic Manager web console
  • Monitoring and alerting enhancements:
    • Enhanced alert response usability
    • Inclusion filters for Query monitors
    • New filter in Signature Mode and Statement Mode views
    • Improved Maintenance Mode flexibility
    • Virtualization counters available for custom reports
    • Run one-click System Diagnostics
    • Deadlock victim details available in Deadlock Sessions Report
    • Configuration option added to control WMI timeouts

Version 8.0.1

There are no new features in this product version release.

Version 8.0

  • Fully supports AlwaysOn Availability Groups feature of SQL Server 2012
  • Integration with Microsoft System Center Operations Manager (SCOM)
  • Change Log Summary report
  • Blocked Process report available in SQL Diagnostic Manager
  • Improved Maintenance Mode and Snooze Alerts features
  • Desktop console supports Operating Systems where FIPS compliance is required
  • SQL Server 2014 experimental support

Version 7.5.4

  • General: Charts properly manage real-time and scheduled collection data in same time span
  • Queries: Query Waits located on Queries tab
  • Alerts:
    • Manage how desktop console responds to alert notifications
    • Set to notify of only critical alerts
  • Mobile: Mobile and IDERA Newsfeed supports IIS 8

Version 7.5.3

There are no new features in this product version release.

Version 7.5.2

There are no new features in this product version release.

Version 7.5.1

There are no new features in this product version release.

Version 7.5

There are no new features in this product version release.

Version 7.2.2

There are no new features in this product version release.

Version 7.2.1

  • SQL Server 2012 RTM Support

Version 7.2

  • Monitoring SQL Server virtual environments
  • SQL Server 2012 experimental support
  • SQLdm Mobile views
  • Reporting on Tempdb Statistics
  • SQL Server Memory Usage Percent counter available for custom reports
  • Updated alert notification functionality
  • CPU Statistics report available in a custom range of hours
  • Input how long SQL Diagnostic Manager waits before raising an alert for a long-running job

Version 7.1.1

There are no new features in this product version release.

Version 7.1

  • New SQL Server dashboard
  • New Tempdb monitoring
  • New SQLdm Mobile views
  • Blocking Chain View
  • View and copy SQL Agent Job messages from Job History list

Version 7.0

  • New SQLdm Mobile interface
  • New Alert Templates
  • New Informational Alerts
  • Improved Alert Response Usability
  • Improved Notification Times for Unresponsive SQL Server Instances
  • Improved Metrics Collection
  • Improved Repository Performance
  • New Reports

IDERA |  Products | Purchase | Support |  Community |  Resources |  About Us  | Legal