SQL Insight Pro — Advanced Database Performance Monitoring
Open Source · MIT License

SQL Insight Pro Advanced Performance Monitoring

Track the key metrics for SQL Server performance: Query stats, Wait statistics, Blocking, and Disk I/O. Start simple with core features – expand over time as needed.

🚀 Start in 5 minutes · PostgreSQL + Grafana · Expand as you wish
📞 Call +45 61 777 336 ✉️ Send Inquiry
3 Core Metrics
30s Update Interval
0 kr License Price
💼 Professionel Installation & Support
Get SQL Insight Pro installed and configured by experts. We also offer ongoing support and monitoring.
⚡
Query Performance Stats
Top 50 slowest queries with CPU time, elapsed time, logical reads/writes. 30 days of history included.
⏱️
Wait Statistics
Real-time display of top 20 wait types. See whether the issue is CPU, I/O, locking, or network.
🔒
Blocking Detection
Automatically captures blockings over 1 second. Full blocking chain with queries.
📊
Grafana Dashboards
Ready-to-import dashboards. No proprietary UI to learn – use the industry standard.
🔧
Simple Architecture
.NET 8 collector → PostgreSQL → Grafana. No agents, no complexity.
🎯
Focused Scope
Does one thing well: Performance monitoring. No bloat, no enterprise complexity.
🚧 Under active development
v1.0 is production-ready for basic monitoring. Features like index recommendations, anomaly detection, and multi-instance support are coming in v1.1 and v1.2.
SQL Insight Pro - Features
OPEN SOURCE SQL MONITORING

SQL Insight Pro Core Features v1.0

SQL Insight Pro starts with the most important performance metrics for SQL Server. The core version includes the essentials – with plans to expand over time based on feedback and needs.

⚡

Query Performance Stats

Track the 50 slowest queries with full history. View CPU time, elapsed time, logical reads/writes, and execution count. All updated every 30 seconds.

What You Get
✓Top 50 queries by total elapsed time
✓CPU vs. elapsed time (blocking detection)
✓Query text with parameters
✓30 days of history by default
Technical Specs
Update interval30 seconds
Data retention30 days
Query textMax 1000 chars
StoragePostgreSQL
Query Stats - Grafana
SELECT * FROM Orders 1823ms
UPDATE Inventory SET... 945ms
sp_GetCustomer @Id=... 523ms
INSERT INTO Logs... 234ms
Live data via Grafana
⏱️

Wait Statistics Analysis

Real-time display of what SQL Server is waiting on. Top 20 wait types filtered for benign waits, so you only see what matters.

What You Get
✓Top 20 wait types (auto-filtered)
✓CPU vs. I/O vs. Locking waits
✓Wait time and waiting task count
✓Trends over time in Grafana
Technical Specs
Filtered waits~60 benign types
Update interval30 seconds
Metricswait_time_ms, count
VisualizationGrafana panels
Wait Types (Real-time)
PAGEIOLATCH_SH: 42%
WRITELOG: 23%
LCK_M_S: 18%
CXPACKET: 12%
🔒

Blocking Detection

Automatically captures all blockings over 1 second. Save both blocking and blocked queries with full session information.

What You Get
✓Blocking chains with session IDs
✓Both blocking and blocked queries
✓Wait duration tracking
✓History for post-mortem analysis
Technical Specs
Threshold1000ms blocking
Check interval30 seconds
Query captureMax 500 chars
Retention30 days
Active Blocking
⚠️ Blocking Detected
Session 68 → Session 102
Duration: 3.2 seconds
Query: UPDATE Orders SET...
No active blockings right now ✓
💾

Disk Performance Monitoring

Track disk latency and IOPS directly from SQL Server DMVs. Critical for cloud and shared hosting where "noisy neighbors" can hurt performance without warning.

What You Get
✓Read/Write latency per disk
✓IOPS tracking and throughput MB/s
✓Per-database file statistics
✓Cloud throttling detection
Technical Specs
Data sourcedm_io_virtual_file_stats
Alert threshold>20ms warning
GranularityPer drive letter
Cloud readyAzure/AWS aware
Disk Latency (Real-time)
C: Drive - 8ms avg (OK)
D: Data - 45ms avg (WARNING)
E: Logs - 12ms avg (OK)
F: Backup - 5ms avg (FAST)
🚀

Upcoming Features Roadmap

SQL Monitor Core is under active development. Here’s what’s coming in the next versions.

Version 1.1 (Planned)
○Delta calculations (changes, not totals)
○Missing index recommendations
○Multi-instance support
Version 1.2 (Under Consideration)
○Query execution plan storage
○Simple anomaly detection
○Email alerts for blocking
Version 2.0 (Future Vision)
○TimescaleDB for better retention
○PostgreSQL and MySQL support
○Web UI for configuration
📊
Open Source & MIT License
Contribute with pull requests on GitHub.
Suggest features via Issues.
Build on it as you wish.
View on GitHub →

Ready to optimize your SQL Server?

Get SQL Insight Pro installed and configured in under 2 hours. We’ll help with setup, Grafana dashboards, and ongoing support.

2 hours
Installation
24/7
Monitoring
SLA
Support Agreement

SeoSoft ApS · CVR: 34048843 · Hovedgaden 3, 6064 Jordrup