SQL diagnostic manager is a powerful performance monitoring and diagnostics solution that proactively alerts administrators to health, performance or availability problems within their SQL Server environment, all from a central console.
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.
Automatically identifies alert threshold recommendations based on historical performance data and automatically take corrective action.
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.
Ability to 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 and wait stat monitoring: Identifies performance bottlenecks such as the worst performing queries along with what resource is causing the longest wait time, long-running queries, and most frequently run queries.
Monitor tempdb, replication and mirrored environments: Monitor and alert on performance issues affecting tempdb, mirrored database or replication environments.
Fragmentation statistics: Displays fragmentation statistics to help you identify indexes that may need attention.
Predictive alerting: Forecasts what alerts are likely to occur based on an analysis of past performance and current activity.
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.
Mobile and Collaborative Features
Mobile management: View real-time and historical SQL Server performance data, view or kill sessions, start/stop jobs and run queries to resolve or diagnose issues.
IntelliFeed™ Technology: Communicate and collaborate using social-networking paradigms to manage your SQL Server environment.
- Less Features
like us
follow us
link to us
channel us
join the circle