Better Than Yours
Contributors: @tnguyen7s, @jakemorgangit, @kontrago, @dphugo, @HannahVernon
This release represents the most powerful and capable release since the last release. Game changer. Literally transformative. It will rock you to your very core.
Well but really, some fun things got added, some necessary things got fixed, and I have finally fully ascended to spiritual Product Manager enlightenment by killing a product (sort of).
The GUI installer has been removed as a standalone executable, and folded into the Full Dashboard. It makes more sense there. You go to add a server, and if the PerformanceMonitor database isn't there (or if it needs updating), you install/update from there. Having a whole separate thing to deal with was not fun, when I'm already juggling two dashboards that need maintaining. It also may not be totally clear to people that they need to run that to update the guts to use new Full Dashboard versions.
We now support Webhooks, thanks to @jakemorgangit! I don't have any webs to hook into, but Jake does. Now if you want to have this thing send send messages to things that accept hooking and webs, you can do that. I'm psyched on this, because it's a cool thing that a lot of people rely on for getting alerts. Email is so 2003.
Alerting got a whole lot more mute-able! thanks to @HannahVernon. Hannah has been working a ton on improving the alert system, and I appreciate it because it's the kind of thing I have a real hard time getting myself to sit down and test and whatnot.
So what did I do this time around? Well, @rferraton has been doing some incredible visual work on Performance Studio, and it has made quite an impression on me. I've been trying to get similarly helpful things added in here:
- Time slicers so you can easily filter grid results to resource spikes
- A heat map that shows you when queries really had a tough time
- Right click > Show Active Queries to charts and graphs (coverage is a WIP, but I'm getting there).
The goal here is to make this not only a monitoring tool, but a help-you-figure-out-problems tool. I'm going to build more on that over the next couple releases.
Anyway, that's enough.
What's Changed
- Fix CPU metrics mixed for different Azure SQL databases on same server by @tnguyen7s in #680
- Fix CREATE DATABASE failure when model DB has large files (#676) by @erikdarlingdata in #678
- Fix slicer time ranges, add Blocking/Deadlock slicers (#681) by @erikdarlingdata in #697
- Dashboard: fix slicer time ranges, add Blocking/Deadlock/Default Trace slicers (#681) by @erikdarlingdata in #698
- Lite: grid-to-slicer overlay for query/procedure/Query Store (#683) by @erikdarlingdata in #699
- Dashboard: grid-to-slicer overlay for query/procedure/Query Store (#683) by @erikdarlingdata in #700
- Preserve overlay through Dashboard auto-refresh (#683) by @erikdarlingdata in #701
- Add Investigate button to Critical Issues (#684) by @erikdarlingdata in #702
- Lite: chart drill-down for CPU, Memory, TempDB, Blocking, Deadlocks (#682) by @erikdarlingdata in #705
- Fix Memory drill-down to Active Queries (#682) by @erikdarlingdata in #706
- Fix slicer custom range display and cascading refresh (#704) by @erikdarlingdata in #707
- Widen drill-down window to ±30 minutes (#682) by @erikdarlingdata in #708
- Dashboard: chart drill-down for CPU, Memory, TempDB, Blocking, Deadlocks (#682) by @erikdarlingdata in #709
- Fix drill-down menu disabled on CPU/TempDB/Memory charts (#682) by @erikdarlingdata in #711
- Fix drill-down: Active Queries target, add to all charts (#682) by @erikdarlingdata in #714
- Extend drill-down to Overview, Locking, Memory charts (#682) by @erikdarlingdata in #717
- LITE Fix - Remove blur on graph lines and graph legend text by @dphugo in #710
- Lite: Add Overview tab with resource chart grid (#689) by @erikdarlingdata in #719
- Widen installation_history version columns to nvarchar(512) (#712) by @erikdarlingdata in #722
- Add per-server collector schedule intervals by @erikdarlingdata in #724
- Add diagnostics for Alert Dismissal by @HannahVernon in #721
- feature/Add Teams and Slack webhook notifications by @jakemorgangit in #725
- Fix webhook alert recording and delivery tracking by @erikdarlingdata in #726
- Port read-only intent support from Lite to Dashboard by @erikdarlingdata in #728
- Add source column to distinguish live vs archived alerts (#718) by @HannahVernon in #729
- fix/numeric columns sorting as text instead of numbers by @jakemorgangit in #732
- Add dismissed_archive_alerts sidecar table for parquet-aware dismissal (#718) by @HannahVernon in #730
- feat: structured telemetry, post-dismiss verify, stale-data indicator, archival warning (#718) by @HannahVernon in #734
- Fix FinOps CPU right-sizing for Azure SQL Database (#735) by @kontrago in #736
- Add Query Heatmap sub-tab to Lite by @erikdarlingdata in #739
- Add Query Heatmap sub-tab to Dashboard by @erikdarlingdata in #743
- feat: Dismiss Selected in context menu + View Log sidebar button by @HannahVernon in #740
- Fix drill-down navigation bugs in Dashboard and Lite by @erikdarlingdata in #744
- Fix heatmap colorbar stacking on refresh by @erikdarlingdata in #746
- Fix drill-down timezone mismatches and slicer state by @erikdarlingdata in #747
- Fix drill-down timezone and picker display issues by @erikdarlingdata in #750
- Make custom range pickers respect display mode by @erikdarlingdata in #751
- fix: dismiss reliability - write lock, batched UPDATE, transaction, timeout (#718) by @HannahVernon in #733
- Add GitHub Sponsors funding link by @erikdarlingdata in #752
- Fix doomed transaction error handling (#756) by @erikdarlingdata in #757
- Add XACT_STATE check after third-party proc calls (#695) by @erikdarlingdata in #759
- Fix Lite memory leaks: delta cache, event handlers, chart helpers (#758) by @erikdarlingdata in #760
- Extract Installer.Core shared library and refactor CLI (#755) by @erikdarlingdata in #761
- Cap DuckDB compaction memory at 2 GB (#758) by @erikdarlingdata in #762
- Integrate installation into Dashboard Add Server dialog (#755 Phase 2) by @erikdarlingdata in #763
- Retire InstallerGui from solution and build pipeline (#755 Phase 3) by @erikdarlingdata in #764
- Fix Rule 2: eager table spools no longer flagged as eager index spools by @erikdarlingdata in #765
- Release v2.5.0: version bumps, bug fixes, changelog by @erikdarlingdata in #766
- Release v2.5.0 by @erikdarlingdata in #767
New Contributors
- @tnguyen7s made their first contribution in #680
- @jakemorgangit made their first contribution in #725
- @kontrago made their first contribution in #736
Full Changelog: v2.4.1...v2.5.0