Skip to content

v0.85.2 build 1130 — Alert Baselines, Azure SQL Detection, GitHub Pages

Latest
Latest

Choose a tag to compare

View all tags
@SQLAdrian SQLAdrian released this 17 Apr 00:38
v0.85.2-build1130
aba7be9
This commit was created on GitHub.com and signed with GitHub’s verified signature.
GPG key ID: B5690EEEBB952194
Verified
Learn about vigilant mode.

What's New — build 1130

🧠 Alert Baselines (Dynamic IQR Thresholds)

LiveMonitor now learns what normal looks like for each server and fires alerts when behaviour deviates from that baseline — not just when it crosses a fixed threshold.

  • Passive sample collection — every alert evaluation records a metric sample automatically; no extra SQL queries
  • IQR-based thresholds — Warning = P75 + 1.5×IQR, Critical = P75 + 3×IQR, floored at P95
  • OLS trend detection — linear regression over a rolling 72-hour window detects rising/falling trends before thresholds are breached
  • Aggressive initial seeding — on first run, all baselineable alerts are sampled every 15 seconds until 10 samples exist per server (~5 minutes)
  • Progress bar on Alerts and NOC pages shows seeding status
  • Per-server or global baseline mode (Settings toggle)
  • 33 alerts participate in baseline learning; 47 binary/SLA alerts excluded

☁️ Azure SQL Detection

  • Automatically detects Azure SQL Database (EngineEdition 5) and Azure SQL Managed Instance (EngineEdition 8) on connect
  • 30 alerts that use on-premises-only DMVs (dm_os_*, dm_server_services, xp_regread, clustering DMVs) are silently skipped on Azure SQL DB with a friendly log message

🔒 Reliability

  • SQLite WAL checkpoint on application exit (PRAGMA wal_checkpoint(FULL)) prevents cache corruption on abrupt shutdown

🌐 GitHub Pages

📝 README

  • .NET runtime and WebView2 are bundled — no prerequisites stated upfront
  • SQLWATCH correctly described as optional enhancement, not a requirement
  • 5-step quick-start at the top; comparison table vs sp_Blitz/SQLWATCH/SolarWinds/Redgate/Idera

Installation

  1. Download LiveMonitor-v0.85.2-win-x64.zip below
  2. Extract to any folder (e.g. C:\Tools\LiveMonitor)
  3. Run SqlHealthAssessment.exe — no .NET or WebView2 installation required

SQL Server permissions needed: VIEW SERVER STATE · VIEW DATABASE STATE
SQLWATCH is optional — the app monitors immediately without it.

Requirements

  • Windows 10 (1809) or later
  • SQL Server 2016 or later
  • 4 GB RAM minimum, 8 GB recommended
Assets 4
Loading