SQL diagnostic manager

Key Technical Features

Powerful Performance Monitoring and Diagnostics

  • 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 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 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.
     

 

Copyright | SQL Tools | Legal | Privacy