How SQL Diagnostic Manager Pro Work by IDERA

see video below

SQL Diagnostic Manager Pro

The most comprehensive SQL Server monitoring
tool is better than ever, now featuring:

• Performance monitoring for physical and virtual environments
• Transactional application monitoring with drilldown transaction analysis
• Integrated expert recommendations
• Predictive alerting with settings to avoid false alerts
• Tempdb monitoring to resolve tempdb contention and performance issues
• Web-based dashboard with at-a-glance views of top issues and alerts

Try it for 14 days free? 

SQL Diagnostic Manager Enterprise view of all your SQL Servers

One of the challenges when managing SQL Server is that you probably have several instances that need to be monitored.  Just connecting to each instance and going through the same motions over and over again is time consuming.  So having a global view of your environment is a major time saver and with SQL Diagnostic Manager you have a couple of global views to see your entire SQL Server enterprise all at once.

The first screen is the SQLdm Today screen as shown below.  This screen gives you a status summary for all of your servers, so you can drilldown into each server to address any issues.  In the image below, on the left side we have a summary listing of our servers and whether they have issues that need to be addressed.  On the right side we can see a list of alerts that need to be addressed for all of our servers.  This is a quick way to get a To Do list of items that need to be addressed for all SQL Server instances instead of having to check instance by instance.