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