Page History
This build includes many fixed issues, including the following updates from previous releases.
10.3.1 New features
No new features for this release.
10.3.1 Fixed Issues
Desktop console
SQLDM-29486 The SQL Diagnostic Manager Desktop Client is no longer encountering latency issues when navigating between monitored instances.
Upgrade
SQLDM-29459 SQLdm Collection services is no longer causing high CPU and network usage after performing an upgrade.
SQLDM-29448 After performing an upgrade to SQL Diagnostic Manager 10.3, the job "Aggregate Data SQLdmRepository" is no longer reporting timeouts.
SQLDM-29505 The SQLdm Management service starts automatically after the upgrade.
10.3 New features
- SQL Diagnostic Manager is able to monitor SQL Server 2017 instances running on Windows or Linux operating systems.
- SQL Diagnostic Manager now includes a new operator security role.
- This release include new grooming and aggregation options for long term forecasting metrics for disks, databases, and tables.
...
Expand | ||||||||
---|---|---|---|---|---|---|---|---|
| ||||||||
8.6 New featuresFull support for SQL Server Express instancesSQL Diagnostic Manager 8.6 fully supports monitoring of SQL Server Express instances. The following editions are supported: SQL Server 2005 Express, 2008, 2008 R2, 2012, and 2014. Reporting on Query Wait StatisticsYou can now run the Query Wait Statistics report to quickly analyze different wait type categories on your SQL Server and identify where your biggest bottlenecks are occurring impacting your performance. For additional information about the new Query Waits Statistics report, see Query Waits Statistics report. Query Waits information is now extended to the Top Servers and Top Databases reportsSQL Diagnostic Manager has extended Query Waits information to the Top Servers and Top Databases report, providing users insight into the queries on your SQL Server instance that exceed a specific wait threshold. Users can now view information on Top Servers by wait time and Top Databases by wait time. For additional information, see Top Servers and Top Databases. New database alert for Availability Group Preferred ReplicaSQL Diagnostic Manager triggers an Availability Group Preferred Replica whenever the primary role changes to a different replica and is unavailable for a defined amount of time in minutes. 8.6 Fixed IssuesUpgrade
General
Views
Alerts
Console
Dashboard
Reports
8.5 New featuresFull support for SQL Server 2014SQL Diagnostic Manager 8.5 fully supports monitoring of SQL Server 2014 RTM. Users who implement the SQL Server 2014 In-Memory OLTP Engine functionality should note that SQL Diagnostic Manager does not support this feature at the moment. Hyper-V supportSQL Diagnostic Manager 8.5 has extended virtual support to Hyper-V, providing users insight into the performance of their virtual system more effectively. Users can track and monitor Hyper-V specific performance metrics for a complete view of the virtualized server and the physical host. For additional information, see How SQLdm works with a virtual environment. Tech Preview of the new SQL Diagnostic Manager web consoleIn SQL Diagnostic Manager 8.5 rapidly and easily identify problems. The SQL Diagnostic Manager web console is designed to provide quick access to the overall status of the SQL Server environment to help diagnose any issues.
To provide feedback on the Tech Preview of the SQL Diagnostic Manager web console, access the IDERA community forum.
Monitoring and alerting enhancementsEnhanced alert response usabilityAbility to set up Alert Response that is triggered only after multiple user defined metric thresholds have been breached. For additional information, see Configure automated responses to alerts. Inclusion filters for Query monitorsAbility to do query monitoring on selected applications, databases, and SQL text. For additional information, see Configure advanced query monitor options. New filter in the Signature Mode and Statement Mode viewsAbility to exclude data returned with null values through the Exclude Currently Running Queries filter in the Signature Mode and Statement Mode views. Improved Maintenance Mode flexibilityAdditional monthly option for scheduling maintenance mode on monitored SQL server instances. For details, see Schedule Maintenance Mode. Virtualization counters available for custom reportsSelect both Hyper-V and VMware virtualization counters when creating a custom report. For additional information, see Select counter type and counters. Run one-click System DiagnosticsAbility to run system diagnostics and collect service and desktop client logs in the System Diagnostics window. See System Diagnostics for details. Deadlock victim details now available in the Deadlock Sessions ReportThe Deadlock Sessions Report of the Sessions>Blocking view includes deadlock victim information by default. Users no longer have to manually add this option through the Column Chooser dialog. For additional information see, Analyze blocked sessions. Configuration option added to control WMI timeoutsConfigure the WMI timeout value in SQL Diagnostic Manager when suitable. For instructions, see Configure OS metrics monitoring. 8.5 Fixed IssuesGeneral
Alerts
Reports
8.0.1 New featuresThere are no new features in this release. 8.0.1 Fixed issuesGeneral
Management Service Log
AlwaysOn Availability Groups
Mobile
8.0 New featuresSQL Diagnostic Manager now fully supports the AlwaysOn Availability Groups feature of SQL Server 2012SQL Diagnostic Manager 8.0 now allows DBAs to monitor their availability groups, availability replicas, and availability databases. Support for this feature comes with:
For additional information on SQL Diagnostic Manager and the AlwaysOn Availability Groups feature, see Monitor AlwaysOn Availability Groups. SQL Diagnostic Manager now offers integration with Microsoft System Center Operations Manager (SCOM)SQL Diagnostic Manager 8.0 now includes the SQLdm Management Pack (SQLdm MP) to enhance the SQL Server monitoring capabilities of Microsoft System Center Operations Manager (SCOM). Detailed alert and status information tracked by SQL Diagnostic Manager provides SCOM with a wealth of knowledge not previously available including:
For additional information about using SQL Diagnostic Manager with System Center Operations Manager, see Integrate SQL Diagnostic Manager with SCOM. Change Log Summary reportThe Change Log Summary report allows users to view a list of all actions and configuration changes performed in their SQL Diagnostic Manager environment over a specified period of time. For additional information on this report, see Change Log Summary. Improved collection of query and non-query activitiesSQL Diagnostic Manager 8.0 now allows users to collect solely queries’ performance data through the Query Monitor tab in the Monitored SQL Server Properties window. Configure collection of non-query activities such as deadlocks and autogrow events through an independent window, the Activity Monitor tab. Blocked Process report available in SQL Diagnostic ManagerSQL Diagnostic Manager users are now able to view the captured Blocked Process report directly in their SQL Diagnostic Manager Console. In the Activity Monitor tab, users can configure the Blocked Process Threshold (in seconds) that results in the Blocking Process and Blocked Process details report. To access this report, users can go to Sessions>Blocking and double click under Block Reports. For more information on this feature, see Set activity monitor options. Improved Maintenance Mode and Snooze Alerts featuresIn the SQL Diagnostic Manager 8.0 version, applying maintenance mode modifications to a large number of servers at once is possible through the Maintenance Mode command. Review Schedule Maintenance Mode for details. Also users that want to tackle several alerts, can mass snooze/resume alert generation through the Snooze Alerts/Resume Alerts commands. For additional information, see Snooze Alerts. SQL Diagnostic Manager Console supports Operating Systems where FIPS compliance is requiredThe SQL Diagnostic Manager 8.0 console supports operating systems with enabled system cryptography that use FIPS (Federal Information Processing Standard) complaint algorithms. For more information about FIPS compliance, see the Microsoft document,
SQL Server 2014 experimental supportSQL Diagnostic Manager 8.0 is SQL Server 2014 compatible. This version of SQL Diagnostic Manager is not certified against newer builds of SQL Server and should not be used with these builds in a production environment. IDERA provides experimental support while you use your installation in a testing environment to ensure the features you rely on most are working as or better than expected. Users who implement the SQL Server 2014 In-Memory OLTP Engine functionality should note that SQL Diagnostic Manager does not support this feature at the moment. 8.0 Fixed IssuesGeneral
ServersThis release fixes an issue that occurred while refreshing the Server Summary view. DatabasesAn issue causing errors related to fragmentation collector timeouts or fragmentation statistics collection in the Tables & Indexes view no longer occurs. ServicesThis release fixes an issue caused when the collector for the SQL Agent Jobs View could not interpret null values, resulting in job and job steps collection errors. Alerts
ResourcesAn issue causing an unknown value in the User/Schema column of the Procedure Cache view no longer occurs. ReportsAn issue preventing users from running the Alert History Report after deployment to Reporting Services no longer occurs. |
...