Comprehensive SQL Server Monitoring

Everything you need to monitor, analyze, and optimize SQL Server performance in one self-hosted solution

Core Features

Real-Time Performance Monitoring

Collect DMV metrics every 5 minutes with <1% CPU overhead

  • •CPU, memory, disk I/O metrics
  • •Wait statistics trending
  • •Active session monitoring
  • •Tempdb utilization tracking

23 Pre-Built Grafana Dashboards

Production-ready dashboards for comprehensive monitoring

  • •Instance health overview
  • •Query Store analysis
  • •Wait statistics breakdown
  • •Blocking chain detection
  • •AWS RDS Performance Insights equivalent
  • •Index maintenance recommendations

T-SQL Code Editor

Analyze and edit stored procedures with real-time insights

  • •30+ code analysis rules
  • •Syntax highlighting
  • •Auto-save functionality
  • •Historical performance data integration

Automated Alerting System

Configure rules for proactive monitoring

  • •CPU/memory threshold alerts
  • •Disk space warnings
  • •Deadlock detection
  • •Blocking chain notifications
  • •Query Store regression alerts

Performance Insights

AWS RDS Performance Insights for on-premise SQL Server

  • •Top SQL by duration, CPU, reads
  • •Wait event analysis
  • •Session activity tracking
  • •Resource contention identification

Query Store Integration

Track query performance over time

  • •Plan regression detection
  • •Forced plan management
  • •Historical execution stats
  • •Parameter sensitivity analysis

23 Pre-Built Dashboards

Production-ready Grafana dashboards covering every aspect of SQL Server monitoring

Core Monitoring

  • ✓Dashboard Browser - Central navigation
  • ✓SQL Server Monitoring - Instance health overview
  • ✓Performance Analysis - Detailed metrics drilldown
  • ✓Detailed Metrics - Time-series charts

Database Management

  • ✓Table Browser - Schema exploration
  • ✓Table Details - Column/index analysis
  • ✓Code Browser - Stored procedure catalog
  • ✓Code Viewer - T-SQL editor with analysis

Performance Tuning

  • ✓Query Store - Plan regression tracking
  • ✓AWS RDS Performance Insights - Top SQL analysis
  • ✓Server Health Score - Composite health metrics
  • ✓Query Performance Advisor - Optimization recommendations

Operations

  • ✓DBCC Integrity Checks - Corruption detection
  • ✓Index Maintenance - Fragmentation analysis
  • ✓Alert Monitoring - Active alerts dashboard
  • ✓Audit Logging - Security audit trail

Capacity Planning

  • ✓Baseline Comparison - Historical comparisons
  • ✓Trend Analysis - Growth projections
  • ✓Capacity Planning - Resource forecasting

Technical Excellence

Push Architecture

Each server collects its own metrics and pushes to central database

Benefit: Scales to 100+ servers with no central bottleneck

Columnstore Compression

10x compression on performance metrics table

Benefit: 90-day retention uses minimal disk space

Automatic Partitioning

Monthly partitions with sliding window maintenance

Benefit: Fast queries and automatic old data cleanup

Row-Level Security

Stored procedures enforce security at database level

Benefit: No dynamic SQL in application code

PDF/PNG Export

Built-in Grafana image renderer for dashboard export

Benefit: Professional reports with one click

Multi-Cloud Ready

Deploy to Azure, AWS, GCP, or on-premise

Benefit: No vendor lock-in, deploy anywhere

Enterprise Security

SOC 2 compliance-ready with authentication, authorization, and comprehensive audit logging

JWT Authentication
Secure API access with 8-hour token expiration
TOTP-Based MFA
Time-based one-time passwords with QR code generation
BCrypt Password Hashing
Industry-standard password security with automatic salting
Backup Codes
10 single-use codes for MFA recovery
Session Management
Track active sessions with automatic cleanup
Comprehensive Audit Logging
All API requests logged with user, action, IP, timestamp
Role-Based Access Control (RBAC)
Flexible roles and permissions system

Ready to Get Started?

Deploy SQL Monitor in 5 minutes and start monitoring your SQL Servers today