# trimble-oss/dba-dash architecture

> Architecture diagram of the GitHub repository trimble-oss/dba-dash, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-09-30). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/trimble-oss/dba-dash
- Repository: https://github.com/trimble-oss/dba-dash

## Overview

DBA Dash is a SQL Server monitoring and administration product: an agent gathers estate-wide operational, performance, Extended Events, and configuration data into a repository; DBAs inspect and act on it through the desktop GUI. Separate viewer apps render execution plans and deadlock graphs, while an optional AI service provides analysis and tool-backed summaries. The graph preserves these major README capabilities, but the supplied excerpts do not establish most collector-to-storage details, so those connections are marked unverified rather than inferred as a precise pipeline.

Main entry points: [`DBADashGUI/Main.cs`](https://github.com/trimble-oss/dba-dash/blob/main/DBADashGUI/Main.cs) (DBA Dash desktop), [`DBADash/DBCollector.cs`](https://github.com/trimble-oss/dba-dash/blob/main/DBADash/DBCollector.cs) (Collection agent), [`DBADash.Viewers.GUI/ViewerLauncher.cs`](https://github.com/trimble-oss/dba-dash/blob/main/DBADash.Viewers.GUI/ViewerLauncher.cs) (Standalone visualizer), [`DBADash/DBImporter.cs`](https://github.com/trimble-oss/dba-dash/blob/main/DBADash/DBImporter.cs) (Monitoring repository)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_collection["Collection and storage"]
  node_agent["Collection agent<br/>[DBCollector.cs]"]
  node_service["Scheduler service"]
  node_repository[("Monitoring repository<br/>[DBImporter.cs]")]
  node_messaging["Collection messaging"]
end

subgraph group_monitoring["Monitoring capabilities"]
  node_checks["DBA checks"]
  node_performance["Performance monitoring"]
  node_configuration["Change tracking"]
  node_extended_events["Extended Events<br/>[XETraceReader.cs]"]
  node_alerts["Alerts and notifications<br/>[Alert.cs]"]
end

subgraph group_experience["DBA experience"]
  node_gui["DBA Dash desktop<br/>[Main.cs]"]
  node_visualizer["Standalone visualizer<br/>[ViewerLauncher.cs]"]
end

subgraph group_analysis["Analysis services"]
  node_plan_domain["Plan parsing and analysis<br/>[PlanOperator.cs]"]
  node_plan_layout["Plan layout engine"]
  node_deadlock_domain["Deadlock parsing and analysis"]
  node_deadlock_layout["Deadlock layout engine"]
  node_ai["AI assistant API<br/>[Program.cs]"]
  node_ai_tools["Monitoring summary tools"]
end

node_dba(("DBA"))
node_sql[("SQL Server estate")]

node_sql -.->|"monitors"| node_agent
node_service -.->|"schedules collection"| node_agent
node_agent -.->|"stores collected data"| node_repository
node_agent -.->|"dispatches work"| node_messaging
node_repository -.->|"provides monitoring data"| node_gui
node_gui -.->|"presents checks"| node_checks
node_gui -.->|"presents performance"| node_performance
node_gui -.->|"presents changes"| node_configuration
node_gui -.->|"exposes monitoring"| node_extended_events
node_gui -.->|"presents alerts"| node_alerts
node_dba -.->|"uses"| node_gui
node_dba -.->|"opens plans or deadlocks"| node_visualizer
node_visualizer -.->|"views execution plans"| node_plan_domain
node_plan_domain -->|"lays out statements"| node_plan_layout
node_visualizer -.->|"views deadlock graphs"| node_deadlock_domain
node_deadlock_domain -->|"lays out graph"| node_deadlock_layout
node_dba -.->|"requests assistance"| node_ai
node_ai -->|"routes tool requests"| node_ai_tools
node_ai_tools -.->|"queries monitoring data"| node_repository

click node_agent "https://github.com/trimble-oss/dba-dash/blob/main/DBADash/DBCollector.cs"
click node_service "https://github.com/trimble-oss/dba-dash/blob/main/DBADashService/SchedulerService.cs"
click node_repository "https://github.com/trimble-oss/dba-dash/blob/main/DBADash/DBImporter.cs"
click node_messaging "https://github.com/trimble-oss/dba-dash/blob/main/DBADash/Messaging/MessageProcessing.cs"
click node_checks "https://github.com/trimble-oss/dba-dash/tree/main/DBADashGUI/Checks"
click node_performance "https://github.com/trimble-oss/dba-dash/tree/main/DBADashGUI/Performance"
click node_configuration "https://github.com/trimble-oss/dba-dash/tree/main/DBADashGUI/Changes"
click node_extended_events "https://github.com/trimble-oss/dba-dash/blob/main/DBADash/XE/XETraceReader.cs"
click node_alerts "https://github.com/trimble-oss/dba-dash/blob/main/DBADash/Alert/Alert.cs"
click node_gui "https://github.com/trimble-oss/dba-dash/blob/main/DBADashGUI/Main.cs"
click node_visualizer "https://github.com/trimble-oss/dba-dash/blob/main/DBADash.Viewers.GUI/ViewerLauncher.cs"
click node_plan_domain "https://github.com/trimble-oss/dba-dash/blob/main/DBADash.QueryPlan/Model/PlanOperator.cs"
click node_plan_layout "https://github.com/trimble-oss/dba-dash/blob/main/DBADash.QueryPlan/Layout/PlanLayoutEngine.cs"
click node_deadlock_domain "https://github.com/trimble-oss/dba-dash/blob/main/DBADash.Deadlock/Analysis/DeadlockAnalyser.cs"
click node_deadlock_layout "https://github.com/trimble-oss/dba-dash/blob/main/DBADash.Deadlock/Layout/DeadlockLayoutEngine.cs"
click node_ai "https://github.com/trimble-oss/dba-dash/blob/main/DBADashAI/Program.cs"
click node_ai_tools "https://github.com/trimble-oss/dba-dash/blob/main/DBADashAI/Services/Tools/StorageSpaceSummaryTool.cs"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_agent,node_service,node_repository,node_messaging toneBlue
class node_checks,node_performance,node_configuration,node_extended_events,node_alerts,node_sql toneAmber
class node_gui,node_visualizer toneMint
class node_plan_domain,node_plan_layout,node_deadlock_domain,node_deadlock_layout,node_ai,node_ai_tools toneRose
class node_dba toneIndigo
```

## Components

### Collection and storage

- [Collection agent](https://github.com/trimble-oss/dba-dash/blob/main/DBADash/DBCollector.cs): `DBADash/DBCollector.cs`
- [Scheduler service](https://github.com/trimble-oss/dba-dash/blob/main/DBADashService/SchedulerService.cs): `DBADashService/SchedulerService.cs`
- [Monitoring repository](https://github.com/trimble-oss/dba-dash/blob/main/DBADash/DBImporter.cs): `DBADash/DBImporter.cs`
- [Collection messaging](https://github.com/trimble-oss/dba-dash/blob/main/DBADash/Messaging/MessageProcessing.cs): `DBADash/Messaging/MessageProcessing.cs`

### Monitoring capabilities

- [DBA checks](https://github.com/trimble-oss/dba-dash/tree/main/DBADashGUI/Checks): `DBADashGUI/Checks`
- [Performance monitoring](https://github.com/trimble-oss/dba-dash/tree/main/DBADashGUI/Performance): `DBADashGUI/Performance`
- [Change tracking](https://github.com/trimble-oss/dba-dash/tree/main/DBADashGUI/Changes): `DBADashGUI/Changes`
- [Extended Events](https://github.com/trimble-oss/dba-dash/blob/main/DBADash/XE/XETraceReader.cs): `DBADash/XE/XETraceReader.cs`
- [Alerts and notifications](https://github.com/trimble-oss/dba-dash/blob/main/DBADash/Alert/Alert.cs): `DBADash/Alert/Alert.cs`

### DBA experience

- [DBA Dash desktop](https://github.com/trimble-oss/dba-dash/blob/main/DBADashGUI/Main.cs): `DBADashGUI/Main.cs`
- [Standalone visualizer](https://github.com/trimble-oss/dba-dash/blob/main/DBADash.Viewers.GUI/ViewerLauncher.cs): `DBADash.Viewers.GUI/ViewerLauncher.cs`

### Analysis services

- [Plan parsing and analysis](https://github.com/trimble-oss/dba-dash/blob/main/DBADash.QueryPlan/Model/PlanOperator.cs): `DBADash.QueryPlan/Model/PlanOperator.cs`
- [Plan layout engine](https://github.com/trimble-oss/dba-dash/blob/main/DBADash.QueryPlan/Layout/PlanLayoutEngine.cs): `DBADash.QueryPlan/Layout/PlanLayoutEngine.cs`
- [Deadlock parsing and analysis](https://github.com/trimble-oss/dba-dash/blob/main/DBADash.Deadlock/Analysis/DeadlockAnalyser.cs): `DBADash.Deadlock/Analysis/DeadlockAnalyser.cs`
- [Deadlock layout engine](https://github.com/trimble-oss/dba-dash/blob/main/DBADash.Deadlock/Layout/DeadlockLayoutEngine.cs): `DBADash.Deadlock/Layout/DeadlockLayoutEngine.cs`
- [AI assistant API](https://github.com/trimble-oss/dba-dash/blob/main/DBADashAI/Program.cs): `DBADashAI/Program.cs`
- [Monitoring summary tools](https://github.com/trimble-oss/dba-dash/blob/main/DBADashAI/Services/Tools/StorageSpaceSummaryTool.cs): `DBADashAI/Services/Tools/StorageSpaceSummaryTool.cs`

### Other components

- **DBA**
- **SQL Server estate**

## Connections

- SQL Server estate → Collection agent: monitors (evidence: `README.md`)
- Scheduler service → Collection agent: schedules collection
- Collection agent → Monitoring repository: stores collected data (evidence: `README.md`)
- Collection agent → Collection messaging: dispatches work
- Monitoring repository → DBA Dash desktop: provides monitoring data (evidence: `README.md`)
- DBA Dash desktop → DBA checks: presents checks (evidence: `README.md`)
- DBA Dash desktop → Performance monitoring: presents performance (evidence: `README.md`)
- DBA Dash desktop → Change tracking: presents changes (evidence: `README.md`)
- DBA Dash desktop → Extended Events: exposes monitoring (evidence: `README.md`)
- DBA Dash desktop → Alerts and notifications: presents alerts (evidence: `README.md`)
- DBA → DBA Dash desktop: uses (evidence: `README.md`)
- DBA → Standalone visualizer: opens plans or deadlocks (evidence: `README.md`)
- Standalone visualizer → Plan parsing and analysis: views execution plans (evidence: `README.md`)
- Plan parsing and analysis → Plan layout engine: lays out statements (evidence: `DBADash.QueryPlan/Layout/PlanLayoutEngine.cs`)
- Standalone visualizer → Deadlock parsing and analysis: views deadlock graphs (evidence: `README.md`)
- Deadlock parsing and analysis → Deadlock layout engine: lays out graph (evidence: `DBADash.Deadlock/Layout/DeadlockLayoutEngine.cs`)
- DBA → AI assistant API: requests assistance (evidence: `README.md`)
- AI assistant API → Monitoring summary tools: routes tool requests (evidence: `DBADashAI/Program.cs`)
- Monitoring summary tools → Monitoring repository: queries monitoring data
