This build includes many fixed issues, including the following updates from previous releases.

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.

10.1 New features

Health Index Calculation

Modify 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 Console

The 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 Action

Collect 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 Action

Send 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 Functions

Customize your monitored SQL Server properties with new cmdlets. For more information, see Customize your Monitored SQL Server properties within PowerShell.

Independent Scheduling of Multiple Baselines

Add and schedule multiple baseline periods in addition to the default baseline. For additional information, see Schedule multiple baselines.

10.1 Fixed issues

General

The SQLDM Desktop is no longer showing slow performance that was caused by retained data from deleted instances.

Grooming process

The grooming process has stopped the exceeding growth of the SQLStatementsOverflow table.

Monitor AlwaysOn Availability Groups

The 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 service

Enabling maintenance mode for all monitored instances is no longer causing SQLDM Collection Service crash.

Troubleshoot WMI connectivity issues

After troubleshooting the WMI connectivity issues the “WMI is not available on the server” alert is no longer displayin

10.0.2 New features

 There are no new features.

10.0.2 Fixed issues

General

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 issues

General

Blocking Sessions view

Reports

10.0 New features

Prescriptive analysis

Run 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 dashboards

Graphically 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 wizard

The 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 report

Generate 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 screens

Access 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 widgets

Use 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 view

Easily 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 enhancements

Re-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 panel

Hide 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 features

There are no new features.

 9.1.2 Fixed issues

General

IDERA Dashboard

Disk view

 9.1.1 New features

There are no new features.

 9.1.1 Fixed issues

General

Single instance dashboard

Deadlocks

Mount Point

Alerts

Hyper-V

9.1 New features

Web console improvements

Aggregated views across multiple SQL Diagnostic Manager repositories  

SQL Diagnostic Manager users are now able to access aggregated views and functions for all their SQL Diagnostic Manager Repositories connected to the IDERA Dashboard. For example, the option to filter results by a specific SQL Diagnostic Manager Repository are included. For additional information, see Navigate the IDERA Dashboard.

Launch the SQL Diagnostic Manager Console from various views  

In SQL Diagnostic Manager 9.1 users can launch the SQL Diagnostic Manager Console from the Thumbnail and Heatmap views, as well as from the Alerts Detail screen. Upon clicking the SQL Diagnostic Manager icon , users are directed to the associated instance. In addition, users can navigate back to the Overview tab of a specific single instance dashboard from the SQL Diagnostic Manager Console.

Adjustable panels in key web console views  

The panels in the list, thumbnail, and heatmap sub-views of the SQL Diagnostic Manager web console are now adjustable, allowing users to expand panels to fit the page or to return to previous setting.

Improved thumbnail sub-view  

The thumbnail sub-view provides you with a graphical replication of your monitored SQL servers. The thumbnail sub-view is now sorted by criticality of worst alert and it includes CPU, Memory, I/O, and Response Time sparkline graphs for a 1-hour view so that users can obtain an overview of key metrics quickly. For additional information, see Use sub-views to identify and diagnose issues.

Improved heatmap sub-view  

The heatmap sub-view provides you with a visual overall status of your SQL Server environment in the form of a grid of color coded squares that contain a health index. Through its color scheme and health index, you can easily identify which of your monitored instances need the most attention. Each square in the heatmap sub-view represents a monitored instance. For additional information, see Use sub-views to identify and diagnose issues.

New web console widgets  

SQL Diagnostic Manager 9.1 contains several new widgets for practical access to specific information in both the IDERA Dashboard and the web console:

Monitoring of non-query activities with Extended Events  

In SQL Diagnostic Manager 9.1 collection of non-query events data such as deadlocks, Autogrow, and blocking is performed through Extended Events by default for SQL Server instances running SQL Server 2012+. First introduced in SQL Server 2008, Extended Events provide a new mechanism to capture information about events inside the Database Engine and diagnose performance problems. This functionality is highly efficient and lightweight, resulting in minimum impact on your SQL Server performance. For additional information, see Set activity monitor options.

Integration with the IDERA community site  

SQL Diagnostic Manager 9.1 allows users to share product content , saving valuable resources. With these new features you can import and export custom counters, custom reports and alert templates. For additional information, see Use custom counters to track metrics, Custom reports , and Configure alert templates.

Filegroup and Mount Point monitoring improvements

Configurable database filegroup alerts are now available

The Filegroup Space Full (Percent) and the Filegroup Space Full (Size) alerts allow users to track available space at the filegroup level.

New Disk Size view  

The new Disk Size view in the Resources tab allows users to view key statistics on all monitored disk drives, including mount point drives, in their environment. To access this new view, users can select an appropriate SQL Server instance, and then click Disk Size in the Views group of the Resources tab. For more information on this feature, see Get disk size details.

Disk Space Usage report available in SQL Diagnostic Manager

The Disk Space Usage report provides users with the most recent snapshot of available disk space in their environment. To access this report, users can go to Reports in the Navigation pane and select Resources > Disk Space Usage in the Analyze menu. For more information on this report, see Disk Space Usage.

Disk Space History report available in SQL Diagnostic Manager

The Disk Space History report provides an overview on available disk space with an emphasis on the historic level of activity for a specific disk. To access this report, users can go to Reports in the Navigation pane and select Resources > Disk Space History in the Analyze menu. For more information, see Disk Space History.

Monitoring of additional SQL Server services

SQL Server Active Directory Helper Status  

SQL Diagnostic Manager users are now able to monitor the status of the SQL Server Active Directory Helper service. For more information on this new alert, see SQL Server Active Directory Helper Service Status alert.

SQL Server Browser Service Status  

SQL Diagnostic Manager users are now able to monitor the status of the SQL Server Browser service. For more information on this new alert, see SQL Server Browser Service Status alert.

Server Summary report supports new SQL Server monitored services  

The Server Summary report now also displays the current status of the SQL Server Active Directory Helper service and the SQL Server Browser service. For additional information, see Server Summary.

 9.1 Fixed issues

Installation

Web console

Query views

Query waits view

Alerts

Maintenance mode

SCOM Management pack

WMI

9.0 New features

Integration with the IDERA Dashboard

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

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

Query Monitor

Queries

Alerts

Reports

8.6 New features

Full support for SQL Server Express instances

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

You 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 reports

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

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

Upgrade

General

Views

Alerts

Console

Dashboard

Reports

8.5 New features

Full support for SQL Server 2014

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

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

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

The SQLdm REST Service requires a service account that is a local administrator. If the service account provided during installation for the SQL Diagnostic Manager services is not a local administrator, you need to manually change the service account in Windows Service Control Manager.

Monitoring and alerting enhancements

Enhanced alert response usability

Ability 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 monitors

Ability 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 views

Ability 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 flexibility

Additional monthly option for scheduling maintenance mode on monitored SQL server instances. For details, see Schedule Maintenance Mode.

Virtualization counters available for custom reports

Select 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 Diagnostics

Ability 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 Report

The 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 timeouts

Configure the WMI timeout value in SQL Diagnostic Manager when suitable. For instructions, see Configure OS metrics monitoring.

8.5 Fixed Issues

General

Alerts

Reports

8.0.1 New features

There are no new features in this release.

8.0.1 Fixed issues

General

Management Service Log

AlwaysOn Availability Groups

Mobile

8.0 New features

SQL Diagnostic Manager now fully supports the AlwaysOn Availability Groups feature of SQL Server 2012

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

The 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 activities

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

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

In 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 required

The 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 support

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

General

Servers

This release fixes an issue that occurred while refreshing the Server Summary view.

Databases

An issue causing errors related to fragmentation collector timeouts or fragmentation statistics collection in the Tables & Indexes view no longer occurs.

Services

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

Resources

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.

7.5.4 New Features

General

Charts now properly manage real-time and scheduled collection data in the same time span

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 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 alerts

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

Mobile

SQLdm Mobile & IDERA Newsfeed now supports IIS 8

SQLdm 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 Issues

General

Servers

Alerts

Reports

Counters/Custom Counters

7.5.3 New Features

There are no new features for SQL Diagnostic Manager 7.5.3.

7.5.3 Fixed Issues

General

7.5.2 New Features

There are no new features for SQL Diagnostic Manager 7.5.2.

7.5.2 Fixed Issues

General

Overview

Sessions

Resources

Alerts

Reports

7.5.1 New Features

There are no new features for SQL Diagnostic Manager 7.5.1.

7.5.1 Fixed Issues

General

Overview

Sessions

Resources

Logs

Alerts

Reports

7.5 New Features

There are no new features for SQL Diagnostic Manager 7.5.

7.5 Fixed Issues

General

Virtual Machines

Dashboard

Server Overview

Sessions

Resources

Databases

Services

Alerts

Reports

Custom Counters

7.2.2 New Features

There are no new features for SQL Diagnostic Manager 7.2.2.

7.2.2 Fixed Issues

7.2.1 New Features

SQL Server 2012 RTM Support

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

Monitoring SQL Server virtual environments

Get 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 support

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

SQLdm 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 Statistics

You 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 reports

You 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 functionality

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

The 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 job

Users 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 Features

There are no new features for SQL Diagnostic Manager 7.1.1.

7.1.1 Fixed Issues

7.1 New Features

New SQL Server dashboard

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

You 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 views

The 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 list

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

New SQLdm Mobile interface

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

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

Informational 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 Usability

Alert 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 Instances

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

The Collection Service now:

Improved Repository Performance

The SQL Diagnostic Manager Repository database will perform more efficiently due to the following enhancements:

New Reports

SQL Diagnostic Manager now offers the following new reports:

7.0 Fixed Issues

Alerting Updates

SQL Diagnostic Manager now offers the following updates to alerting:

Fragmentation Monitoring Updates

SQLdm now offers the following updates to your table fragmentation monitoring:

SQL Server Statistics Updates

SQL Diagnostic Manager now offers the following updates to the functionality that collects and analyzes your SQL Server statistics:

Reporting Updates

SQL Diagnostic Manager now offers the following updates to reporting:

 

SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >
IDERA WebsiteProductsPurchaseSupportCommunityAbout UsResources Legal