SQL diagnostic manager

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

Powerful Performance Monitoring and Diagnostics

• Continuous monitoring and analysis: Provides continuous monitoring and real-time analysis of SQL Server and OS health and performance metrics across all SQL Servers enterprise-wide.
   
• History Browser: Quickly and easily diagnose historical SQL Server performance problems by selecting a historical point-in-time to view historical SQL Server and OS performance metrics.
   
• Custom monitoring: ability to add any SQL, Windows or DMV counter for total flexibility in monitoring and alerting.
   
• Identification of worst-performing code: Identifies performance bottlenecks such as the worst-performing stored procedures, long-running queries, most frequently run queries, SQL Statements and SQL batches.
   
• Detailed process status and monitoring: Displays current process list, including which process is using the most resources.
   
• Fragmentation statistics: Displays fragmentation statistics to help you identify indexes that may need attention.
   
• Pinpoints blocking processes: Identifies the process at the head of the blocking chain for easy resolution.
   
• Adaptive alerting and notification: Automatically identifies alert threshold recommendations based on historical performance data.
   
• Knowledge Base: Provides the ability to add custom environment-specific details to reduce problem resolution time, increase availability, and increase internal awareness.
   

Enterprise Management Features

• Enterprise-class scalability: Large numbers of servers can be monitored from a single console, providing an unprecedented level of visibility and control of the SQL Server environment.
   
• Application security: Flexible customization of server access and security permissions allow DBAs to have full access to one or more servers while other users such as Help Desk Operators are provided read-only access.
   
• Easy-to-understand, customizable views: Server status, performance, and diagnostic metrics are organized into logical, easy-to-understand graphs, tables, and grids. Grid views can be customized to each user’s specific preferences.
   
• Central Data Repository: Stores all historical performance data in a central repository, enabling analysis of long-term trends, capacity planning and other strategic analysis.
   
• Powerful reporting: Includes predefined reports highlighting key performance trends, along with an easy to use reporting interface for users to conduct customized historical performance trending and analysis.
   
• Agent-less, low impact monitoring: Provides simple, secure data collection from a background service. No agents or components of any kind are installed on the monitored SQL Servers, providing comprehensive monitoring with very low overhead.