SQL Diagnostic Manager is a performance monitoring and diagnostics solution for Microsoft SQL Server environments. It provides continuous monitoring of database health, availability, and performance across physical, virtual, and cloud deployments. The software enables database administrators to identify root causes of performance problems through real-time monitoring, historical analysis, and diagnostic metrics. It collects and stores performance data in a centralized repository, allowing trend analysis, forecasting, and capacity planning. SQL Diagnostic Manager includes adaptive alerting with pre-defined and customizable thresholds. Alerts can be configured to notify appropriate teams and can trigger automated responses such as scripts or system notifications. The architecture runs outside SQL Server processes and consists of centralized services for management, data collection, and predictive analytics. A desktop console and web-based components provide access to real-time and historical information. The solution supports hybrid environments, including on-premises SQL Server instances, cloud virtual machines, and managed cloud databases such as Azure SQL Database and Amazon RDS for SQL Server.

Key Features

24x7 Performance Monitoring Continuous tracking of SQL Server health and activity.

• Monitor physical, virtual, and cloud environments
• Track sessions, queries, databases, and system resources
• Real-time and historical performance visibility

Root Cause Diagnostics Tools to identify underlying performance issues.

• Analyze slow-running and resource-intensive queries
• Detect blocking and deadlocks
• Drill down into server and database metrics
• View query plans and wait-state analysis

Adaptive & Automated Alerting Configurable alerts with intelligent baselining.

• Over 100 predefined alert settings
• Baseline-based alerts to reduce false positives
• Alert smoothing and snoozing
• Maintenance mode to suppress alerts
• Automated alert response actions (email, scripts, PowerShell)

Enterprise Dashboard & Reporting Centralized visibility across environments.

• Single-pane-of-glass overview
• Enterprise and instance-level summaries
• Historical reporting and trend analysis
• Capacity planning and forecasting reports
• Deployment to SQL Server Reporting Services

Predictive Analytics Forecasting of potential performance issues.

• Hourly alert forecasting calculations
• Daily forecasting model updates
• Identify growth trends and resource constraints

Extensible Add-ons Optional modules to extend capabilities.

• SQL Workload Analysis for real-time SQL sampling
• SQL Query Tuner for query optimization
• SQL Doctor recommendations for performance tuning

Hybrid & Cloud Support Monitoring across diverse infrastructure.

• On-premises SQL Server
• Virtual machines (e.g., VMware, Hyper-V, Azure VM, EC2)
• Managed databases (Azure SQL Database, Amazon RDS)
• Hybrid cloud monitoring with a single tool

Architecture & Services Centralized service-based architecture.

• Management service for real-time data and alerting
• Collection service for scheduled and on-demand data gathering
• Predictive service for forecasting
• Central repository for performance data storage

Benefits

Reduced Downtime and Faster Resolution Helps identify and resolve issues quickly.

• Rapid root cause identification
• Reduced mean time to resolution (MTTR)
• Early detection before service impact

Improved SQL Server Availability Proactive monitoring prevents outages.

• Continuous environment monitoring
• Immediate customized notifications
• Automated corrective actions

Enhanced DBA Productivity Centralizes monitoring and automation.

• Consolidated enterprise dashboard
• Scriptable administrative actions
• Automated monitoring configuration for new instances

Better Capacity Planning Supports strategic infrastructure decisions.

• Historical trend analysis
• Growth forecasting
• Resource utilization insights

Reduced Alert Fatigue Improves signal-to-noise ratio.

• Baseline-driven thresholds
• Alert smoothing
• Customizable notification rules

Scalable Enterprise Monitoring Designed for environments from small to large scale.

• Monitor from a few to thousands of SQL Server instances
• Centralized management services
• Role-based and audience-specific alerts