Skip to content

Fix chart zero lines, collection log server name, and overview status (#85, #91, #93)#95

Merged
erikdarlingdata merged 2 commits intodevfrom
feature/fixes-85-91-93
Feb 17, 2026
Merged

Fix chart zero lines, collection log server name, and overview status (#85, #91, #93)#95
erikdarlingdata merged 2 commits intodevfrom
feature/fixes-85-91-93

Conversation

@erikdarlingdata
Copy link
Owner

Summary

Test plan

  • Blocking trends chart shows flat red line at zero when no blocking events
  • Deadlock trends chart shows connecting zero lines between spikes
  • Sidebar dots: green for online servers, red for offline, gray before first check
  • Overview cards match sidebar status
  • Offline servers (Azure, RDS, stopped VMs) correctly show red/offline in both views
  • All three projects build clean (0 errors)

🤖 Generated with Claude Code

erikdarlingdata and others added 2 commits February 17, 2026 12:57
…re-firing

AddWithValue infers types incorrectly — for DateTime it sends legacy datetime
(3.33ms precision) instead of datetime2, causing the deadlock dedup cutoff to
round and re-collect the same event every cycle. Replaced all 28 usages across
7 files with explicitly typed SqlParameter.

Fixed alert re-firing: ServerTab used CollectionTime (always new) instead of
DeadlockTime/EventTime for ack comparison. Overview deadlock count query also
filtered by collection_time instead of deadlock_time, inflating counts with
duplicate rows and triggering spurious popup alerts.

Tested: zero AddWithValue remaining, all 3 projects build clean, dedup confirmed
working under HammerDB load (97 new deadlocks collected, zero duplicates).

Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
… status (#85, #91, #93)

#85: Blocking/deadlock trend charts now show a visible flat line at zero
instead of empty space. Added negative Y-axis margin so zero-value data
renders above the axis border. Reduced fallback Y range from +100 to +1.

#91: Added server_name column to collection_log DuckDB table (schema v10)
so log entries identify which server produced them without a lookup join.

#93: Sidebar status dots now reflect actual connection check results
(IsOnline) instead of the IsEnabled user config toggle. Added IsOnline
property to ServerConnection model, synced from connection status in
RefreshServerList and CheckConnectionsAndNotify. Fixed first-check
refresh so dots update as soon as initial connection checks complete.

Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

1 participant