Page History
| Info |
|---|
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. |
| Table of Contents | ||||
|---|---|---|---|---|
|
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
| Note |
|---|
SQL Diagnostic Manager 10.6 requires Microsoft SQL Server 2005 or above running on the computer that hosts the SQL Diagnostic Manager Repository database for all installations. |
| Note |
|---|
Tempdb monitoring is supported on SQL Server 2005 and above servers only. |
| Note |
|---|
To run PowerShell scripts, upgrade to PowerShell 3.0 or higher. This upgrade is required to use the PowerShell snap-in. |
...
- 10
- 8
- 7
...
- 2019
- 2016
- 2012 R2
- 2012
- 2008 R2
- 2008
System Requirements - Trial
...
- 2019
- 2017
- 2016
- 2014
- 2012
- 2008 R2
- 2008
- 2005 SP1
...
You must use either a Windows user account or SQL Server login that includes System Administrator privileges on the monitored SQL Server instance(s).
more information about SQL Diagnostic Manager specifications, please visit the following sections:
...
- 10
- 8
- 7
...
Microsoft Windows Server
...
- 2019
- 2016
- 2012 R2
- 2012
- 2008 R2
- 2008 SP1
...
- Amazon Elastic Compute Cloud (EC2)
- Microsoft Azure Virtual Machine (VM)
...
- SQL Server
...
- SQL Server
...
- 2019
- 2017
- 2016
- 2014
- 2012
- 2008 R2
- 2008 SP+
- 2005 SP+
- 2000 SP4+
...
- 2019
- 2017
- 2016
- 2014
- 2012
- 2008 R2
- 2008
Version History
| Table of Contents | ||||
|---|---|---|---|---|
|
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