SQL diagnostic manager

Key Technical Features

Continuous Monitoring: Provides continuous, real-time monitoring 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
Database mirror monitoring: Monitor and alert on changes in role or any performance issues affecting the database mirrored environment.
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-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 customisation 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 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.