SQL diagnostic manager

What’s New | Key Benefits | Requirements | Technical Features

New in Version 5.7

• Bug fixes and enhancements

New in Version 5.6

• Adaptive Alerting
• Automatically identify alert thresholds recommendations based on historical performance data.
   
• Mobile Management
• View real-time SQL Server performance data on your Windows Mobile or Blackberry device.
   
• Application Security
• Customize server and access permissions for users of SQL diagnostic manager.
   
• Alert Snoozing
• Snooze an alert which temporarily disables existing alerts and prevents future alerts from being raised.
   
• Maintenance Mode Scheduling
• Extend existing maintenance mode capabilities by specifying a one-time or recurring schedule which prevents data collection and monitoring.
   
• Enhanced Query Analysis
• Quick and easy identification of poorly performing queries by query fingerprint.
   
• SQL Server 2008
• Support for SQL Server 2008 RTM.
   

New in Version 5.5

• Extendable metric monitoring and alerting
• Easily extend the list of available monitoring metrics by specifying any SQL counter, OS counter, or user-defined query. Apply these new metrics to one or more SQL Servers and SQL diagnostic manager will begin monitoring, storing, alerting and displaying the newly added metrics.
   
• History Browser
• Quickly and easily diagnose historical SQL Server performance problems by selecting a historical point-in-time to view what was happening on the server. Now, DBAs can diagnose problems the next day or go back in time to investigate an issue that may be happening at a particular time of day.
   
• SQL Server 2008
• Provides pre-release support for SQL Server 2008 (Feb CTP).
   

New in Version 5.0

• New in Version 5.0 SP3: Fixes and enhancements
• New in Version 5.0 SP2: Fixes and enhancements
• New in Version 5.0 SP1: Fixes and enhancements
   
• Three tier architecture for enhanced performance, scalability and flexibility
• Multiple consoles can monitor the same set of SQL Servers
• Central data collection and management service
• Central repository of metrics information
• Completely redesigned management console, modeled after Office 2007 “ribbons” design
• New user interface design and navigation to maximize the visibility of over 230 performance metrics
• New animated single-server monitor display provides at-a-glance visibility of SQL Server health
• Ability to group servers for roll-up reporting
• Integrated reporting & historical trend analysis
• Console display and options can be customized to your personal preferences
• Enhanced notification and alerting
• Outlook-style specification of alerting rules
• Alerts can be directed to different groups based on the time of day, or type of alert
• Ability to optionally create tasks on the to do list when alerts are generated