Technical Features
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, including clustered configurations.
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: Easily add any SQL, Windows or DMV counter for total flexibility in monitoring and alerting.
Pinpoints session locking, blocking and deadlocks: Identify locks, deadlocks and blocked sessions and see the complete blocking chain for easy identification and resolution.
Query monitoring: Identify performance bottlenecks such as the worst performing stored procedures, long-running queries, most frequently run queries, SQL Statements and SQL batches.
Monitor replication and mirrored environments: Monitor and alert on performance issues affecting mirrored database or replication environments.
Adaptive and automated alerting: Automatically identifies alert threshold recommendations based on historical performance data and automatically take corrective action.
Fragmentation statistics: Displays fragmentation statistics to help you identify indexes that may need attention.
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.
PowerShell Snap-in: Quickly and easily script many of the SQL diagnostic manager management tasks using the PowerShell Snap-in.
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, analysis, and forecast reporting.
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.
