This build includes many fixed issues, including the following updates from previous releases.
The prior browser interface for SQL Diagnostic Manager in IDERA Dashboard will continue to be supported in addition to the new SQLDM browser interface. However, it is no longer part of the SQL Diagnostic Manager installation or the preferred browser interface for SQL Diagnostic Manager. If you wish to continue using IDERA Dashboard, you can install it separately and manually register SQL Diagnostic Manager. |
The Top Servers by Percent Usage report correctly displays CPU SQL Usage (Percent) values.
SQL Diagnostic Manager now successfully exports the Plan XML (Estimated) report from the Event Occurrences detail view.
The Server Uptime report pops up a "Select SQL Server" message when you do not select a server, otherwise, it works as expected.
SQL Diagnostic Manager correctly gathers, stores, and reports Database Statistics.
SQL Diagnostic Manager 12.2 correctly generates the Enterprise Summary reports including the SQL Server version of your instances.
The Database Growth Forecast report is correctly generated.
The Disk Space History report correctly lists the disk available on the monitored instances.
The Disk Space History report is correctly generated for seven, 15, and 30 days.
The Transaction Log statistics successfully return historical data.
SQL Diagnostic Manager 12.2 correctly triggers email notifications for Database Full (Percent) and Filegroup Full Space (Percent) alerts.
SQL Diagnostic Manager 12.2 successfully triggers email notifications for Log Full (Percent) alerts.
The Blocked Sessions alert is successfully triggered in the configured response alert time.
SQL Diagnostic Manager successfully triggers the Unsubscribed Transactions (Seconds) alert once is configured and enabled.
The CPU Statistics report correctly shows trends for CPU usage, displaying the correct values for the CPUActivityPercentange alert.
SQL Diagnostic Manager allows you to clear the recommendation alerts from the Alert Recommendation window until it raises again.
SQL Diagnostic Manager allows you to snooze operational alerts but not clear them from recommendations.
The Alert Configuration timeout value has been changed to get better performance.
SQL Diagnostic Manager now correctly generates Blocking alerts and reports.
SQL Diagnostic Manager correctly excludes databases from the Days Since Last Backup metric when exclusions are defined.
SQL Diagnostic Manager correctly monitors the status of the DTC service.
SQL Diagnostic Manager dismisses Availability Group Role Change alerts correctly.
SQL Diagnostic Manager no longer generates the "Unhandled exception: SplitterDistance must be between Panel1MinSize and Width - Panel2MinSize" when using the desktop client under certain screen resolutions.
Users can now successfully add an existing user from one cluster to another while maintaining the original security settings.
SQL Diagnostic Manager allows you to correctly check the licensed SQL Server instances in the Manage Servers window.
SQL Diagnostic Manager console works as expected with more than 100 servers registered.
SQL Diagnostic Manager can now successfully enable/disable Maintenance modes using Tags.
The Tags view displays data with more than 100 created tags.
The Add Server Wizard now saves the Query Monitor settings when the SQL Server instance is added.
SQL Diagnostic Manager 12.2 successfully connects to monitored SQL servers after the KB5004442 Microsoft patch has been applied.
The SQL Diagnostic Manager Management Service no longer crashes when there are more than one SNMP action provider configured.
SQL Diagnostic Manager 12.2 response time has been improved.
SQL Diagnostic Manager's recommendation engine has been updated to include additional recommendations found in SQL Doctor.
The SQL Diagnostic Manager repository database now supports 2012 and higher compatibility levels.
SQL Diagnostic Manager correctly displays the session status of ROLLBACK after a session is killed.
SQL Diagnostic Manager now successfully displays Disk Activity information for cluster shared volume drives (CSVFS) databases.
SQL Diagnostic Manager correctly populates the list of mount points on the monitored instances.
You can now successfully perform the Analysis Status of Azure instances.
SQL Diagnostic Manager services perform successfully, making it possible that the Aggregation and Grooming jobs to work as expected.
The Long Send Rate (KB/s) metric now works as expected in High Availability Groups.
The Availability Group History browser successfully displays the replica role status on particular instances.
The user can successfully add a new user after upgrading SQL Diagnostic Manager.
SQL Diagnostic Manager no longer generates sys.availability_group_listeners errors when monitoring Azure SQL Databases.
Forecast alerts are successfully generated for Azure Manage Instance and Azure SQL Databases.
SQL Diagnostic Manager correctly reports the correct values for the SQL Server Usage (Percent) metric.
SQL Memory Usage metric correctly calculates the percentage of the total memory used by Azure SQL servers.
SQL Server Agent Long Running Job (Percent) metric now provides the correct value.
SQL Diagnostic Manager correctly associates query data to the correct monitored instance.
SQL Diagnostic Manager successfully gathers query data through Query Monitor on instances containing databases that have a trailing space in the database name.
SQL Diagnostic Manager allows you to successfully refresh your data in any Query View.
Users can now successfully configure the Query monitoring on any environment.
SQL Diagnostic Manager successfully provides Query Plans. You can fetch them by clicking on the green icons of the Detail column of the Event Occurrences table.
History Browser successfully changes the custom settings when moved to other servers.
This build includes many fixed issues, including the following updates from previous releases.
When the Deadlock report is generated, SQL Diagnostic Manager sends the email with the correct data.
SQL Diagnostic Manager added a synchronization state column to the Availability Group Topology report.
The Deadlock report includes all the collected data.
Custom Counters reports are now exported successfully.
The Availability Group Statistics report works as expected. The report is generated within the expected time.
The Deadlock report lists all the deadlocks and no deadlock is repeated.
The Add Custom report wizard's UI works as expected.
SQL Diagnostic Manager now successfully collects data for the Database Growth Forecast report.
In the Overview Dashboard, the Lock Waits report correctly displays data for all the instances.
Database Full (Percent) alert is woking as expected, it is not displaying false data.
SQL Diagnostic Manager now successfully saves the Where metric severity has changed condition when it is checked or unchecked.
SQL Diagnostic Manager correctly monitors the servers and SQLDM Management service memory consumption is as expected.
SQL Diagnostic Manager now correctly generates the OS Privileged CPU and User CPU Usage alerts.
The Filegroup Space Full (percent) and Log Full (percent) alerts are working as expected when the database is set to 'no autogrowth' and the alerts configuration is set to 'Yes, alert con the currently used size divided by the maximum possible size'.
The Blocking Session Wait Time (seconds) alert is working as expected. The date and time displayed are equal to the deadlock creation time.
The All Servers Thumbnail view works as expected when a server alert triggers a status change.
SQL Diagnostic Manager now takes primary nodes instances to generate the Days since last backup alert, avoiding false alerts.
The Session CPU Time(seconds) alert raises for on-premise instances.
When a job exceeds the time limit, the SQL Server Agent Long Running Job (Percent) alert raises. If the job is stopped, completed, or canceled the alert is deactivated.
The Filegroup Space Full (percent) and the Log full (percent) alerts work as expected.
Days since last backup alert works as expected on secondary replicas (AlwaysOn) instances.
The Availability Group Estimated Data Loss (Seconds) triggers a critical alert after the Suppression Time alert and a warning alert before the Suppression time alert.
SQL Diagnostic Manager gets Baseline alerts successfully.
SQL Diagnostic Manager successfully notifies alerts for failed SQL Jobs by sending an email.
SQL Diagnostic Manager 11.1.6 now triggers the correct Days since last backup alerts.
The File Group Space Full (Percentage) alert correctly reports within the expected parameters.
SQL Diagnostic Manager now correctly triggers the Days since last backup alert for secondary replicas.
SQL Diagnostic Manager now correctly detects the drives with WMI and OLE automation for added local instances.
Desktop Console view keeps custom views changes after adding servers.
SQL DM Repository does not use Deprecated Data Types anymore when SQL Server 2019 hosts it.
SQL Diagnostic Manager successfully refreshes data of the selected server, keeping the original server name.
SQL Diagnostic Manager allows selecting more than one-month of data across servers.
Users' permissions are now working as expected. Users with view access permissions cannot access all options in SQL Diagnostic Manager
The History Browser Range is properly populated according to the selected time range.
When adding a new server, the Advanced Encryption Options section shows the correct options to encrypt connections.
SQL Diagnostic Manager server type remains unchanged after adding or updating the server.
SQL Diagnostic Manager is no longer displaying the “Reading default instances failed:System.InvalidCastException" error when saving historical snapshots.
SQL Diagnostic Manager now saves the configuration for the newly added Baseline.
When SQL Diagnostic Manager installation completes successfully, the Installshield Logs are deleted.
SQL DM is no longer raising unhandled exceptions when adding a server (Azure, Amazon, Windows).
SQL DM now allows special characters for usernames or passwords.
The grooming is no longer filling the transaction log.
SQL Diagnostic Manager now installs the correct Native Client 2012 version.
SQL DM supports 4K resolution by successfully scaling and displaying screens, icons, and text.
SQL Diagnostic Manager is no longer prompting unhandled exceptions when launching.
Password values are masked in the 'SQLDMMasterInstaller.log'.
After installing SQL Diagnostic Manager, the Connect to SQLDM Repository dialog pops up successfully to specify the location of your repository.
SQL Diagnostic Manager shows the correct supported version on the Server Wizard.
SQL Diagnostic Manager opens the properties window for unreachable instances in the expected time frame.
The refreshing time for the Database Summary and Availability Groups is shorter than before.
The LastDatabaseCollectionTime database is successfully populated in the repository as well as in the console application with an offline database.
The SQL Databases summary shows the right values for the Compatibility level column.
SQL Diagnostic Manager shortened the loading times in the Queries view and you can properly navigate between tabs in DM console.
SQL Diagnostic manager now works as expected when navigating across different instances tabs.
SQL Diagnostic Manager Console only installer checks for the right .NET Framework.
SQL DM is no longer showing a refresh error when navigating to the Files Tab under the Database tab.
SQL DM is no longer showing a refresh error when navigating to the Disk Size Tab under the Resources tab.
SQL DM is no longer displaying a refresh error when navigating to the TempDB Summary Tab under the Databases tab.
After a closeout, SQL Diagnostic Manager keeps the servers added to the new custom views created in "My views".
SQL Diagnostic Manager Console works as expected when the Server View Refresh is set at 30 seconds for large environments.
Tempdb disks work as expected. They save the drive information of the monitored instance. Besides, the hostname name returns the server name on which the query runs.
Disabling Collection of Replication Statistics feature is now working correctly.
The ServerActivity table is no longer growing unexpectedly large.
SQL DM now successfully generates the reports and alerts for the fragmentation table.
The Analyze tab is working as expected.
SQL Diagnostic Manager shows recommendations correctly when monitoring Azure SQLDB.
SQL DM is no longer having issues when a SQL server account is created by SQL dm Recommended Permissions on-premises script avoiding raising Probe Permission Violation warnings and collecting OS data.
The prescriptive analysis performs as expected for scheduled jobs.
SQLdmManagementService.exe successfully runs after upgrading SQL Diagnostic Manager.
The SQLdmCollectionService log now shows the expected logging information.
SQLdm Management service now successfully updates the repository.
The IDERA Dashboard performance was improved and is working as expected.
The High Availability Groups successfully collect replication metrics, showing them in the Replication tab of the Server's Services view.
Days since last backup alert works as expected on secondary replica (always on) instances.
Monitored AlwaysOn servers are successfully contacted, making the AlwaysOn Listener - DB accessible.
Availability Group snapshots displays without any error message.
The Aggregate Data SQLdmRepository works as expected after upgrading SQLDM to 10.4.2.20.
SQL Diagnostic Manager now works as expected when upgrading to the latest version with SQL server 2005 instances.
After upgrading to SQL DM 11.1.6, SQLDM shows correctly the main views ensuring its proper functioning.
SQL Diagnostic Manager now correctly displays the graphics from the Dashboard view.
SQL Diagnostic Manager now displays the graph text fully, graphs have a gradient, and all databases are listed under the databases dropdown.
The overview tab now correctly displays the transactions per second graph.
SQL Diagnostic Manager disables some metrics that Azure SQL DBaaS Template cannot monitor.
The Dashboard of the Overview tab for Azure-managed instances now displays the network widget.
Query Monitor works as expected. It collects no data for Azure SQL Instances when it is not enabled.
SQLDM now allows reconfiguring instances from Windows to AzureDB
The Analysis Configuration view is available for RDS instances.
Query Monitor successfully collects data on Azure SQL MI servers.
The BDaaS Metric Category has two new subcategories for Amazon RDS and Azure DB.
SQL Diagnostic manager now adds SQL Azure DBaaS instances and successfully refreshes its servers' alerts.
SQL DM Console successfully traces sessions on monitored Azure Managed Instances.
The correct value of the OS memory usage metric now displays in the dashboard graph and in the alert configuration.
The Filegroup Space Full(Percent) metric is no longer displaying false data.
The SQL Server services metric status now works as expected with suppression value.
The Advanced Options window behaves as expected with all metrics.
The SQL Server CPU Usage (Percent) metric now reports within the expected values.
SQL Diagnostic Manager now successfully saves the threshold values for the Oldest Open Transaction (minutes) metric.
By default, the Days since last backup metric is deselected in the alert configuration popup for cloud servers.
SQL Diagnostic Manager now successfully triggers an Alert Response when all the custom counters are Critical.
Query Details are displayed by clicking the globe icon on Statement Mode and Signature Mode.
SQL Diagnostic Manager now includes two options to collect session data for SQL Server: Collect extended data from session details and Collect extended data from locks and blocks.
The Queries tab gets data loaded faster than before.
The Queries view loads faster and work as expected.
SQL Diagnostic Manager is loading correctly when Query Waits uses Extended Events.
SQLDM allows monitoring Services from the Replication tab.
SQL Diagnostic Manager now displays the correct Replication Topology data.
SQL Diagnostic Manager works as expected while attempting to apply a template to a monitored instance.
By default, SQL DM automatically selects a template in the Add Servers Wizard.
The History Browser Range is properly populated according to the selected time range.
The History Browser returns query results within a 60-seconds time frame
The SQL Server Agent Job (Percent) metric correctly calculates the percentage value.
The 'Database Full (Percent) metric is working as expected when the Alert Suppression is configured.
The default configuration of the "SQL Server Error Log" metric correctly applies the 10MB file size limit.
The SQL Server Browser metric is no longer raising alerts when only a default instance exists on the monitored server.
The "Days since last backup" metric is no longer raising alerts for read-only databases that have been excluded from the metric.
The SQL Server Agent Job Failure metric correctly raises alerts as expected.
The "Days since last backup" metric now correctly works in Availability Groups environments.
The SQL Server Agent Status metric correctly returns to an OK state when the service is detected to have been started.
The "The deadlock victim was spid 0 with application name 'unknown' by user 'unknown' on host 'unknown" alerts are no longer displaying.
Alert Response rules are now correctly starting Query-wait statistic collection as it was configured.
Corrected various issues with the Deadlock graphs and Alerts view within the SQLDM Web Console.
Fragmentation alerts are triggering successfully after performing an upgrade.
SQL Diagnostic Manager now raises alerts for Database Full (percent) metric in console when filtering by percentage.
The alert for the "Page Life Expectancy" metric now takes the correct thresholds showing the right alerts.
The advanced "filter by percentage" option correctly raises alerts as expected.
The advanced alert filter for the 'Data File Autogrowth' alert is now correctly excluding databases.
SQL Diagnostic Manager automatically applies certain alert templates based on the server type of the monitored instance.
The Database widget under the Overview screen is now displaying data for the historical mode.
Monitored instances are now correctly removed from SQL Diagnostic Manager.
SQL Diagnostic Manager is no longer encountering an overflow error when a monitored SQL Server Agent Job is running longer than usual.
SQL Diagnostic Manager is correctly sending OK status notifications and email notifications.
SQL Diagnostic Manager desktop console is no longer showing slow performance when monitoring a large number of instances.
SQL Diagnostic Manager correctly applies baseline settings to other monitored instances.
Customized Dashboards in the SQLDM Desktop Client are now correctly saved in the repository database.
SQLDM successfully applies new baselines' configuration to monitored instances.
Now SQL Diagnostic Manager successfully shows paging graphics in the Memory Screen of the Resources tab.
Improved the stability of the SQLDM Management Service.
SQL Diagnostic Manager now correctly monitors Availability Group servers with reading/write permissions.
The Disk Statistic report is now correctly showing the total number of drives of a monitored server.
When the user runs the report for CPU or Memory statistics selecting Show Baseline, it returns Actual and Baseline Stats.
The "Top Query" report now works successfully for all production servers.
The Database Growth Forecast report correctly categorizes system databases when using the database selector.
SQLDM-29184 SQL Diagnostic Manager now correctly alerts table fragmentation based on the table size configuration.
SQLDM-30421 The advanced Alert Filter for the "Longest Running version Store Transaction (Minutes)" alert is working as configured.
SQLDM-30487 The 'Clear Alert" option in the 'Availability Group Role Change' alert has been restored.
SQLDM-30528 SQLDM shows "Recommendations are available" operational alert in the Active Alert list.
SQLDM-30788 SQLDM Disk space alerts are now correctly triggering after an upgrade.
SQLDM-30825 The Disk Full alerts are no longer triggered for excluded disks in the alerts configuration.
SQLDM-30963 SQL Diagnostic Manager now correctly shows the correct alerts and thresholds for page life expectancy metric when using the Critical-Only Template.
SQLDM-31039 The "Show Historical View" button in the Alerts Tab is now working as expected.
SQLDM-29208 The 'Enable the Query Wait' Alert Action will properly execute when an Alert Response is triggered.
SQLDM-30083 SQL Diagnostic Manager no longer encounters an error when removing an instance that happens to be a replica within an availability group.
SQLDM-30197 SQLDM now discovers preferred replica information from Availability Group settings.
SQLDM-30344 The notifications for blocked sessions and SQL Agent Job Failures when monitoring RDS instances are now working correctly.
SQLDM-30385 The newly created custom counters are added to the existing templates and can be applied to new servers.
SQLDM-30524 The Custom Counter alerts when using T-SQL script are raising correctly.
SQLDM-30575 The Database status is now displaying accurate status.
SQLDM-29005 SQLDM now correctly add new servers and allows to select 'Extended Events' as the collection method for the Activity Monitor.
SQLDM-29033 The performance of the query that collects Replication Statistics has been improved.
SQLDM-29384 SQL Diagnostic Manager now correctly monitors its own repository.
SQLDM-29408 SQLDM installation is now completing successfully when the service account credentials contain special characters.
SQLDM-30114 SQL Diagnostic Manager now correctly reports the Publisher Names for SQL Server 2016 SP2 or later.
SQLDM-30364 Desktop Console Views now correctly keeps the custom views.
SQLDM-30453 IDERA Newsfeed is correctly configured after installing SQL Diagnostic Manager.
SQLDM-30480 SQL Diagnostic Manager now correctly displays baselines.
SQLDM-30493 SQLDM Desktop console now correctly shows the critical SQL Server Service status.
SQLDM-30770 SQL Diagnostic Manager successfully checks SQL Browser Service Alert status when the Remote Administrative connection is disabled and there is only a default SQL Server instance installed.
SQLDM-30936 SQL Diagnostic Manager displays the correct information when you select a secondary tab.
SQLDM-31025 The pause button now correctly works and it is integrated with the refresh button.
SQLDM-31042 SQL Diagnostic Manager now correctly displays the "Session Details" grid.
SQLDM-31068 The Query History view under the Queries tab is working as expected.
SQLDM-31070 The "View Session Details" option is now correctly working.
SQLDM-31071 The "View Locks" option is now correctly working.
SQLDM-29069 The 'Disk busy per disk' metric graph now correctly loads under the Disk option from the Resources tab.
SQLDM-30037 The blocking displayed in the reports and in the graphs are synced correctly.
SQLDM-30137 The Alert Configuration window is no longer displaying inaccurate threshold graphs.
SQLDM-28327 SQL DM successfully connects to Hyper-V Host Configuration.
SQLDM-30032 SQLDM web console is no longer reporting FIPS compliant environment errors.
SQLDM-30260 The IDERA Dashboard login information is now correctly encrypted.
SQLDM-30350 The SQLDM Web Console no longer encounters exceptions when IDERA Dashboard and the monitored instances are in different time zones.
SQLDM-30526 The Overview tab in the web console is no longer displaying an exception when clicking the summary under the Active Alerts widget.
SQLDM-30686 SQL Diagnostic Manager no longer erroneously reporting "Maintenance mode started" when maintenance mode has been disabled.
SQLDM-30859 The Databases category metrics now correctly raise alerts and send email notifications.
SQLDM-30397 SQLDM now correctly creates historical snapshots when Query Monitor is enabled and configured to use Query Store.
SQLDM-30664 Powerscript now successfully enables Query Monitor.
SQLDM-21051 SQLDM successfully runs SSRS reports when more than 126 instances are selected.
SQLDM-28648 SQLDM successfully collects information for disk drives volume formatted in ReFS.
SQLDM-30170 After upgrading SQLDM from 10.3 to 10.4 version, the Queries tab now correctly loads information.
SQLDM-30312 SQLDM now correctly triggers and notifies alerts for the Session CPU Time after performing an upgrade.
SQLDM-28938 The SQLDM Desktop Console now displays the correct alerts when hovering the mouse over an object on the Server pane.
SQLDM-29434 Alert timeline view is now displaying the time based on the Operating System settings.
SQLDM-29594 SQL Diagnostic Manager now correctly checks and alerts High Fragmentation on the databases.
SQLDM-29840 Alert Suppression for the SQL Server Service metric is now working as expected.
SQLDM-30434 Alert Responses no longer requires the 'Where Alert Rank' option to be enabled in order to be triggered as expected.
SQLDM-30381 Upgrade attempts of SQL Diagnostic Manager should no longer encounter an error regarding a constraint on the CloudProviders table.
SQLDM-30370 An issue preventing upgrades from versions 10.4.2 and 10.4.3 has been resolved.
SQLDM-30369 The custom Dashboards are no longer being deleted when upgrading from SQLDM 10.4.
SQLDM-29523 The snapshot data collection is no longer failing for Azure SQL PaaS instances.
SQLDM-30299 SQL Diagnostic Manager now correctly monitors Azure DBaaS and is no longer displaying errors.
SQLDM-30188 SQL Diagnostic Manager now correctly displays Session details on Azure SQL Database.
SQLDM-30013 SQLDM now correctly displays databases hosted in Azure SQL PaaS.
SQLDM-29782 Powered off instances are no longer shown as active in the SQLDM console.
SQLDM-30244 The SQLDM Desktop Console will now properly convert the timestamps to local time when viewing the backup/restore history of a database.
SQLDM-30136 SQL Diagnostic Manager will now generate a warning when the SQLDM Desktop Console is launched if it determines that the license key will be expiring soon.
SQLDM-30100 The Custom Counter reports now correctly displays data.
SQLDM-29671 SQLDM now correctly shows the Query Wait collector status.
SQLDM-30098 The timeline on the Query Waits view will now be displayed in the correct order.
SQLDM-30012 SQL Diagnostic Manager now correctly detects all the specific disk drives for each SQL Server registered.
SQLDM-29997 SQLDM desktop console now correctly connects to the SQLdmManagement Service and is no longer throwing exception errors.
SQLDM-20002 The SQLDM Web Console now displays timestamps using local time.
SQLDM-28516 The SQLDM Web Console now correctly displays the Last Backup Date of a database.
SQLDM-29921 SQL Diagnostic Manager can now be manually registered in the IDERA Dashboard.
SQLDM-29900 vCenter servers for monitored SQL servers in SQLDM can be added without problems.
SQLDM-29802 *The 'Days since last backup' metric has been updated to include additional advanced options specific for availability groups.
SQLDM-29785 SQLDM now properly monitors the status of DTC and SQL Server Agent when collecting operating system statistics using OLE Automation.
SQLDM-28878 The Disk Space Usage report in the SQL Server Reporting Services portal is no longer asking the value for the Disk parameter.
SQLDM-29020 SQL Diagnostic Manager now collects deadlocks in Session > Blocking View and in Reports when using Extended Events or SQL Trace.
SQLDM-29685 Database Growth Forecast report now correctly shows sufficient data.
SQLDM-19304 The "Aggregate Data SQLdmRepository" and "Groom SQLdm Repository" SQL Agent jobs now correctly run when the SQLDM Repository Database is hosted in an availability group.
SQLDM-28366 SQL Diagnostic Manager is now showing correct mount points for monitored secondary replicas.
SQLDM-20369 The databases in an SQLDM Availability Group now correctly capture growth statistics.
SQLDM-28629 SQLDM Desktop Console no longer crashes when accessing the Availability Group view under Databases.
SQLDM-28907 Improve the load time on the Availability Group databases view.
SQLDM-29229 SQL Diagnostic Manager is no longer displaying errors and is successfully connected to servers holding repositories in an availability group without a listener.
SQLDM-29547 SQLDM is no longer having problems collecting Database size data when monitoring Availability Groups instances.
SQLDM-29463 The Wait statistics are no longer displaying inconsistent values.
SQLDM-29006 The SQL Queries from the deadlock drop down output are no longer truncated.
SQLDM-28694 SQLDM now correctly shows the closest historical snapshot when switching servers.
SQLDM-28606 SQLDM no longer generates login failures for 'SQLDiagMgr' in the SQL Server Error Log.
SQLDM-28603 SQL Diagnostic Manager now correctly shows the table sizes.
SQLDM-28327 SQLDM now correctly collects the CPU virtualization information on Hyper-V virtual environment.
The Alert Suppression settings for the Availability Group Synchronization Health metric now functions as expected.
Alert Summary for the Blocking Session Wait Time (Seconds) metric is not displaying time using the local time zone.
The alerts "SQL Server Agent unable to monitor" and "WMI service is unavailable" are no longer triggered when the monitored servers are successfully connected to the WMI service.
SQL Diagnostic Manager is no longer prompting an error when performing an Analysis, which was caused by the Prescriptive Service not installing "TracerX.Logger.dlll" file.
History Browser is no longer used for Prescriptive Analytics with the revised interface.
SQL Diagnostic Manager now successfully completes analysis and the results are displayed as expected.
The SQL Diagnostic Manager Web Console correctly displays the statuses of monitored instance.
The SQL Diagnostic Manager Web Console now correctly honors the Application Security settings that is configured in the SQL Diagnostic Manager Desktop Console.
The IDERA Dashboard now correctly displays the federation drop down menu.
The 'Days since last backup' metric no longer generates alerts for databases that have never been backed up
The PowerShell now correctly works when the $AlertText is used for the Blocked Sessions Wait Time (Seconds).
When configuring the "Oldest Open Transaction" metric, SQL Diagnostic Manager now correctly saves the exclusion filter value when wildcards are used.
Improved the performance of the SQL Diagnostic Manager Desktop Client when updating properties of a monitored SQL Server instance.
Index rebuilding operation in SQLDM desktop console now correctly works and is no longer displaying errors.
The Deadlock Report now correctly displays all the information about the deadlocks occurred in the monitored instances.
The error "Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints" is no longer displaying when running the "Detailed Session Report".
The Deadlock Report now correctly shows the total number of deadlocks.
The Database Statistics report no longer encounters a timeout error when generating the report.
The Detailed Session Report now successfully deploys to SSRS.
When monitoring a SQL Server instance using a privilege minimized user, Query Monitor and Wait Statistics collection will now resume upon a restart of the SQL Diagnostic Manager services.
The SQLDM Management Service no longer crashes when a server has been registered as a Linux instance.
SQL Diagnostic Manager now correctly monitors SQL Server 2000 instances.
SQLDM now correctly monitors SQL Server 2005 instances.
The error "SQL Agent unable to monitor" is no longer prompting when monitoring instances running specific SQL Server versions.
SQLDM now correctly shows the OS memory usage on the newly added servers.
The "Error interpreting File Activity Collector: Invalid column name 'unused_size'" error is no longer displaying after upgrading to SQLDM 10.3.
The SQLDM desktop console now correctly works after an upgrade to 10.3.1 version.
SQL Diagnostic Manager no longer generates an error message indicating that sysadmin rights are required in order to collect OS Metrics.
SQLDM now correctly refreshes the Mirroring history of a database.
The refresh error when navigating in the Query Waits screen is no longer displaying.
SQL Diagnostic Manager is no longer generating an error related to Procedure Cache when monitoring Azure SQL Database.
Enabling maintenance mode on an ad-hoc basis no longer purges the scheduled maintenance mode settings. This allows users to easily restore schedule maintenance mode settings as needed.
The SQL Diagnostic Manager Desktop Client is no longer returning error messages when viewing data on monitored Azure Databases.
The metric "SQL Server Log size" is triggering alerts as expected.
The SQL Diagnostic Manager Web Console is correctly reporting the statuses of the monitored SQL Server instances.
Improved performance of the SQL Diagnostic Manager Web Console.
The SQL Diagnostic Manager Web console correctly recognizes users configured in Application Security.
SQL Diagnostic Manager is no longer reporting persistent deadlocks from the [p_InsertDatabaseSize] procedure.
The SQL Diagnostic Manager Desktop Client now correctly displays dates based on the Operating System settings.
The SQLDM Graphical User Interface now correctly responds and no longer hangs.
Improved performance when updating Monitored SQL Server Properties within the SQL Diagnostic Manager Desktop Client.
The Desktop console is no longer displaying random exceptions.
SQL Diagnostic Manager now correctly sends alerts in a timely manner via email.
SQLDM now correctly imports Alert templates.
When hovering over a monitored instance on the Servers panes view, the displayed tooltip now correctly displays the current active alerts.
The Alert suppression threshold now correctly works and triggers alerts as expected.
The PowerShell now correctly works when the $AlertText is used for the Blocked Sessions Wait Time (Seconds).
Table Statistics collection is now properly excluding specified databases that are hosted on a case sensitive collation.
The Enterprise Summary report now correctly lists the SQL Server version of the monitored instances.
Improved memory consumption by the SQLdm Management Service.
The SQLdm Management Service remains in a running state if the SQL Server instance hosting the SQLdm Repository database is unavailable.
SQL Diagnostic Manager will correctly report the status of the SQL Server Agent Service on SQL Server 2008 R2 instances.
No new features for this release.
SQLDM-29486 The SQL Diagnostic Manager Desktop Client is no longer encountering latency issues when navigating between monitored instances.
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.
SQLDM-28824 SQL Diagnostic Manager now correctly imports alert templates.
SQLDM-28940 The alert suppression threshold now correctly works in SQL Diagnostic Manager.
SQLDM-28844 An unhandled exception is no longer being encountered when accessing the Queries tab in the SQL Diagnostic Manager Desktop Client.
SQLDM-28932 When monitoring an Amazon RDS SQL Server instance, SQL Diagnostic Manager is no longer encountering the ‘The EXECUTE permission was denied on the object 'xp_fixeddrives', database 'mssqlsystemresource', schema 'sys'’ exception.
SQLDM-28957 The SQLdm Management Service is no longer encountering issues when reading metric threshold settings from the repository database.
SQLDM-29015 SQL Diagnostic Manager is no longer reporting the error: "Unable to connect to SQL Instance - Custom counters file view is out of memory"
No new features for this version.
No new features for this version.
The exception displayed when accessing Sessions > Locks is no longer shown.
The Sessions Details view and the Locks view are displaying normally. The “Sysadmin privileges to obtain data for this view” message is no longer showing in these views.
SQL Diagnostic Manager is no longer displaying false grooming alerts.
SQL Diagnostic Manager has 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 Diagnostic Manager allows you to launch SQL Workload Analysis in context of your monitored server from the desktop console and the IDERA Dashboard. For more information, see Launch SQL Workload Analysis.
Time-based drilldown any graph in the desktop console and in the web console to select any time range to zoom in for more detail.
SQL Workload Analysis launch points in different components of SQL Diagnostic Manager desktop and web console.
SQL Diagnostic Manager has a new History Range Control in the desktop console and web console that allows you to choose the time range you need, specifying the start time and end date; as well as current snapshot.
An issue that caused CPU spikes on the primary node of a monitored Always On availability group has been fixed.
SQL Diagnostic Manager is no longer reporting problems when displaying alerts and snapshots.
The active Alerts are displayed normally in the SQLDM web console.
The "Unable to monitor" alert related to the following description: "[Server Name]Error interpreting Job Alerts Collector: Column name or number of supplied values does not match table definition. [Server Name] Error executing Job Alerts collector: Column name or number of supplied values does not match table definition" is no longer displaying after an upgrade.
The high memory consumption and the constant crashing of the SQLdm Collection service and the SQLdm Management service are no longer occurring.
An issue that would stop the SQLDM Collection Service from monitoring one or more SQL instances has been fixed.
The SQLDM Management Service no longer crashes when it encounters a malformed Alert Rule.
While monitoring RDS SQL Server instances, SQLDM is no longer receiving errors while navigating through the panes in the desktop console.
SQL Diagnostic Manager provides the following new features and fixed issues.
10.1.4 New featuresNo new features 10.1.4 Fixed issuesAlerts
Alert response
Availability Groups
Custom Counter
Dashboard
Data collection
Graphs
Logs
Queries
Replication Monitoring
Reports
Repository
Sessions
SQL Server Agent
Web console
Other issues
10.1.1 New featuresSQL Diagnostic Manager allows you to launch SQL Workload Analysis in context of your monitored server from the desktop console and the IDERA Dashboard. For more information, see Launch SQL Workload Analysis 10.1.1 Fixed issuesReportsThe Transaction Log Statistics report is no longer showing erroneous used size values. The Disk Space History report is no longer encountering the 'String or binary data would be truncated' error. Query MonitorQuery Monitor is no longer reporting a captured stored procedure as both a SQL Batch and a Stored Procedure when Query Monitor is configured to collect queries using Extended Events. Query monitor is no longer capturing queries that do not meet threshold definitions. Procedure CacheSQLDM is no longer having issues when accessing to the Procedure Cache tab. SQL Server CPU Usage (Percent)SQLDM is no longer reported inflated values for the SQL Server CPU Usage (Percent) metric on monitored instances running on systems with hyper-threaded CPU. Server Log fileThe IDERA Dashboard is no longer recording the user login and password in the server.log file. Cloud instances SQLDM is no longer encountering the 'Read login mode failed:System.IndexOutOfRangeException: Index was outside the bounds of the array' error while attempting to retrieve live data from a monitored instance running on Amazon EC2. Blocked Sessions GraphsThe Blocked Sessions graphs report correctly the number of deadlocks that were detected by SQLDM. Prescriptive AnalysisThe Prescriptive Analysis is no longer encountering the ‘Error converting data type nvarchar to float’ error while saving the collected data into the SQLDM repository database. Grooming SQLDM is now grooming the DatabseFileStatistics table in the SQLDM repository database. Alerts The Alerts pane is no longer having issues loading any active alerts due to a timeout with the query being issued against the SQLDM repository database. This query has been optimized to retrieve the list of active alerts in a timely manner. 10.1 New featuresHealth Index CalculationModify the index calculation scale factor for each type of alert. Assign instances more or less importance in the overall heatmap ranking by modifying their scale factors. For additional information, see Heatmap Calculation Configuration. Use Instance Friendly Name in Web ConsoleThe Friendly Name assigned in the Desktop Console can also be used in the Web Console. For more information, see Assign a friendly name to your SQL Server instance. Query Waits Alert Response ActionCollect more information by enabling the collection of Query Waits when the criteria for an alert response rule is met. For additional information, see Query Waits Action Provider. SCOM Alert Response ActionSend an Event or an Alert to SCOM in response to an alert when the criteria for the new alert rule is met. For additional information, go to SCOM Event Action Provider and SCOM Alert Action Provider. PowerShell Alert Response Action Specify a PowerShell script to run in response to an alert when the criteria for the new alert rule is met. For additional information, see PowerShell Action Provider. PowerShell Snap-in Added FunctionsCustomize your monitored SQL Server properties with new cmdlets. For more information, see Customize your Monitored SQL Server properties within PowerShell. Independent Scheduling of Multiple BaselinesAdd and schedule multiple baseline periods in addition to the default baseline. For additional information, see Schedule multiple baselines. 10.1 Fixed issuesGeneralThe SQLDM Desktop is no longer showing slow performance that was caused by retained data from deleted instances. Grooming processThe grooming process has stopped the exceeding growth of the SQLStatementsOverflow table. Monitor AlwaysOn Availability GroupsThe monitored Availability Group Listeners no longer have issues gathering information from the primary replica. The “Unreadable availability replica” status is no longer displaying in the databases that are part of AlwaysOn Availability Groups. Collection serviceEnabling maintenance mode for all monitored instances is no longer causing SQLDM Collection Service crash. Troubleshoot WMI connectivity issuesAfter troubleshooting the WMI connectivity issues the “WMI is not available on the server” alert is no longer displaying. |
10.0.2 New featuresThere are no new features. 10.0.2 Fixed issuesGeneral
Report
Query waits
Query Monitor
Alerts
Tables & Indexes view
Custom Counters
10.0.1 New features There are no new features. 10.0.1 Fixed issuesGeneral
Blocking Sessions view
Reports
10.0 New featuresPrescriptive analysisRun or schedule a prescriptive analysis or workload analysis on a specific SQL Server instance to identify and resolve common areas of SQL Server performance problems such as queries, database objects, and more. The analysis results in useful configuration and tuning recommendations that you can apply. For additional information, see Analyze your SQL Server instance. Multiple baselines Define and schedule any number of baseline periods. View relevant baseline in effect in various metric graphs plus enable alerting and recommendations to review thresholds. For additional information, see Configure server baseline options Multiple SQL Diagnostic Manager custom dashboardsGraphically create multiple custom dashboards by dragging-and-dropping widgets. Easily control time range across widgets, add, edit, duplicate, and remove dashboards. Use your multiple dashboards to compare metrics across your monitored instances. For additional information, see Create custom dashboards Import/Export alert response In SQL Diagnostic Manager 10.0 you can select alert responses to import or export . For additional information, see Configure how SQL Diagnostic Manager responds to alerts . Import/Export wizardThe Import/Export wizard centralizes all SQL Diagnostic Manager import and export capability for customization. In one stop import or export all your alert responses, alert templates, custom counters, and custom reports. For additional information, see Use the SQL Diagnostic Manager Import/Export wizard Top Servers reportGenerate a report on a specific metric (e.g. CPU utilization) and clearly view the top 10 servers with the highest threshold over a given timeframe. For additional information, see Top servers custom report. Self-service licensing model In SQL Diagnostic Manager 10.0 you can login to the or launch the license manager utility to generate your own license keys. For additional information, see Generate a new license key. Web console improvements Federated Overview screensAccess aggregated views and functions for all your SQL Diagnostic Manager Repositories connected to the IDERA Dashboard. Filter results by tags, a specific SQL Diagnostic Manager Repository, a specific SQL Server Major version, or an instance name through wildcard characters. For additional information, see Navigate the web console dashboard. New common Dashboard widgetsUse any of the eighteen Top X widgets available for customization in the Overview tab or the Details view of the IDERA Dashboard. For more information on this feature, see Navigate the IDERA Dashboard New color-coded Alerts Timeline viewEasily identify the highest alert for your monitored instance at any point in the time and the highest alert for a specific category. Select a default time range or a customized one, filter timeline results by category and display order. For more information on this feature, see View your SQL Server alerts. Query Waits view enhancementsRe-designed Query Waits by Time and Query Waits by Duration views. New Wait Category dimension to display, selectable time range, and improved navigation from one view to another. For more information, see View your SQL Server query waits information. Databases Summary view enhancements Select multiple databases to display as horizontal stacked bar charts. For more information, see View your SQL Server databases information. Collapsible side panelHide or expand the side panels of the SQL Diagnostic Manager Overview view. For more information, see Navigate the web console dashboard.
10.0 Fixed issues General
Web console
Newsfeed
|
9.1.2 New featuresThere are no new features. 9.1.2 Fixed issuesGeneral
IDERA Dashboard |
9.0 New featuresIntegration with the IDERA DashboardSQL Diagnostic Manager 9.0 now integrates with the IDERA Dashboard, a common technology framework, designed to support the IDERA product suite. Users are able to obtain an overview of the status of their SQL Servers and hosted databases all in a consolidated view and navigate to individual product dashboards for details. The IDERA Dashboard provides a central set of services for managing users, product registry, instance registry, aggregated alerts across IDERA applications, a central web server, and tags for grouping instances. For additional information, see Navigate the IDERA Dashboard. New advanced query viewsSQL Diagnostic Manager 9.0 takes SQL Diagnostic Manager’s capabilities around query monitoring and diagnostics to the next level with a new Main Query view along with two low-level views (Query Signature and Query Details views). Users are now able to explore query data in multiple ways and easily get a handle of query performance in their environment. In SQL Diagnostic Manager 9.0 query monitoring is enabled by default for SQL Server instances running SQL Server 2008+, and collection is performed through Extended Events which has minimum impact on your SQL Server performance. Improved query monitoring allows for capturing of Query Execution Plans and provides graphical representations of the same in the Plan Diagram of the Query Details view. In addition, you can view the actual XML, SQL Text, and referenced columns of a query execution plan. For additional information, see View your SQL Server queries information. Improved and integrated SQL Diagnostic Manager web console SQL Diagnostic Manager 9.0 provides a fully functional web console that integrates seamlessly with the IDERA Dashboard (common technology framework) and is easy to access from any connected browser. The SQL Diagnostic Manager web console provides the overall status of a SQL Server environment to help diagnose any issues. Users can quickly view the status of a single instance or instance groups, view all active alerts in their SQL Server environment and drill down for details, or select different sub-views to diagnose performance issues faster, and view top values for selected metrics. In addition, users are able to access the new advanced query views (see above) only from the SQL Diagnostic Manager web console and not from the SQL Diagnostic Manager desktop client console. For additional information, see Navigate the web console dashboard. Licensing and version upgrading –Upgrade to SQL Diagnostic Manager 9.0 Customers upgrading from previous SQL Diagnostic Manager versions to SQL Diagnostic Manager 9.0 need a new license key or it is not possible to continue with the upgrade process. Users can access the IDERA Customer Portal at the moment of upgrade from the license management window in SQL Diagnostic Manager (Help > Manage Licenses) or directly at https://idera.secure.force.com. Information necessary to generate a new license key is provided in the license management screen or the portal. Help documentation –SQL Diagnostic Manager Help (User Guide and Release Notes) is now wiki-hosted and available at wiki.idera.com > SQL Diagnostic Manager. 9.0 Fixed issuesQuery Monitor
Queries
Alerts
Reports
|
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. |
7.5.4 New FeaturesGeneralCharts now properly manage real-time and scheduled collection data in the same time spanSQL Diagnostic Manager charts provide data whether collected real time or as part of a scheduled collection event. If you pause or leave this view and then return during the same Console session, SQL Diagnostic Manager displays the real-time data points as previously viewed, followed by a period of data points from any scheduled collections that occurred while you were away. For additional information about how SQL Diagnostic Manager displays charts, see Charts. QueriesQuery Waits now located on Queries tab The Query Waits feature is no longer located on the Resources tab but now is available on the Queries tab. For additional information about Query Waits, see View Query Waits. AlertsManage how the SQL Diagnostic Manager Console responds to alert notificationsSQL Diagnostic Manager can now play a sound when an event triggers an alert to change states. You can also control how SQL Diagnostic Manager displays the resulting alert notification in the Console. For additional information about Console notifications for alerts, see Configure notification settings. Set SQL Diagnostic Manager to notify you of only critical alertsUse the Notifications section of the Console Options feature to set SQL Diagnostic Manager to notify you for only critical alerts. You can select whether you want to view or even play a sound when a critical alert occurs. For additional information about Console notifications for alerts, see Configure notification settings. MobileSQLdm Mobile & IDERA Newsfeed now supports IIS 8SQLdm Mobile & IDERA Newsfeed now supports IIS 8 on Windows 2012 and Windows 8 environments. For additional information about SQLdm Mobile & IDERA Newsfeed requirements, see SQLDM Mobile and IDERA Newsfeed requirements. 7.5.4 Fixed IssuesGeneral
Servers
Alerts
Reports
Counters/Custom Counters
7.5.3 New FeaturesThere are no new features for SQL Diagnostic Manager 7.5.3. 7.5.3 Fixed IssuesGeneral
7.5.2 New FeaturesThere are no new features for SQL Diagnostic Manager 7.5.2. 7.5.2 Fixed IssuesGeneral
Overview
Sessions
Resources
Alerts
Reports
7.5.1 New FeaturesThere are no new features for SQL Diagnostic Manager 7.5.1. 7.5.1 Fixed IssuesGeneral
Overview
Sessions
Resources
Logs
Alerts
Reports
7.5 New FeaturesThere are no new features for SQL Diagnostic Manager 7.5. 7.5 Fixed IssuesGeneral
Virtual Machines
Dashboard
Server Overview
Sessions
Resources
Databases
Services
Alerts
Reports
Custom Counters
7.2.2 New FeaturesThere are no new features for SQL Diagnostic Manager 7.2.2. 7.2.2 Fixed Issues
7.2.1 New FeaturesSQL Server 2012 RTM SupportSQL Diagnostic Manager 7.2.1 supports the use of SQL Server 2012 RTM version. Users who implement the SQL Server 2012 AlwaysOn functionality should note that while SQL Diagnostic Manager seamlessly monitors servers with this feature enabled, it does not currently administer or diagnose issues with AlwaysOn. 7.2.1 Fixed Issues
7.2 New FeaturesMonitoring SQL Server virtual environmentsGet complete insight into the performance of your virtualized SQL Server databases. Monitor and track VMware-specific performance counters allowing you to get a complete performance picture of the SQL Server environment. Two VM-related reports provide performance trends and a summary of your virtualized environment. For additional information about configuring the new VM functionality, see Configure your virtual machine connections. SQL Server 2012 experimental supportSQL Diagnostic Manager 7.2 is SQL Server 2012 RC0 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 2012 AlwaysOn functionality should note that while SQL Diagnostic Manager seamlessly monitors servers with this feature enabled, it does not currently administer or diagnose issues with AlwaysOn. For additional information about SQL Diagnostic Manager and SQL Server 2012, see SQL Diagnostic Manager requirements. SQLdm Mobile viewsSQLdm Mobile features a new server dashboard specifically for tablets and incorporated VMware monitoring data. For additional information about the new SQLdm Mobile features, see SQLdm Mobile Help. Reporting on Tempdb StatisticsYou can now run the Tempdb Statistics report to quickly identify and keep tabs on tempdb performance-related issues. For additional information about the new tempdb report, see Tempdb Statistics report. SQL Server Memory Usage Percent counter available for custom reportsYou can now select the SQL Server Memory Usage Percent counter when creating a custom report. For additional information about creating a custom report, see Custom reports. Updated alert notification functionalitySQL Diagnostic Manager now allows you to suppress system tray notifications when a monitored SQL Server instance returns to an OK status. Click Tools > Console Options. On the Notifications tab, check the Never show console alert notifications when the server status goes to OK checkbox, and then click OK. For additional information about the Management Console options, see Configure Console Options. CPU Statistics report now available in a custom range of hoursThe CPU Statistics report now includes an option for you to select a custom date range and view results in hours. To select this range, click Reports > CPU Statistics. Select the appropriate monitored SQL Server instance, and then select Custom Range from the Period drop-down list. Use the calendar tool to select the range, and then click OK. Select Hours from the Sample drop-down list to view your results in hours. For additional information about the CPU Statistics report, see CPU Statistics report. Input how long SQL Diagnostic Manager waits before raising an alert for a long-running jobUsers can now specify a minimum job length for the SQL Server Agent Long Running Job (Percent) alert. This may be used to prevent alerting on short or trivial jobs. For additional information about configuring job exclusions, see Configure Job Exclusions. 7.2 Fixed Issues
7.1.1 New FeaturesThere are no new features for SQL Diagnostic Manager 7.1.1. 7.1.1 Fixed Issues
7.1 New FeaturesNew SQL Server dashboardSQL Diagnostic Manager now features a completely redesigned dashboard, which dramatically expands the display of your performance data and simplifies the view of the overall health of a SQL Server instance. For additional information about the new dashboard, see the SQL Server performance overview. New Tempdb monitoringYou can now quickly identify and resolve tempdb performance-related issues with the new tempdb monitoring and diagnostic views. For additional information about the new tempdb monitoring functionality, see tempdb status summary. New SQLdm Mobile viewsThe following new views in SQLdm Mobile make diagnosing performance issues even easier while you're on the go:
For additional information about SQLdm Mobile, see SQLdm Mobile Help. View and copy SQL Agent Job messages from the Job History listSQL Diagnostic Manager now allows users to view SQL Agent Job messages from the Job History list. Right-click the appropriate job, and then select View Message. A copy feature allows you to copy the existing message and then paste it into a different application. For more information about SQL Agent jobs, see how to Monitor SQL Agent Jobs. 7.1 Fixed Issues
7.0 New FeaturesNew SQLdm Mobile interfaceSQL Diagnostic Manager now offers a Web application (SQLdm Mobile) that displays real-time SQL Server performance dashboards on a variety of mobile devices, including iPhone, iPad, Android and Blackberry. SQLdm Mobile includes the IDERA Newsfeed technology. The IDERA Newsfeed is a revolutionary new way for DBAs and managers to collaborate, share knowledge, and keep close tabs on their most critical SQL Server issues. New Alert TemplatesSQL Diagnostic Manager now offers alert templates, which allow a user to configure generic alert settings to apply to monitored SQL Servers or groups of servers all at once. You can create and assign alert templates to any of your monitored SQL server instances. New Informational AlertsInformational alerts allow you to set a threshold that triggers a status that does not affect the overall status of the server within SQL Diagnostic Manager. You can use informational alerts to notify an administrator of the state of a particular metric for a server or trigger secondary processes that could take action to prevent issue escalation. Improved Alert Response UsabilityAlert Response rules, which configure how SQL Diagnostic Manager responds when an event triggers an alert, are easier to create and manage due to an updated interface and process. Users can now apply an alert response rule to all metrics quickly and easily. Improved Notification Times for Unresponsive SQL Server InstancesSQL Diagnostic Manager can now alert you more quickly when one of your monitored SQL Server instances becomes unresponsive for any reason. Although the default is set to 30 seconds, you can adjust the interval at which the Collection Service checks whether your SQL Server instances are “up” or available. If a connection is not confirmed within the specified time, SQL Diagnostic Manager creates an Unable to Connect alert. Improved Metrics CollectionThe Collection Service now:
Improved Repository PerformanceThe SQL Diagnostic Manager Repository database will perform more efficiently due to the following enhancements:
New ReportsSQL Diagnostic Manager now offers the following new reports:
7.0 Fixed IssuesAlerting UpdatesSQL Diagnostic Manager now offers the following updates to alerting:
Fragmentation Monitoring UpdatesSQLdm now offers the following updates to your table fragmentation monitoring:
SQL Server Statistics UpdatesSQL Diagnostic Manager now offers the following updates to the functionality that collects and analyzes your SQL Server statistics:
Reporting UpdatesSQL Diagnostic Manager now offers the following updates to reporting:
|
| | | | | | | |