Page History

...

SQL Diagnostic Manager provides the following new features and fixed issues.

10.1.4 New features

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

• SQLDM is no longer having timeouts when viewing large Databases under table and indexes.
• SQLDM displays tables normally without delays.
• The “Days since last backup” metric is only available for Online databases.
• The index DatabaseStatistics has been added to the UTCCollectionTime nonclustered index for a better performance.
• The IDERA Products option in Help Menu on the SQL Diagnostic Manager Desktop Console is linked to the navigation page and is no longer prompting error.
• SQLDM is no longer having issues when using a non-standard Short Date format.
• The Monitored SQL Server Properties dialog box in SQLDM Desktop console is opening without any timeouts.

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.

...

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.

...

• An issue causing Query Monitor to be disabled after Maintenance Mode no longer occurs.

Alerts

• There are no longer any issues preventing alert templates from being edited after making changes in the "Days since last backup" metric configuration.
• There are no longer any issues causing operational query monitor alerts to be triggered repeatedly due to an XML parsing error in SQL Diagnostic Manager.
• The Days since last backup alert now works seamlessly in an availability group environment.
• The Days since last back up alert is no longer triggered for database snapshots.
• The Days since last back up alert is no longer triggered for mirrored databases.
• There are no longer any issues preventing alerts from being triggered properly in the desktop console after upgrading SQL Diagnostic Manager.
• The details section of the Alerts view now displays the full list of recorded error log messages for SQL Server Error Log alerts.
  

...

• Anchor
  DE43895DE44647 DE43895DE44647

  This release fixes an issue with unsigned executables that occasionally blocked upgrades or resulted in security concerns that files may be corrupted.  In SQL Diagnostic Manager 10.0 executable binary files are digitally signed.  
  

Web console

• Anchor
  DE44618 DE44618

  An issue preventing the Databases view of the  web console from populating when a database is offline no longer occurs.

...

• Anchor
  DE45058 DE45058

  An issue preventing filegroup statistics to be saved to the SQL Diagnostic Manager Repository, no longer occurs. This issue was specific to filegroups aiming at Mount Point drives.
  

Alerts

• Anchor
  DE44878 DE44878

  An issue causing the Filegroup Space Full (percent) alert to trigger with higher than normal percentage values after upgrading to SQL Diagnostic Manager 9.1, no longer occurs.

...

• Anchor
  DE44429 DE44429

  This release fixes a Windows 7 compatibility mode issue that prevented users from installing SQL Diagnostic Manager past the selection of a SQL Server instance to use for the Repository Database. An upgrade to InstallShield solved this issue.

Web console

• Anchor
  DE44232 DE44232

  An issue preventing the SQL Diagnostic Manager web console from displaying, no longer occurs with the full integration to the IDERA Dashboard.

...

• Anchor
  DE41293 DE41293

  An arithmetic overflow error causing the Query Waits view of the SQL Diagnostic Manager Management console to display an empty pane, no longer occurs.

Alerts

• Anchor
  DE40847 DE40847

  This release fixes an issue that caused fragmentation alerts to trigger without updating the latest value returned in the Databases > Table & Indexes view, resulting in false alerts.

• Anchor
  DE43965 DE43965

  An issue preventing users from receiving critical Database Full (Percent) alerts no longer occurs.

• Anchor
  DE43963 DE43963

  This release fixes an issue where SQL Diagnostic Manager triggered a false unable to monitor SQL Server status alert when an invalid or nonexistent SPID was found during collection.

• Anchor
  DE43915 DE43915

  This release fixes an issue where SQL Diagnostic Manager triggered false critical Database Full (Percent) alerts for several servers when the actual values were much lower and did not require an alert notification.

...

• Anchor
  DE42595 DE42595

  An issue preventing users from enabling the Query Monitor in monitored SQL Server 2000 instances no longer occurs.

Queries

• Anchor
  DE3932 DE3932

  An issue in the Queries tab and corresponding Statement mode, Signature mode and query history views, causing queries exported into Excel to truncate, no longer occurs.

Alerts

• Anchor
  DE41690 DE41690

  This release fixes an issue that prevented users from knowing when Repository grooming had timed out.  SQL Diagnostic Manager 9.0 includes a new alert SQLdm Repository Grooming Time out that notifies users when SQL Diagnostic Manager no longer deletes stored metrics in the Repository at the set schedule.  To configure this alert access the Alert Configuration window.

Reports

•  

  Anchor
  DE41961 DE41961

  An issue preventing users from running the Disk Details report of the Resources analysis reports no longer occurs.

...

• An issue causing Data File Spaced Used and Log File Space Used values in the Overview > Details view to vary from the real server values no longer occurs.
• This release fixes an issue where the number of sessions displayed in the Sessions > Details view, after applying the Affecting Tempdb only filter, does not match the number of sessions in the Databases >Tempdb Summary view.
• An issue preventing disk drive statistics to return in the Disk view of the Resources tab no longer occurs.
• This release fixes an issue that caused the Query waits and Query History views to lag displaying data when the frequency of how often the console refreshes data was modified in the Tools > Console Options window.
• SQL Diagnostic Manager is designed to return the information that you want to view in the Signature Mode, Statement Mode, and Query History views through filters. However, the filter Exclude Currently Running Queries that excludes data returned with null values is not applicable to the Query History view and is now disabled by default.

Alerts

• An issue issue causing OS Disk Full (Percent) alerts to trigger for disk drives previously excluded from alerting in the Alert Filters tab of the Advanced Configuration window no longer occurs.
• This release fixes an issue impeding the Deadlock Sessions report with detailed deadlock information to display when right-clicking (Show Deadlock Details) or double-clicking over a deadlock alert in the Alerts view. Note that after upgrading to our latest version it is not possible to view deadlock details for alerts generated in SQL Diagnostic Manager 8.5 since this issue prevented deadlock information from being stored.
• This release fixes an issue impeding the Blocking Sessions report with detailed blocking and blocked sessions’ information to display when right-clicking (Show Block Details) in the Alerts view, double-clicking over a Block report in the Blocking view, or clicking the Show Block Details link in the Details section of the Alert view. Note that after upgrading to our latest version it is not possible to view block details for alerts generated in SQL Diagnostic Manager 8.5 since this issue prevented block information from being stored.
• An issue impeding new custom counters to be added in the Administration tab is solved.

...

• This release fixes an issue present after upgrading to SQL Diagnostic Manager 8.5 with custom counters that had customized categories. This issue caused a .NET framework error and the SQL Diagnostic Manager Console to crash when clicking any monitored server.

Dashboard

• An issue preventing the Lock Waits and Tempdb panels from displaying in a customized Dashboard view no longer occurs.

Reports

• An issue preventing the Top Queries report to deploy correctly into a Microsoft Reporting Services Server no longer occurs.
• This release fixes an issue where a custom report was deployed into the Microsoft Reporting Services Server instead of the selected report in SQL Diagnostic Manager with a similar name.

...

• An issue causing settings in the Monitored SQL Server Properties window to revert no longer occurs.
• This release fixes an issue in deadlock data collection that caused discrepancies in the UTCCollectionDateTime.
• An issue causing SQL Diagnostic Manager to display an error on the monitored SQL Server 2014 instance when expanding the databases node, no longer occurs.
• Some users may experience Windows console crashes, applying the Microsoft update 2919355 solves this issue. For additional information on this solution, see the Microsoft knowledge base articles:
  • Out of memory when you load some image resources in a Windows application.
  • Platform update for Windows 7 SP1 and Windows Server 2008 R2 SP1.

Alerts

• An issue preventing cluster failover alerts to be triggered no longer occurs in SQL Diagnostic Manager 8.5.
• An issue preventing SQL Diagnostic Manager to update statistics for some monitored SQL servers that triggered a persistent alert ‘Unable To Monitor’ no longer occurs in version 8.5.

Reports

• This release fixes an issue impeding the VM Statistics report to display correctly.
• An issue preventing users from exporting the Blocking Sessions report in XML no longer occurs.
• An issue preventing the CPU Statistics report to display correctly when being deployed to the Microsoft Reporting Services no longer occurs.

...

This 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

• The transactions (Per Second) metric now displays correctly in the History Browser when user selects a historical snapshot.
• This release fixes an issue where after modifying the advanced configuration settings of the SQL Server Status alert, the Lowered to OK status still showed.

...

An issue causing an unknown value in the User/Schema column of the Procedure Cache view no longer occurs.

Reports

An issue preventing users from running the Alert History Report after deployment to Reporting Services no longer occurs.

...

SQL 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.

Queries

Query 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.

Alerts

Manage how the SQL Diagnostic Manager Console responds to alert notifications

...

• SQL Diagnostic Manager no longer pauses data point creation in other real-time panels when the user accesses the Timeline view.
• This release fixes an issue caused when the scheduled refresh did not successfully complete, resulting in missing History Browser snapshots.
• The SQL Server Plan Cache object no longer continues to grow with SQL Diagnostic Manager queries even with the SQL Server Optimize for ad hoc workloads server configuration option selected.
• The SQL Diagnostic Manager Powershell plug-in now properly puts monitored SQL Server instances into maintenance mode when selected.

Alerts

• The Autogrow alert no longer displays the same previous and current data file size when viewing alert details in the Alerts view.
• SQL Diagnostic Manager no longer dismisses certain alerts when SQL Diagnostic Manager generates an Unable to Connect, Unable to Monitor, or Paused alerts. These alerts include SQL Server Agent job alerts, VM Host Server Change, VM Resource Configuration Change, Mirroring Server Role Change, and Cluster Failover alerts.
• SQL Diagnostic Manager no longer displays an incorrect percentage in the Database Full (Percent) alert.
• SQL Diagnostic Manager no longer delays generation of some Oldest Open Transaction alerts until the transaction is significantly older than the alert threshold. The alert now triggers immediately when the transaction crosses the threshold.
• An issue preventing some users from monitoring multiple instances and causing job completion error alerts no longer occurs.

Reports

• The Server Summary report now correctly displays statistics graphs and grids even when the results include no data for that interval.
• The Server Statistics report now consistently applies the UTC offset to both servers when using the report to compare two servers.

...

• An issue causing SQL Diagnostic Manager to display some monitored SQL Server instances more than once in the Servers tree no longer occurs.
• The CPU Dashboard panel no longer displays an occasional red "X" in the Call Rates chart when the panel is resized.

Sessions

• SQL Diagnostic Manager no longer displays the messages, "Error executing Session List collector: Arithmetic overflow error converting expression to data type int," or "Error processing Session List Collector: Object reference not set to an instance of an object," when some users attempt to access pages in the Sessions view.

...

• SQL Diagnostic Manager no longer displays the error message, "The given key was not present in the dictionary," when a user attempts to view Server Waits.

Alerts

• SQL Diagnostic Manager custom counters now properly trigger alert responses.
• Deadlock and Autogrow alerts no longer persist after the triggering condition is resolved.

Reports

• SQL Diagnostic Manager no longer displays the message, "Item with the same key has already been added," when some users attempt to run the Top tables by Growth or Top Tables by Fragmentation report.
• Users can now select the time of day in all SQL Diagnostic Manager reports by using the Start Hours and End Hours fields.

...

• The Memory, Network, and Virtualization panel chart selections are now properly saved when a user saves a Dashboard layout.
• Timeline users who double-click an alert to access the Alerts pane with the selected alert highlighted now receive the proper selected alert information in the Details pane of that view.

Sessions

• On a case-sensitive server, the Sessions Blocking graph now shows the correct deadlocks in the sessions.

...

• The Query Waits graphs right-click menu options View Text and View Query History are now operative.

Logs

• A user interface update fixed an issue causing some Microsoft Windows 7 users to see a cut-off Search window in the Log tab.

Alerts

• SQL Diagnostic Manager and the Windows Event Log now both show accurate metrics for the OS Disk Free Space (Size) alert.

Reports

• Users who attempt to schedule email notifications for some reports no longer receive an error message at the end of the wizard.
• Generation of the Top Databases report is improved, preventing the report from suffering a time out because of the long load time.
• Disk Details report users no longer receive an exception message when attempting to run the report with the Drive Name field selection of All Drives.

...

• An issue in the SQLdm Management Service causing some VM statistics to not display for monitored virtual SQL Server instances no longer occurs.

Dashboard

• An issue causing the CPU Dashboard panel to display 0 when a greater value should appear no longer occurs. This issue was caused by SQL Diagnostic Manager switching from one counter to another at certain refresh rates when calculating CPU values.

...

• SQL Diagnostic Manager no longer attempts to delete a monitored SQL Server instance in some situations when the user pressed the Delete key while in the Server view.
• An issue causing some users to receive an exception error when attempting to view Server Details after quickly clicking through different panes of the SQL Diagnostic Manager Management Console no longer occurs.

Sessions

• The Y-axis unit of time measurement now appears in the Sessions > Locks Wait Time chart as "ms" (milliseconds).

...

• The SQL Agent Jobs list now retains the open (+) and closed (-) settings after a refresh. This list also remains on the same row after a refresh and no longer jumps to the top of the list.
• An issue causing the job collector to fail for some users no longer occurs. This issue occurred when the user attempted to filter jobs or job categories with a string that included a single quote character (') in the title.

Alerts

• The Alerts pane now retains your column sort selection when you return to the pane after visiting another page, as when investigating an individual alert.
• SQL Diagnostic Manager now sends an alert when a cluster failover occurs even when the server appears as offline in the preceding refresh of the SQLdm Collection Service. Previously, this situation would not trigger a cluster failover alert.
• The Session Tempdb Space Usage (MB) alert now triggers based on the Total User Space Used and no longer includes the Total Internal Space Used in the calculation. This update fixes an issue where users received an alert that shows a tempdb session using more space than the entire size of tempdb.
• The Cluster Failover alert no longer displays a timestamp of 1-1-1900 when an event triggers an alert.
• The Unsubscribed Transactions alert now displays the resulting time in hours, minutes, and seconds for easier comprehension.
• This release fixes an issue that caused some users to receive alerts stating that the data files are over 1000.00% full.
• Users no longer receive multiple email messages for the same alert.

Reports

• Users no longer receive the error message, "An error occurred while retrieving data for this report. Additional information: Invalid Column name. (Microsoft SQL Server, Error: 207)," when attempting to run a custom report.
• An issue causing the Top Queries report to appear empty when the user selected a Custom Range older than seven days no longer occurs.

...

• • Unauthorized users can no longer access data for restricted SQL Server instances when viewing a report through SQL Server Reporting Services. This issue affected all users who restrict access to specific instances using Application Security features. This update improves data security and prevents confusion when a user unwittingly views data for the wrong instance.
  • Users can now select up to 10 Windows, SQL Server, and/or custom counters when creating a custom report. These additional counters provide more flexibility and detail in your reports.
  • If a custom counter contains special characters (<>%-), then your custom report generation fails with the error: Field names must be CLS-compliant identifiers. A CLS-compliant Custom Counter name uses the following rule: the first character of an identifier can be an uppercase or lowercase, titlecase, modifier, or other letter, or letter number. The subsequent characters can be any of the previously-mentioned characters, plus non-spacing or spacing combining marks, decimal numbers, connector punctuation, and formatting codes.

...