SQL Diagnostic Manager provides the following new features and fixed issues.
...
12.
...
No new features
10.1.4 Fixed issues
Alerts
- To provide a clearer understanding of what the “Distribution Latency (Seconds)” metric is measuring, the description of the metric and summary of raised alerts has been updated.
- SQLDM is now displaying Informational Alerts for SQL Server Agent Long Running Jobs.
- SQLDM is displaying alerts in Dashboard and the desktop console regardless the ‘Region and Language’ settings.
- "Days since last backup" alert is being triggered considering the threshold values configured in the alert configuration template.
- When the log file is filled up in a database, the Log Full (Percent) alert is being triggered normally and the LogSizeInKilobytes and PercentLogSpace columns are not showing NULL value when the log percent retrieved is greater than 100%.
- The exception filter wildcard is working normally and is no longer causing undesired alerts.
- The Filegroup Space Full (Percent) alerts for filegroups that are on the same disk are showing the correct values for the space full percentage.
- The number of days since last backup are now correctly displayed for daily backups databases. SQLDM is now generating the “Days since last backup” alert for databases that include a space at the end of the database name.
SQLDM is no longer receiving continuous OK status alerts for the Log Full (Percent) and Database Full (Percent) metrics.
Alert response
- Alert Response triggers normally when a server is added to a tag.
Availability Groups
- The "Days since last backup" metric is now checking the backup preferences of databases participating in an Availability Groups prior to raising alerts.
- SQL Server Agent jobs created for SQLDM are no longer encountering errors on secondary nodes when the SQLDM repository is hosted in an availability group.
- When a member of a database is on a read-only role, SQLDM is no longer displaying critical alerts on the Availability Groups databases.
Custom Counter
- The Custom Counter SQL Script text window is resizing to the popup window size.
Dashboard
- The Dashboard and SQLDM are reflecting the same per-database data size usage.
- The error "Something unexpected happened Java.Null.Pointer exception" is caused by a compatibility issue between products in the IDERA Dashboard is no longer displaying.
- In the IDERA Dashboard overview, the SQLDM Instances status widget is no longer having issues displaying the number of servers or the status of the servers. A compatibility issue among IDERA products within IDERA Dashboard caused this issue.
Data collection
- SQLDM is no longer having issues collecting log errors with a Severity higher than 21.
Graphs
- All graphs are displayed correctly and with all the information complete.
Logs
- The upper limits on High Availability Log Send Queue size alert triggering have been extended to 999 million logs.
- Users can now review the SQL Server Error logs. The error "Error reading SQL 2005 SQL Server log: System.InvalidCastException: Specified cast is not valid" is no longer showing up.
Queries
- The SQLDM console is now refreshing the list of the resulting queries in the Statement Mode View. Improvements to the Statement Mode view in the SQLDM console to allow a list of queries.
- The date ranges are now consistent when switching among Signature mode, Statement mode, and Query History screen. Query history now displays details about the query selected.
- Improvements to the query used to populate the data on the Alerts view in the SQLDM Desktop Console.
- ‘Top Queries’ and ‘Query Overview’ generate successful reports without timeout or expired messages.
Replication Monitoring
- When using replication, SQLDM is displaying the correct publisher status.
Reports
- SQLDM is triggering accurate results when running "Top Queries" reports.
- SQLDM reports that are deployed to SSRS are now generating charts correctly.
- Index improvements to improve the duration it takes to run the Database Statistics report.
Repository
- There are no longer issues in the Repository connection application when using Management Service Utility to reconfigure repository connection for a management service.
- An error is no longer being generated on the Overview tab when the SQLDM repository database is hosted on a SQL Server 2005 instance. The error that was previously generated was “An error occurred while refreshing.Exception type: System.Data.SqlClient.SqlException. Message: Type Time is not a defined system type.”
Sessions
- Users are no longer encountering issues when viewing locks under the Sessions tab. The view is updated automatically.
- The Lock section under Sessions is no longer showing "Sysadmin privileges are required to obtain data for this view" message.
SQL Server Agent
- The SQL Server Agent Long Running Job (Percent) value is now properly calculated in the alerts screen.
Web console
- Date/Time values stored in the SQLDM repository database are stored in GMT format. The SQLDM web console now converts the GMT format to the local time zone.
- The SQLDM web console is no longer displaying deleted databases.
- The Sessions view in the SQLDM web console is displayed with no errors.
- Instances in Maintenance Mode are no longer displaying health status or alerts in the web console.
Other issues
...
3 New Features
SQL Diagnostic Manager presents the following features and enhancements:
- An Improved User Interface with the following changes:
- A new organization Grid View which allows a better glance at your instance metrics and properties.
- An updated Windows Console Grid View similar to SQL Diagnostic Web Console.
- A renovated Card View style, providing you with the same reliable information with a better-summarized look.
- An improved administration dialog to change the scale Health Index Factor for SQL Diagnostic Manager Console.
- A new Search feature for handling long lists across your servers, filters, alerts, and more.
A Step Forward or Backward with the drill-down option.
Info |
---|
Administrative actions are not included, only the actions associated with drill-downs are maintained. |
- A new Automated Responses for ServiceNow action providers. To configure it, you must provide the Service Now information such as URL, Username, Password, and Alert Source.
12.3 Fixed Issues
Reports
Status |
---|
colour | Green |
---|
title | SQLDM-32143 |
---|
|
The "Server Uptime" report records the correct values for the uptime and downtime of a specific instance. Status |
---|
| |
---|
colour | Green |
---|
title | SQLDM-31873 |
---|
|
The Database Statistics report is now generating data correctly for a custom range of time.
Status |
---|
colour | Green |
---|
title | SQLDM-31680 |
---|
|
The "Top Tables by Fragmentation" report now correctly identifies fragmented tables in the latest version of SQL Diagnostic Manager.
Status |
---|
colour | Green |
---|
title | SQLDM-31683 |
---|
|
SQL Diagnostic Manager correctly identifies query records where query plans have been successfully collected.
Status |
---|
colour | Green |
---|
title | SQLDM-30535 |
---|
|
SQL Diagnostic Manager successfully generates the "Template Comparison" report.
Alerts
Status |
---|
| |
---|
colour | Green |
---|
title | SQLDM-32393 |
---|
|
SQL Diagnostic Manager accurately displays alert data in the Historical Snapshots tooltip for a specific instance. Status |
---|
| |
---|
colour | Green |
---|
title | SQLDM-32347 |
---|
|
SQL Diagnostic Manager correctly applies the "Where metric severity has changed is in place" alert rule. Status |
---|
colour | Green |
---|
title | SQLDM-32194 |
---|
|
The default value for the user field under the "Alternative Windows Authorization" feature is Blank now.
Status |
---|
colour | Green |
---|
title | SQLDM-32182 |
---|
|
The Page Life Expectancy (Baseline) now works as expected, raising alerts according to the baseline thresholds.
Status |
---|
| |
---|
colour | Green |
---|
title | SQLDM-32173 |
---|
|
The Resuming Alerts window displays all available alerts that can be snoozed or resumed successfully.
Status |
---|
colour | Green |
---|
title | SQLDM-32021 |
---|
|
SQL Diagnostic Manager provides all the information of the Blocking Session Wait Time (Seconds) alert when enabling Capture Blocking (SQL 2005+).
Status |
---|
colour | Green |
---|
title | SQLDM-31941 |
---|
|
You can successfully configure e-mail notifications, including "and" conditions.
Status |
---|
colour | Green |
---|
title | SQLDM-31737 |
---|
|
You can successfully generate "Alert Forecasts" for Active Alerts in SQL Diagnostic Manager 12.3.
Status |
---|
colour | Green |
---|
title | SQLDM-31256 |
---|
|
The "Deadlock" alert is generated as expected and sends alert emails with correct and complete details.
Status |
---|
colour | Green |
---|
title | SQLDM-28938 |
---|
|
SQL Diagnostic Manager only displays the active alerts on the environment views.
Alerts Response
Status |
---|
colour | Green |
---|
title | SQLDM-32215 |
---|
|
SQL Diagnostic Manager improved the Alert Response Rules performance. Now you can successfully receive e-mails when creating or updating a rule. Status |
---|
colour | Green |
---|
title | SQLDM-32030 |
---|
|
After upgrading to SQLDM 12, SQL Diagnostic Manager maintains the "Email (SMTP) Provider" alert response configuration.
Status |
---|
colour | Green |
---|
title | SQLDM-31876 |
---|
|
With SQL Diagnostic Manager you can correctly import a delete alert response containing an SMTP action provider.
Status |
---|
colour | Green |
---|
title | SQLDM-30889 |
---|
|
You can successfully export and import SMTP alert responses using SQL Diagnostic Manager 12.3.
Custom Counters
Status |
---|
colour | Green |
---|
title | SQLDM-32148 |
---|
|
SQL Diagnostic Manager keeps a Server's Custom Counter configuration after changing its tags configurations.
Status |
---|
colour | Green |
---|
title | SQLDM-30385 |
---|
|
SQL Diagnostic Manager successfully applies Custom Counter in new Servers when using templates.
Status |
---|
| |
---|
colour | Green |
---|
title | SQLDM-32040 |
---|
|
SQL Diagnostic Manager allows selecting and applying custom counters to all servers when creating metric alert responses for cluster environments.
Status |
---|
colour | Green |
---|
title | SQLDM-32034 |
---|
|
When using the SQL Diagnostic Manager manual Maintenance Mode, the instances remain linked to Custom Counters.
General
Status |
---|
colour | Green |
---|
title | SQLDM-31974 |
---|
|
SQL Diagnostic Manager supports Extended Event Options for the Activity Monitor and the Query Monitor properties. Status |
---|
colour | Green |
---|
title | SQLDM-31303 |
---|
|
SQL Diagnostic Manager allows user accounts to apply alert templates to a monitor instance.
Status |
---|
colour | Green |
---|
title | SQLDM-30861 |
---|
|
SQL Diagnostic Manager improved the analyzer's performance, providing more accurate analysis recommendations.
DM Console
Status |
---|
colour | Green |
---|
title | SQLDM-32339 |
---|
|
SQL Diagnostic Manager allows you to successfully add a new user through the Application Security tab. Status |
---|
| |
---|
colour | Green |
---|
title | SQLDM-32267 |
---|
|
SQL Diagnostic Manager fixed the performance of the Analyze view, generating recommendations properly.
Status |
---|
colour | Green |
---|
title | SQLDM-32256 |
---|
|
With SQL Diagnostic Manager, you can personalize the dashboard view by choosing a specific dashboard to display.
Status |
---|
colour | Green |
---|
title | SQLDM-32232 |
---|
|
SQL Diagnostic Manager now allows you to grant users access to specific instances through the Application Security window. Status |
---|
colour | Green |
---|
title | SQLDM-32227 |
---|
|
You can successfully export the Analyze report of a monitored instance.
Status |
---|
colour | Green |
---|
title | SQLDM-32178 |
---|
|
SQL Diagnostic Manager successfully displays the history browser for SQL Server Azure-managed instances.
Status |
---|
| |
---|
colour | Green |
---|
title | SQLDM-32063 |
---|
|
SQL Diagnostic Manager successfully monitors and displays information for scale-out installations, showing the correct version.
On-Premises
Status |
---|
colour | Green |
---|
title | SQLDM-31859 |
---|
|
The Permissions Script for User Creation was successfully improved and now works as expected.IDERA Web Console
Status |
---|
colour | Green |
---|
title | SQLDM-32333 |
---|
|
SQLDM Web Console successfully displays all the alerts of the monitored instances after an upgrade. Status |
---|
colour | Green |
---|
title | SQLDM-32291 |
---|
|
Dates are now displayed in the proper format on SQLDM Web Console.
Status |
---|
colour | Green |
---|
title | SQLDM-32274 |
---|
|
SQL Diagnostic Manager correctly displays graphics in the Web Console, since the graphics order has been fixed.
Status |
---|
colour | Green |
---|
title | SQLDM-32242 |
---|
|
SQL Diagnostic Manager fixed the performance of the Analyze view, generating recommendations properly.
Status |
---|
colour | Green |
---|
title | SQLDM-32228 |
---|
|
The Alerts view of SQLDM Web Console allows users to set up Advanced Filters effectively.
High Availability Groups
Status |
---|
colour | Green |
---|
title | SQLDM-32147 |
---|
|
The "Days since the last backup" alert functions as intended according to the backup preference settings for High Availability Groups.
Status |
---|
colour | Green |
---|
title | SQLDM-31875 |
---|
|
SQL Diagnostic Manager successfully monitors listener status in a High Availability environment while monitoring replicas.Upgrade
Status |
---|
| |
---|
colour | Green |
---|
title | SQLDM-32421 |
---|
|
SQL Diagnostic Manager displays consistent values for CPU usage metrics and graphics after upgrading to 12.2.4
Status |
---|
colour | Green |
---|
title | SQLDM-32299 |
---|
|
After upgrading, SQL Diagnostic Manager does not raise any unhandled exception related to missing files.
Status |
---|
colour | Green |
---|
title | SQLDM-32181 |
---|
|
You can successfully upgrade SQL Diagnostic Manager to 12.0.x keeping your Alert Templates and Responses as well as your configured Tags. Status |
---|
colour | Green |
---|
title | SQLDM-32150 |
---|
|
SQL Diagnostic Manager successfully updates snapshots and refreshes alerts after an upgrade.
Status |
---|
colour | Green |
---|
title | SQLDM-32026 |
---|
|
SQL Diagnostic Manager successfully triggers notifications for "SQL Server Agent Job Failure" alerts after an upgrade.
DBaaS
Status |
---|
colour | Green |
---|
title | SQLDM-32221 |
---|
|
SQL Diagnostic Manager keeps the last Sever selection and Time Period for using them when configuring a new report. Metrics
Status |
---|
colour | Green |
---|
title | SQLDM-32130 |
---|
|
SQL Diagnostic Manager increased the maximum critical threshold value for the "Version Store Size (MB)" metric. Status |
---|
colour | Green |
---|
title | SQLDM-32109 |
---|
|
SQL diagnostic Manager successfully displays the "SQL Server CPU Usage" metric after upgrading to SQLDM 12.
Status |
---|
colour | Green |
---|
title | SQLDM-31812 |
---|
|
The "Procedure Cache Hit Ratio" metric has been improved on Azure SQL Managed Instance and Azure DB.
Charts
Status |
---|
colour | Green |
---|
title | SQLDM-31870 |
---|
|
SQL Diagnostic Manager correctly shows the Total Deadlock data in the Overview and Sessions charts after an upgrade.History Browser
Status |
---|
colour | Green |
---|
title | SQLDM-32019 |
---|
|
SQL Diagnostic Manager successfully collects historical data in the History Browser for all the monitored servers. Status |
---|
| |
---|
colour | Green |
---|
title | SQLDM-31951 |
---|
|
SQL Diagnostic Manager correctly displays historical data for TempDB summary in the history browser and across multiple time ranges.