Some of you have already volunteered to participate in the SQL Diagnostic Manager 10.2 beta. For more information about how to add your name to our list of beta contributors, see the end of this posting.
In the meantime, as we prepare to begin the beta I wanted you all more information about the new functionality we will be asking you to test.
What’s Coming in Diagnostic Manager 10.2?
Please use the follow suggestions to quickly review the new functionality:
SQL Diagnostic Manager allows you now to launch SQL Workload Analysis in context of your monitored server from the desktop console and the IDERA Dashboard.
SQL Workload Analysis dashboard displays trending database activity and top utilizing SQL statements, logins, machines, and programs.
Launch in context links between SQL Diagnostic Manager and SQL Workload Analysis, both can be launched to the same time range selection in either product.
Tip – When your SQLDM instance is registered in SWA the icon Launch SWA in the top right corner is displayed.
In both Windows Client and IDERA Dashboard, select any time range on any graph available and zoom in for more detail and isolate that time range as you navigate to other graphs.
To select anytime range, follow these steps:
SQL Diagnostic Manager also includes a New History Range Control, located at the top of the Web Console and in the option History Browser in the Desktop Console, both can be modified and be designated a specific start time and date as well as current snapshot.
Follow these steps to configure the History Range of your SQLDM Desktop Console and web console:
The new overview screen shows combined information from various components of SQL Diagnostic Manager and SQL Workload Analysis in a single overview with launch points to the respective components.
The single instance overview in SQL Diagnostic Manager web interface has a new dynamic overview page, which uses key information from both products (when the instance is monitored by SQLDM and SWA).
Also, includes shortcuts to filter data through Sessions, Queries, Resources, and Databases.
On the right side of the screen, the web console displays the Server Properties.
Configure the Alert Category graph, following these steps:
Click the graph to either drilldown to a different time range or to be redirected to SWA.
Follow these steps to manage the graphs to display in the overview of the single instance view:
SQL Diagnostic Manager Beta 10.2 has scalability and user productivity improvements which involves faster startup time, a new and faster connectivity between SQLDM and SWA, new screen displays to help a further drilldown for problem diagnosis and improve the overall workflow between screens.
The list sub-view in the SQLDM web console has a new display to help users to quickly identify the health status of the monitored instances, to navigate to the single instance dashboard, to quickly detect which instances are registered in SQL Workload Analysis, to have fast access to SWA interface whenever an instance is registered in this product, and to have a faster access to the active alerts and their status.
This new interface helps users to have a quicker assessment of instance status when comparing their instances. Also, the new display helps to coordinate operational and transactional diagnosis in context of each other.
Follow these steps to configure the displayed columns in this sub-view:
We sincerely hope that this preview has encouraged you to try out the new features and add your voice to the chorus. We rely heavily on your feedback to shape future releases and prioritize efforts to make Diagnostic Manager even more useful.
I want to remind everyone that this beta release is still in test and therefore should not be installed over your production installation. There will be no upgrade path from the beta version to the final release. Please, test on a separate environment from any running licensed installations of Diagnostic Manager.
If you are interested in participation in the beta test of Diagnostic Manager 10.2 please e-mail email@example.com