SQL Diagnostic Manager provides the following new features and fixed issues.
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 responses
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 Idera Customer Portal 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 panels
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
- 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
- An issue preventing the Databases view of the web console from populating when a database is offline no longer occurs.
Newsfeed
- An issue preventing users from creating a Newsfeed user account no longer occurs.
SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >