How brentozarultd/sql-server-first-responder-kit works
Main Components
a. Core Components:
• Diagnostic Stored Procedures
• Data Collection & Storage
• Output Generation System
• Integration Points
b. Supporting Components:
• Installation System
• Documentation System
• Testing Framework
┌─────────────────────────────────────────────────────────┐
• Client Applications │
• (SSMS, Azure Data Studio, or any SQL client) │
• ┘
• ↕
┌─────────────────────────────────────────────────────────┐
• Interface Layer │
• Stored Procedure Entry Points │
• Parameter Handling │
• ┘
• ↕
┌─────────────────────────────────────────────────────────┐
• Core Analysis Engine │
• ┬─────────────────┬───────────────────┤
• Health Check │ Performance │ Diagnostic │
• (sp_Blitz) │ (sp_BlitzCache) │ Tools │
• ┴─────────────────┴───────────────────┘
• ↕
┌─────────────────────────────────────────────────────────┐
• Data Collection Layer │
• DMV Interaction │
• System Table Access │
• Extended Events │
• ┘
• ↕
┌─────────────────────────────────────────────────────────┐
• Storage Layer │
• Output Tables │
• Historical Data │
• ┘
Component Details
For each major stored procedure, show:
• Input parameters
• Output formats
• Dependencies
• Data flow direction
• Integration points with SQL Server components
Interaction Flows
Data flows between:
• Stored procedures and SQL Server DMVs
• Output generation and storage
• Cross-procedure communication
• External system integration
Implementation Notes
• Use standard UML or database notation
• Version information
• Optional components
• Deprecated features
Integration Points
Connections with:
• SQL Server system databases
• Extended Events sessions
• Backup systems
• Monitoring tools
• Logging infrastructure
Deployment View
A separate section showing:
• Installation requirements
• Database context
• Permissions needed
• Cross-database dependencies
Monitoring & Maintenance
Components for:
• Historical data collection
• Performance tracking
• Self-diagnostics
• Cleanup processes
This system design should be created using a professional diagramming tool that supports:
• Multiple layers
• Connectors with different styles
• Export to common formats
• Collaboration features