CHANGELOG.md

Changelog

All notable changes to this project will be documented in this file.

The format is based on Keep a Changelog, and this project adheres to Semantic Versioning.

[2.7.0] - 2026-04-13

Added

• Host OS column in Server Inventory for both Dashboard and Lite (#748, #823)
• Offline community script support via community/ directory for user-contributed scripts (#814, #822)
• MultiSubnetFailover connection option in Dashboard and Lite for Always On availability groups (#813, #821)

Changed

• PlanAnalyzer and ShowPlanParser synced from PerformanceStudio with latest improvements (#816)
• MCP query tools optimized for large databases (#826)
• Add Server dialog UX improved with inline connection status and full-height window
• "CPUs" renamed to "Logical CPUs" for clarity in Lite (#825)

Fixed

• Dashboard auto-refresh stalling under load — replaced DispatcherTimer with async Task.Delay loop to prevent priority starvation during heavy chart rendering (#833, #834)
• Lite auto-refresh silently skipping every tick (#824)
• Deadlock count not resetting between collections (#803, #820)
• Upgrade filter skipping patch versions during version comparison (#817, #819)
• Upgrade script executing against master instead of PerformanceMonitor database (#828)
• Duplicate release builds triggering on both created and published events

[2.6.0] - 2026-04-08

Added

• Correlated timeline lanes on Lite Overview and Dashboard — synchronized CPU, memory, waits, and TempDB trend lanes for at-a-glance correlation (#688)
• Dynamic baselines and anomaly detection in Lite and Dashboard — automatic baseline calculation with anomaly highlighting on key metrics (#692, #693)
• Query grid comparison — before/after comparison mode for query grids in Lite and Dashboard with global Compare dropdown (#687)
• Nonclustered index count badge on modification operators in plan viewer (#788)
• Upgrade detection in Edit Server dialog — see pending upgrades without adding a new server (#772)
• CLI installer interactive mode prompts for trust-cert and encryption settings (#784)
• SignPath code signing — release binaries are now digitally signed via the SignPath FOSS program

Changed

• PlanAnalyzer Rule 3 (Serial Plan) comprehensively refined — severity demotion for TRIVIAL and 0ms plans, CouldNotGenerateValidParallelPlan treated as actionable, all 25 NonParallelPlanReason values now covered
• PlanAnalyzer warning rules ported from PerformanceStudio improvements
• Text readability — replaced all muted/dim text colors with full foreground colors for readability

Fixed

• Embedded resource upgrade discovery broken — upgrades silently returned zero results for Dashboard installs (#772)
• Archive compaction OOM on large parquet groups
• CLI installer argument parsing treating flags as positional args (#786)
• Lite long-running query alerts firing on stale DuckDB snapshots
• FinOps Enterprise feature detection now queries all databases and filters to TDE only (#780)
• Second launch error — now brings existing window to foreground instead (#769)
• Overview tab Memory Grant showing 0 for all timestamps (#776)
• Lite FinOps Enterprise features query error on servers without database_id column (#777)
• Collector health status incorrect for on-load collectors
• CSV and clipboard exports writing System.Windows.Controls.StackPanel as column headers instead of actual header text (#805)

[2.5.0] - 2026-03-30

Important

• InstallerGui retired: The standalone GUI installer has been removed. Installation, upgrade, and uninstall are now handled directly from the Dashboard's Add Server dialog, powered by the new Installer.Core shared library. The CLI installer continues to work as before. (#755)

Added

• Dashboard integrated installer — Add Server dialog now installs, upgrades, and uninstalls PerformanceMonitor directly, replacing the standalone InstallerGui (#755)
• Installer.Core shared library — shared installation logic used by both the CLI installer and Dashboard (#755)
• Overview tab for Lite with 2x2 resource chart grid (CPU, Memory, Wait Stats, TempDB) (#689)
• Chart drill-down on CPU, Memory, TempDB, Blocking, and Deadlock charts in both Dashboard and Lite — right-click any chart point to jump to Active Queries for that time window (#682)
• Grid-to-slicer overlay for Query Stats, Procedure Stats, and Query Store tabs — click a row to overlay its trend on the slicer chart (#683)
• Query heatmap tab in both Dashboard and Lite — visual heat map of query activity over time (#739, #743)
• Webhook notifications for alerts — configurable webhook endpoint for alert delivery (#725)
• Per-server collector schedule intervals — customize collection frequency per server (#703)
• Investigate button in Critical Issues grid — jump directly to relevant tab from an alert (#684)
• Dismiss Selected context menu and View Log sidebar button for alert management (#718, #740)
• Alert archival awareness — dismissed_archive_alerts sidecar table, source column for live vs archived alerts, stale-data indicator, structured telemetry (#718)
• Dashboard read-only connection intent — connections use ApplicationIntent=ReadOnly where supported (#728)
• FUNDING.yml for GitHub Sponsors (#752)

Changed

• Installer architecture refactored: CLI installer is now a thin wrapper over Installer.Core (#755)
• DuckDB memory capped at 2 GB during parquet compaction to prevent out-of-memory on large archives (#758)
• Text rendering improved with TextOptions.TextFormattingMode="Display" for sharper text (#710)
• installation_history version columns widened from nvarchar(255) to nvarchar(512) to handle long @@VERSION strings (#712)

Fixed

• Memory leaks in Lite — delta cache, event handlers, and chart helpers properly disposed (#758)
• Doomed transaction errors in delta framework and ensure_collection_table — ROLLBACK now occurs before error logging (#756)
• XACT_STATE check added after third-party stored procedure calls (sp_HumanEventsBlockViewer, sp_BlitzLock) to prevent doomed transaction errors (#695)
• CREATE DATABASE failure when model database has large default file sizes (#676)
• CPU metrics mixed for different Azure SQL databases on the same logical server (#680)
• Azure SQL DB vCore FinOps calculations incorrect for serverless/vCore tiers (#736)
• Webhook alert recording not persisting correctly (#726)
• Drill-down timezone misalignment between chart and detail view (#747, #750)
• Drill-down refresh losing context on auto-refresh (#744)
• Drill-down target incorrectly routing Memory to Memory Grants instead of Active Queries (#706)
• Heatmap colorbar stacking when switching between servers (#746)
• Display mode pickers not reflecting current state on tab switch (#751)
• Slicer custom range handling and sub-hour display issues (#704)
• Overlay selection lost on Dashboard auto-refresh (#683)
• Numeric values in alert details treated as strings instead of numbers (#732)
• FinOps VM right-sizing query error — PERCENTILE_CONT missing required OVER() clause
• FinOps Enterprise features query error on AWS RDS — database_id column not present in sys.dm_db_persisted_sku_features on RDS
• FinOps right-click copy broken on all Dashboard FinOps grids — context menu walked to row instead of grid
• FinOps recommendation error logs now include server name for easier troubleshooting

Deprecated

• InstallerGui — removed from the solution and build pipeline. Use the Dashboard or CLI installer instead. (#755)

[2.4.0] - 2026-03-23

Important

• Lite data directory moved: Lite now stores all data (config, DuckDB, archives, logs) in %LOCALAPPDATA%\PerformanceMonitorLite\ instead of alongside the executable. This enables auto-update support. Existing users upgrading from the zip should use Import Settings and Import Data to bring over their configuration and historical data from the old install folder.
• Auto-update (Windows): Both Dashboard and Lite now include Velopack auto-update. Users who install via the new Setup.exe will receive update notifications and can download + apply updates from within the app. Existing zip distribution continues to work as before.

Added

• Velopack auto-update for Dashboard and Lite — check on startup, download + apply from About window with confirmation dialog before restart (#635)
• Per-tab time range slicers on Dashboard and Lite query tabs — filter data directly on each tab without changing global time range (#655, #662)
• Time display picker (Local/UTC/Server) in Dashboard and Lite toolbars (#646)
• Import Settings — renamed from "Import Connections", now also copies settings.json, collection_schedule.json, ignored_wait_types.json, and alert_state.json from a previous install
• Alert muting improvements — pre-fill context fields (database, query, wait type, job name) from alert detail text, configurable default expiration for new mute rules, tooltip on query text field (#642)
• Missing date columns on Query Stats and Procedure Stats tabs (creation_time, last_execution_time) (#649, #651, #654)
• Trace pattern drill-down now includes CollectionTime and NtUserName columns (#663)
• DataGrid sort preservation across auto-refresh — sort order no longer resets when data refreshes (#659)
• CLI installer: colored output (green/red/yellow) and version check on startup (#639)
• GUI installer: version check on startup
• Growth rate and VLF count columns in Database Sizes (from v2.3.0 nightly, now in upgrade path) (#567)
• llms.txt and CITATION.cff for project discoverability (#630)

Changed

• Lite data directory moved to %LOCALAPPDATA%\PerformanceMonitorLite\ for Velopack compatibility
• Delta gap detection added to all cumulative-counter collectors (file I/O, wait stats, query stats, procedure stats, memory grants) — prevents inflated spikes after app restart (#633)
• File I/O NULL fallbacks improved when sys.master_files is inaccessible — falls back to DB_NAME() and File_{id} instead of generic "Unknown" (#633)
• Running jobs collector skipped gracefully when login lacks msdb access (#656)
• NuGet packages updated to latest minor versions (#653)

Fixed

• Installer writing SUCCESS when files fail — CLI tolerated 1 failure in automated mode, GUI had a similar workaround. Now any failure = not success.
• Query stats collector causing SQL dumps on passive mirror servers — removed dm_exec_plan_attributes CROSS APPLY, uses temp table of ONLINE database IDs instead (#632)
• Trigger name extraction fails when comment before CREATE TRIGGER contains " ON " (#666)
• FinOps expensive queries DuckDB error — query referenced statement_start_offset column that doesn't exist in schema
• Imported parquet files not recognized by archive compaction — added regex patterns for imported_ prefix
• Auto-refresh after Import Data — views now refresh immediately after import completes

[2.3.0] - 2026-03-18

Important

• Schema upgrade: Six columns widened across three tables (query_stats, cpu_scheduler_stats, waiting_tasks, database_size_stats) to match DMV documentation types. These are in-place ALTER COLUMN operations — fast on any table size, no data migration. Upgrade scripts run automatically via the CLI/GUI installer.
• SQL Server version check: Both installers now reject SQL Server 2014 and earlier before running any scripts, with a clear error message. Azure MI (EngineEdition 8) is always accepted. (#543)
• Installer adversarial tests: 35 automated tests covering upgrade failures, data survival, idempotency, version detection fallback, file filtering, restricted permissions, and more. These run as part of pre-release validation. (#543)

Added

• ErikAI analysis engine — rule-based inference engine for Lite that scores server health across wait stats, CPU, memory, I/O, blocking, tempdb, and query performance. Surfaces actionable findings with severity, detail, and recommended actions. Includes anomaly detection (baseline comparison for acute deviations), bad actor detection (per-query scoring for consistently terrible queries), and CPU spike detection for bursty workloads. (#589, #593)
• ErikAI Dashboard port — full analysis engine ported to Dashboard with SQL Server backend (#590)
• FinOps cost optimization recommendations — Phase 1-4 checks: enterprise feature audit, CPU/memory right-sizing, compression savings estimator, unused index cost quantification, dormant database detection, dev/test workload detection, VM right-sizing, storage tier optimization, reserved capacity candidates (#564)
• FinOps High Impact Queries — 80/20 analysis showing which queries consume the most resources across all dimensions (#564)
• FinOps dollar-denominated cost attribution — per-server monthly cost setting with proportional database-level breakdown (#564)
• On-demand plan fetch for bad actor and analysis findings — click to retrieve execution plans for flagged queries (#604)
• Plan analysis integration — findings include execution plan analysis when plans are available (#594)
• Server unreachable email alerts — Dashboard sends email (not just tray notification) when a monitored server goes offline or comes back online (#529)
• Column filters on all FinOps DataGrids — filter funnel icons on every column header across all 7 FinOps grids in Lite and Dashboard (#562)
• Column filters on Dashboard IdleDatabases, TempDB, and Index Analysis grids
• Lite data import — "Import Data" button brings in monitoring history from a previous Lite install via parquet files, preserving trend data across version upgrades (#566)
• Per-server Utility Database setting — Lite can call community stored procedures (sp_IndexCleanup) from a database other than master (#555)
• SQL Server version check in both CLI and GUI installers — rejects 2014 and earlier with a clear message (#543)
• Execution plan analysis MCP tools for both Dashboard and Lite
• Full MCP tool coverage — Dashboard expanded from 28 to 57 tools, Lite from 32 to 51 tools (#576, #577)
• Self-sufficient analyze_server drill-down — MCP tool returns complete analysis, not breadcrumb trail (#578)
• NuGet package dependency licenses in THIRD_PARTY_NOTICES.md

Changed

• Azure SQL DB FinOps — all collectors (database sizes, query stats, file I/O) now connect to each database individually instead of only querying master. Server Inventory uses dynamic SQL to avoid sys.master_files dependency. (#557)
• Index Analysis scroll fix — both summary and detail grids now use proportional heights instead of Auto, so they scroll independently with large result sets (#554)
• Dashboard Add Server dialog — increased MaxHeight from 700 to 850px so buttons are visible when SQL auth fields are shown
• GUI installer — Uninstall button now correctly enables after a successful install
• GUI installer — fixed encryption mapping and history logging (#612)
• Dashboard visible sub-tab only refresh on auto-refresh ticks (#528)
• Analysis engine decouples data maturity check from analysis window

Fixed

• Installer dropping database on every upgrade — 00_uninstall.sql excluded from install file list, installer aborts on upgrade failure, version detection fallback returns "1.0.0" instead of null (#538, #539)
• SQL dumps on mirroring passive servers from FinOps collectors (#535)
• RetrievedFromCache always showing False (#536)
• Arithmetic overflow in query_stats collector for dop/thread columns (#547)
• Lite perfmon chart bugs and Dashboard ScottPlot crash handling (#544, #545)
• PLE=0 scoring bug — was scored as harmless, now correctly flagged (#543)
• PercentRank >1.0 bug in HealthCalculator
• 6 verified Lite bugs from code review (#611)
• Enterprise feature audit text — partitioning is not Enterprise-only
• FinOps collector scheduling, server switch, and utilization bugs
• Dashboard drill-down Unicode arrow in story path split
• Empty DataGrid scrollbar artifacts — hide grids when empty across all FinOps tabs
• Query preview — truncated in row, full text in tooltip

2.2.0 - 2026-03-11

Contributors: @HannahVernon, @ClaudioESSilva, @dphugo, @Orestes — thank you!

Important

• Schema upgrade: Three large collection tables (query_stats, procedure_stats, query_store_data) are migrated to use COMPRESS() for query text and plan columns. The upgrade performs a table swap (create new → migrate data → rename) which may take several minutes on large tables. A row_hash column is added for deduplication. Three new tracking tables are also created. Volume stats columns are added to database_size_stats. Upgrade scripts run automatically via the CLI/GUI installer and use idempotent checks.

  Compression results measured on a production instance:

  Table	Compressed	Uncompressed	Ratio
  query_stats	18.0 MB	339.0 MB	18.8x
  query_store_data	13.5 MB	258.0 MB	19.1x
  Total	31.5 MB	597 MB	~19x

Added

• FinOps monitoring tab — database size tracking, server properties, storage growth analysis (7d/30d), index analysis with unused/duplicate/compressible detection, utilization efficiency, idle database identification, and estate-level resource views (#474)
• Named collection presets — Aggressive, Balanced, and Low-Impact schedule profiles via config.apply_collection_preset (#454)
• Entra ID interactive MFA authentication in both CLI and GUI installers for Azure SQL MI connections (#481)
• MCP port validation — TCP port conflict detection, range validation (1024+), Auto port button, and auto-restart on settings change (#453)
• Alert database exclusion filters — filter blocking and deadlock alerts by database in both Dashboard and Lite (#410, #412)
• Configurable alert cooldown periods for tray notifications and email alerts
• Wait stats query drill-down — click a wait type to see the queries causing it ([#372])
• Configurable long-running query settings — max results, WAITFOR/backup/diagnostics exclusions (#415)
• Uninstall option in both CLI and GUI installers (#431)
• Session stats collector for active session tracking (#474)
• LOB compression and deduplication for query stats tables to reduce storage (#419)
• Volume-level drive space enrichment in database size stats via dm_os_volume_stats
• GUI installer installation history logging to config.installation_history (#414)
• ReadOnlyIntent connection option — Lite connections can set ApplicationIntent=ReadOnly for automatic read routing to Always On AG readable secondaries (#515)
• Alert muting — mute individual alerts or create pattern-based mute rules by server, metric, database, or application. Manage Mute Rules window with enable/disable toggle. Alert history detail view with double-click drill-down and context-sensitive detail text. Poison wait type documentation links. (#512)
• SignPath code signing — all release binaries (Dashboard, Lite, Installers) are digitally signed, eliminating Windows SmartScreen warnings (#511)
• CI version bump check on PRs to main
• Permissions section in README with least-privilege setup (#421)

Changed

• Utilization tab redesigned — ported to Dashboard with aligned metrics between apps (#478)

• PlanAnalyzer rules synced from PerformanceStudio — Rule 5 message format, seek predicate parsing, spool labels, unmatched index detail (#416, #475, #480)

• Data retention now purges processed XE staging rows

• GeneratedRegex conversion for compile-time regex patterns ([#346], #420)

• Server health card width increased from 260 to 300 for less text truncation (#489)

• User's locale used for date/time formatting in WPF bindings (#459)

• XML processing instructions stripped from sql_command/sql_text display

• Parameterized queries in blocking/deadlock alert filtering

• DuckDB 1.5.0 upgrade — non-blocking checkpointing eliminates read stalls during WAL flushes, free block reuse stabilizes database file size without archive-and-reset cycles (#516)

• Automatic parquet compaction — archive files are merged into monthly files after each archive cycle, reducing file count from 2,600+ to ~75 and eliminating per-file metadata overhead on glob scans (#516)

  Combined with the UI responsiveness overhaul (#510), Lite's refresh cycle improved 13-26x:

  Metric	Before	After
  Lite RefreshAllDataAsync	6-13s	< 500ms
  Parquet files scanned per query	233	19
  Archive-and-reset frequency	21/day	~0
  v_wait_stats query time	1,700ms	27ms

• Monthly archive retention — switched from 90-day file-age deletion to 3-month calendar-month rolling window, aligned with compacted monthly filenames (#516)

• Lite status bar shows used data size vs file size (e.g., "Database: 175.5 / 423.8 MB") via DuckDB pragma_database_size() (#517)

• Query Store collector diagnostics — reader/append/flush timing breakdown logged when collection exceeds 2 seconds, for identifying SQL Server DMV contention under heavy workloads (#518)

• SSMS-parity edge tooltips on plan viewer operator connections and ManyToMany indicator always shown for merge join operators (#504)

• Lite UI responsiveness overhaul — visible-tab-only refresh, sub-tab awareness, Query Store collector optimization (NULL plan XML + LOOP JOIN hint), and DuckDB write reduction (#510)

  Timer tick improvements measured under TPC-C load on SQL2022:

  Scenario	Before	After	Improvement
  Lite idle	6-13s	546-750ms	~90%
  Lite under TPC-C	6-13s	~3s	~70%
  Dashboard idle	5.6s	0.6-0.8s	86%
  Dashboard under TPC-C	5.6s	1.8-2.0s	64%

  Query Store collector specifically:

  Metric	Before	After
  query_store collector total	6-18s	~600ms
  query_store SQL time	374-1,104ms	~300ms (LOOP JOIN hint)
  query_store DuckDB write	6-16s	~75-230ms (NULL plan XML)

Fixed

• UI hang when opening Dashboard tab for offline server — replaced synchronous .GetAwaiter().GetResult() with proper await (#477)
• First-collection spike skewing PerfMon, wait stats, file I/O, memory grant, query stats, and procedure stats charts — first cumulative value now treated as baseline (#482)
• Wait type filter TextBox too small to read (#488)
• Poison wait false positives and alert log parsing (#445, #448)
• RID Lookup analyzer rule matching new PhysicalOp label (#429)
• procedure_stats plan query using DECOMPRESS after compression migration
• database_size_stats InvalidCastException on compatibility_level
• Deadlock filter using wrong column reference in GetFilteredDeadlockCountAsync
• RESTORING database filter added to waiting_tasks collector (#430)
• Custom TrayToolTip crash — replaced with plain ToolTipText (#422)
• Lite tab switch freeze — added _isRefreshing guard to prevent tab switch handler from competing with timer ticks for DuckDB connection, eliminating "not responding" hangs (#510)
• DuckDB read lock acquisition resilience
• Formatted duration columns sorting alphabetically instead of numerically
• Settings window staying open on validation errors
• Deserialization clamping and validation abort issues
• sp_IndexCleanup summary grid column mapping off-by-one, expanded both grids to show all columns from both result sets (#503)
• Rule 22 table variable false positive on modification operators — INSERT/UPDATE/DELETE on table variables is expected (#513)
• ComboBox focus steal in plan viewer stealing keyboard focus from other controls (#508)
• DOP 2 skew false positive — parallel skew rule no longer fires at DOP 2 (#508)
• ReadOnlyIntent connections sharing server_id in DuckDB when the same server was added with and without ReadOnlyIntent (#521)

2.1.0 - 2026-03-04

Important

• Schema upgrade: The config.collection_schedule table gains two new columns (collect_query, collect_plan) for optional query text and execution plan collection. Both default to enabled to preserve existing behavior. Upgrade scripts run automatically via the CLI/GUI installer and use idempotent checks.

Added

• Light theme and "Cool Breeze" theme — full light mode support for both Dashboard and Lite with live preview in settings (#347)
• Standalone Plan Viewer — open, paste (Ctrl+V), or drag & drop .sqlplan files independent of any server connection, with tabbed multi-plan support (#359)
• Time display mode toggle — show timestamps in Server Time, Local Time, or UTC with timezone labels across all grids and tooltips (#17)
• 30 PlanAnalyzer rules — expanded from 12 to 30 rules covering implicit conversions, GetRangeThroughConvert, lazy spools, OR expansion, exchange spills, RID lookups, and more (#327, #349, #356, #379)
• Wait stats banner in plan viewer showing top waits for the query (#373)
• UDF runtime details — CPU and elapsed time shown in Runtime Summary pane when UDFs are present (#382)
• Sortable statement grid and canvas panning in plan viewer (#331)
• Comma-separated column filters — enter multiple values separated by commas in text filters (#348)
• Optional query text and plan collection — per-collector flags in config.collection_schedule to disable query text or plan capture (#337)
• --preserve-jobs installer flag — keep existing SQL Agent job schedules during upgrade (#326)
• Copy Query Text context menu on Dashboard statements grid (#367)
• Server list sorting by display name in both Dashboard and Lite (#30)
• Warning status icon in server health indicators (#355)
• Reserved threads and 10 missing ShowPlan XML attributes in plan viewer (#378)
• Nightly build workflow for CI (#332)

Changed

• PlanAnalyzer warning messages rewritten to be actionable with expert-guided per-rule advice (#370, #371)
• PlanAnalyzer rule tuning: time-based spill analysis (Rule 7), lowered parallel skew thresholds (Rule 8), memory grant floor raised to 1GB/4GB (Rule 9), skip PROBE-only bitmap predicates (Rule 11) (#341, #342, #343, #358)
• First-run collector lookback reduced from 3-7 days to 1 hour for faster initial data (#335)
• Plan canvas aligns top-left and resets scroll on statement switch (#366)
• Plan viewer polish: index suggestions, property panel improvements, muted brush audit (#365)
• Add Server dialog visual parity between Dashboard and Lite with theme-driven PasswordBox styling (#289)

Fixed

• OverflowException on wait stats page with large decimal values — SQL Server decimal(38,24) exceeding .NET precision (#395)
• SQL dumps on mirroring passive servers with RESTORING databases (#384)
• UI hang when adding first server to Dashboard (#387)
• UTC/local timezone mismatch in blocked process XML processor (#383)
• AG secondary filter skipping all inaccessible databases in cross-database collectors (#325)
• DuckDB column aliases in long-running queries (#391)
• sp_server_diagnostics and WAITFOR excluded from long-running query alerts (#362)
• UDF timing units corrected: microseconds to milliseconds (#338)
• DuckDB migration ordering after archive-and-reset (#314)
• Int16 cast error in long-running query alerts (#313)
• Missing dark mode on 19 SystemEventsContent charts (#321)
• Missing tooltips on charts after theme changes (#319)
• Operator time per-thread calculation synced across all plan viewers (#392)
• Theme StaticResource/DynamicResource binding fix for runtime theme switching
• Memory grant MB display, missing index quality scoring, wildcard LIKE detection (#393)
• Installer validation reporting historical collection errors as current failures — now filters to current run only (#400)
• query_snapshots schema mismatch after sp_WhoIsActive upgrade — collector auto-recreates daily table when column order changes (#401)
• Missing upgrade script for default_trace_events columns (duration_us, end_time) on 2.0.0→2.1.0 upgrade path (#400)

2.0.0 - 2026-02-25

Important

• Schema upgrade: The collect.memory_grant_stats table gains new delta columns and drops unused warning columns. The collect.session_wait_stats table, its collector procedure, reporting view, and schedule entry are removed (zero UI coverage). Upgrade scripts run automatically via the CLI/GUI installer and use idempotent checks.

Added

• Graphical query plan viewer — native ShowPlan rendering in both Dashboard and Lite with SSMS-parity operator icons, properties panel, tooltips, warning/parallelism badges, and tabbed plan display (#220)
• Actual execution plan support — execute queries with SET STATISTICS XML ON to capture actual plans, with loading indicator and confirmation dialog (#233)
• PlanAnalyzer — automated plan analysis with rules for missing indexes, eager spools, key lookups, implicit conversions, memory grants, and more
• Current Active Queries live snapshot — real-time view of running queries with estimated/live plan download ([#149])
• Memory clerks tab in Lite with picker-driven chart ([#145])
• Current Waits charts in Blocking tab for both Dashboard and Lite (#280)
• File I/O throughput charts — read/write throughput trends, file-level latency breakdown, queued I/O overlay (#281)
• Memory grant stats charts — standardized collection with delta framework integration and trend visualization (#281)
• CPU scheduler pressure status — real-time scheduler, worker, runnable task counts with color-coded pressure level below CPU chart
• Collection log drill-down and daily summary in Lite ([#138])
• Collector duration trends chart in Dashboard Collection Health ([#138])
• Themed perfmon counter packs — 14 new counters with organized themed groups (#255)
• User-configurable connection timeout setting (#236)
• Per-collector retention — uses per-collector retention from config.collection_schedule in data retention (#237)
• Query identifiers in drill-down windows — query hash, plan hash, SQL handle visible for identification (#268)
• Trace pattern drill-down with missing columns and query text tooltips (#273)
• Query Store Regressions drill-down with TVF rewrite for performance (#274)
• CLI --help flag for installer ([#111])
• Sort arrows, right-aligned numerics, and initial sort indicators across all grids ([#110])
• Copyable plan viewer properties (#269)
• Standardized chart save/export filenames between Dashboard and Lite (#284)
• Full Dashboard column parity for query_stats, procedure_stats, and query_store_stats
• Min/max extremes surfaced in both apps — physical reads, rows, grant KB, spills, CLR time, log bytes (#281)

Changed

• Query Store detection uses sys.database_query_store_options instead of sys.databases.is_query_store_on for Azure SQL DB compatibility (#287)
• Config tab consolidation, DB drop on server remove, DuckDB-first plan lookups, procedure stats parity
• Collector health status now detects consecutive recent failures — 5+ consecutive errors = FAILING, 3+ = WARNING
• Plan buttons now show a MessageBox when no plan is available instead of silently doing nothing
• CSV export uses locale-appropriate separators for non-US locales (#240)
• Query Store Regressions and Query Trace Patterns migrated to popup grid filtering (#260)
• NuGet packages updated; xUnit v3 migration

Fixed

• DuckDB file corruption during maintenance — ReaderWriterLockSlim coordination, archive-all-and-reset at 512MB replaces compaction (#218)
• Archive view column mismatch, wait_stats thread-safety, and percent_complete type cast (#234)
• Collector health status bar text color (#234)
• View Plan for Query Store and Query Store Regressions tabs (#261)
• Query Store drill-down time filter alignment with main view (#263)
• Execution count mismatches between main views and drill-downs
• Drill-down chart UX — sparse data markers, hover tooltips, window sizing (#271)
• Truncated status text in Add Server dialog (#257)
• Scrollbar visibility, self-filtering artifacts, missing columns, and context menus (#245, #246, #247, #248)
• query_stats and procedure_stats collectors ignoring recent queries
• Blank tooltips on warning and parallel badge icons
• Missing chart context menu on File I/O Throughput charts in Lite

Removed

• collect.session_wait_stats table, collect.session_wait_stats_collector procedure, report.session_wait_analysis view, and schedule entry — zero UI coverage, never surfaced in Dashboard or Lite (#281)

1.3.0 - 2026-02-20

Important

• Schema upgrade: The collect.memory_stats table gains two new columns (total_physical_memory_mb, committed_target_memory_mb). The upgrade script runs automatically via the CLI/GUI installer and uses IF NOT EXISTS checks, so it is safe to re-run. On servers with very large memory_stats tables this ALTER may take a moment.

Added

• Physical Memory, SQL Server Memory, and Target Memory columns in Memory Overview (#140)
• Current Configuration view (Server Config, Database Config, Trace Flags) in Dashboard Overview (#143)
• Popup column filters and right-click context menus in all drill-down history windows (#206)
• Consistent popup column filters across all Dashboard grids — replaced remaining TextBox-in-header filters and added filters to Trace Flags (#200)
• 7-day time filter option in drill-down queries (#165)
• Alert badge/count on sidebar Alerts button (#109)
• Missing poison wait defaults in wait stats picker (#188)

Changed

• Default Trace tabs moved from Resource Metrics to Overview section (#169)
• Trends tab shown first in Locking section (#171)
• Wait stats cap raised from 20 to 30 (Dashboard) / 50 (Lite) so poison waits are never dropped (#139)
• Settings time range dropdown now matches dashboard button options (#210)
• "Total Executions" label in drill-down summaries renamed to clarify meaning (#194)
• WAITFOR sessions excluded from long-running query alerts (#151)

Fixed

• Deadlock XML processor timezone mismatch — sp_BlitzLock returning 0 results because UTC dates were passed instead of local time
• Sidebar alert badge not updating when alerts dismissed from server sub-tabs (#214)
• Sidebar alert badge not clearing on acknowledge (#186)
• NOC deadlock/blocking showing "just now" for stale events instead of actual timestamp (#187)
• NOC deadlock severity using extended events timestamp (#170)
• Newly added servers not appearing on Overview until app restart (#199)
• Double-click on column header incorrectly triggering row drill-down (#195)
• Squished drill-down charts — now use proportional sizing (#166)
• Unreliable chart tooltips — now use X-axis proximity matching (#167)
• Query Trace Patterns showing empty despite data existing (#168)
• Drill-down windows: removed inline plan XML, added time range filtering, aggregated by collection_time (#189)
• Row clipping in Default Trace and Current Configuration grids (#183, #184)
• Numeric filter negative range parsing (#113)
• MCP shutdown deadlock risk (#112)
• Lite DBNull cast error in database_config collector on SQL 2016 Express (#192)
• DuckDB concurrent file access IO errors (#164)

1.2.0 - 2026-02-15

Added

• Alert types, alerts history view, column filtering, and dismiss/hide for alerts (#52, #56)
• Average ms per wait chart toggle in both apps (#22)
• Collection Health tab in Lite UI (#39)
• Collector performance diagnostics in Lite UI (#40)
• Hover tooltips on all Dashboard charts (#70)
• Minimize-to-tray setting added to Lite (#53)
• Persist dismissed alerts across app restarts (#44)
• Locale-aware date/time formatting throughout UI (#41)
• 24-hour format in time range picker (#41)
• CI pipelines for build validation, SQL install testing, and DuckDB schema tests
• Expanded Lite database config collector to 28 sys.databases columns (#142)
• Parquet archive visibility and scheduled DuckDB database compaction (#160, #161)
• DuckDB checkpoint optimization and collection timing accuracy
• Installer --reset-schedule flag to reset collection schedule on re-install

Fixed

• Deadlock charts not populating data (#73)
• Chart X-axis double-converting custom range to server time (#49)
• query_cost overflow in memory grant collector (#47)
• XE ring buffer query timeouts on large buffers (#37)
• Dashboard sub-tab badge state and DuckDB migration for dismissed column
• Lite duplicate blocking/deadlock events from missing WHERE clause (#61)
• Procedure_stats_collector truncation on DDL triggers (#69)
• DataGrid row height increased from 25 to 28 to fix text clipping
• Skip offline servers during Lite collection and reduce connection timeout (#90)
• Mutex crash on Lite app exit (#89)
• Permission denied errors handled gracefully in collector health (#150)

1.1.0 - 2026-02-13

Added

• Hover tooltips on all multi-series charts — Wait Stats, Sessions, Latch Stats, Spinlock Stats, File I/O, Perfmon, TempDB (#21)
• Microsoft Entra MFA authentication for Azure SQL DB connections in Lite (#20)
• Column-level filtering on all 11 Lite DataGrids (#18)
• Chart visual parity — Material Design 300 color palette, data point markers, consistent grid styling (#16)
• Smart Select All for wait types + expand from 12 to 20 wait types (#12)
• Trend chart legends always visible in Dashboard (#11)
• Per-server collector health in Lite status bar (#5)
• Server Online/Offline status in Lite overview (#2)
• Check for updates feature in both apps (#1)
• High DPI support for both Dashboard and Lite

Fixed

• Query text off-by-one truncation (#25)
• Blocking/deadlock XML processors truncating parsed data every run (#23)
• WAITFOR queries appearing in top queries views (#4)
• Wait type Clear All not refreshing search filter in Dashboard

1.0.0 - 2026-02-11

Added

• Full Edition: Dashboard + CLI/GUI Installer with 30+ automated SQL Agent collectors
• Lite Edition: Agentless monitoring with local DuckDB storage
• Support for SQL Server 2016-2025, Azure SQL DB, Azure SQL MI, AWS RDS
• Real-time charts and trend analysis for wait stats, CPU, memory, query performance, index usage, file I/O, blocking, deadlocks
• Email alerts for blocking, deadlocks, and high CPU
• MCP server integration for AI-assisted analysis
• System tray operation with background collection and alert notifications
• Data retention with configurable automatic cleanup
• Delta normalization for per-second rate calculations
• Dark theme UI