What's new in SQL Diagnostic Manager 9.1
May 15, 2015
- Export and import configuration files to share custom counters, reports, and alert templates.
- Alerting for filegroup space used.
- New dashboard widgets to aggregate statistics across multiple instances across Diagnostic Manager repositories.
- Improved instance overview and heatmap views.
- New custom reports for top 10 lists for metrics.
- Monitoring additional SQL Server services.
- Bug fixes and enhancements.
New in SQL Diagnostic Manager 9.0 (Feb 10, 2015)
- Enhanced query plan monitoring and diagnostics – SQL DM now captures query execution plans and provides new query plan viewing and diagnostic capabilities.
- The new Main query view provides high-level query performance information across applications, databases, and users with drill down capabilities into individual queries with two additional new views.
- Query details view shows SQL text, execution plan XML, and a graphical view of the execution plan.
- Query signature view rolls matching queries into a query signature.
- Official release of the SQL DM web dashboard – The web dashboard capabilities that were introduced in DM 8.5 as a tech preview are officially released in DM 9.0. There are three primary views; Today, Top X, and Alerts.
- Today includes status of instances and groups with drill down into single instances. It shows active alerts, top issue occurrences, and can show data by thumbnail, list, and heat map views.
- Top X provides a number of configurable widgets to show the top occurrences of various performance issues.
- Alerts rollup all active alerts being generated with detailed viewing, filtering, and grouping capabilities.
New in SQL Diagnostic Manager 8.6 (Oct 22, 2014)
- SQL Server Express Support – SQL DM has extended support to cover the SQL Server Express edition.
- New database alert for Availability Group Preferred Replica – SQL DM triggers an alert whenever the primary role changes to a different replica.
- Query Waits Enhancements:
- New Query Wait Statistics Report.
- Query Waits information is now extended in the Top Servers and Top Databases reports.
New in SQL Diagnostic Manager 8.5 (Oct 22, 2014)
- Hyper-V support – SQL DM has extended virtual support to Hyper-V, providing insight into the performance of your 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.
- Monitoring and alerting enhancements -
- Ability to set up Alert Response that is triggered only after multiple user defined metric thresholds have been breached.
- Inclusion filters for Query monitors – Adds the ability to do query monitoring on selected applications.
- Tech Preview of the new SQL DM Web Console –Rapidly and easily identify problems. The SQL DM web console is designed to provide quick access to the overall status of the SQL Server environment to help diagnose any issues.
- Quickly view status of a single instance or instance groups.
- Access from any connected browser. No SQL DM Desktop Console required.
- Stand-alone web application with no need for IIS.
- Provide an easy to use web console to non-DBAs without giving access to entire management console so they can check on status for SQL Server environment.
New in SQL Diagnostic Manager 8.0 (Aug 26, 2014)
- SQLdm Management Pack for Microsoft’s Systems Center Operations Manager - integrates the key monitors and alerts of SQL Server performance metrics from SQL dm into Microsoft’s System Center console.
- Always-On availability group monitoring – SQLdm will monitor the performance of Always-On availability groups that are set up and will send alerts as needed to ensure the SQL Server is running on the designated node in the event of failover to a secondary replica. This feature includes a high-level view, 8 new alerts, and 2 reports. SQL dm can also run on an availability group as well.
- Auditing configuration changes - audit configuration changes that show up in the change log as an event to keep track of what users are doing. These changes are also captured in a new report to provide an audit trail if needed.
- Experimental Support for SQL Server 2014 - SQLdm has been tested to work with pre-release copies of SQL Server 2014. Any possible areas where monitoring works unexpectedly are noted in the documentation.
- Manageability and scalability enhancements - performance improvements have been made to the repository, reporting and alerting so data is inserted more quickly.
New in SQL Diagnostic Manager 7.5 (Jan 22, 2013)
- New Server Dashboard Panel Gallery and Templates - Users can customize their Server Dashboard to see the performance information that is the most relevant for their environment. Dashboards can be saved as templates and shared across servers or among console users.
- Server Activity Timeline - Visualize server performance events in the form of a timeline calendar—instead of simply as a list of events—to identify trends and streamline diagnostics and resolution. Events are color-coded for easy differentiation on the timeline, with a sliding scale at the bottom to zoom in to a desired timeframe.
- Enhanced Performance Baselines - Define and report on SQL Server performance baselines. Users can view the Server baseline performance values and compare a server’s baseline over time ranges, as well as across different servers. Reports will now show the baseline in the given performance metric’s graph or chart, allowing for better capacity planning for new servers.
- Per-Database and Per-Disk Alerts - Users can now get alerts on such items as OS Disk Full, OS Database Full, and OS Log Full shown for specific sizes in GBs or MBs as well as a percentage of the total size of the database.
New in SQL Diagnostic Manager 7.2.1 (Jan 22, 2013)
- Support for SQL Server 2012
- Bug Fixes and Enhancements
New in SQL Diagnostic Manager 7.2 (Jan 22, 2013)
- 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.
- SQLdm Mobile views - New server dashboard specifically for tablets and incorporated VMware monitoring data.
- SQL Server 2012 Testing Compatibility - SQLdm is SQL Server 2012 RC0 compatible in non-production environments.
New in SQL Diagnostic Manager 7.1 (Jan 22, 2013)
- New SQL Server Dashboard - Completely redesigned dashboard dramatically expands the display of the performance data simplifying the display of the overall health of a SQL Server.
- New tempdb Monitoring - Quickly identify and resolve tempdb performance related issues with our new tempdb monitoring and diagnostic views.
- New SQLdm mobile views - Three new views make diagnosing performance issues while you’re on-the-go even easier.
- Blocking Chain View
- Sessions > Top Wait Consumers View
- tempdb Monitoring View
New in SQL Diagnostic Manager 7.0.4529.2 (Oct 18, 2011)
- New SQL diagnostic manager Mobile - New web interface displays real-time SQL Server performance data on a wide-variety of mobile devices including iPhone/iPad, Android, Blackberry, Windows 7 Phone.
- New Idera Newsfeed - New revolutionary technology uses social networking paradigms to build a community of users and SQL Server system objects. Enables more effective collaboration, communication, management and faster problem resolution.
- New Alert Templates - Easily save default alert settings into an alert template that can be quickly applied to an individual or group of SQL Servers.
- Informational Alerts - Accurately represent the overall health of your servers by specifying particular alerts as 'informational'.