SQL Diagnostic Manager provides the following new features and fixed issues.
10.1.1 New features
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.
10.1.1 Fixed issues
Reports
The 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 Monitor
Query 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 Cache
SQLDM 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 file
The 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 Graphs
The Blocked Sessions graphs report correctly the number of deadlocks that were detected by SQLDM.
Prescriptive Analysis
The 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.
SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >