BrentOzarULTD/SQL-Server-First-Responder-Kit
SQL Server First Responder Kit
This project is a collection of specialized toolsets for SQL Server, functioning as a diagnostic toolkit, performance monitor, and database administrator framework. It provides stored procedures and utilities designed to automate backup recovery, diagnose system health, and optimize database performance and indexing.
The kit distinguishes itself through specialized capabilities for point-in-time restoration and the calculation of estimated data loss windows using backup history. It also includes an index optimizer that analyzes usage and size to provide prioritized recommendations for data retrieval.
The software covers broad administration domains including incident response, disaster recovery, and health monitoring. It features tools for tracking active sessions, analyzing deadlock events, comparing query execution plans, and identifying resource-intensive queries within the plan cache.
The framework implements its diagnostic and management logic as a collection of reusable SQL scripts executed directly within the database engine.
Features
- Backup & Recovery - Provides a specialized toolset for automating point-in-time restores and calculating estimated data loss windows.
- SQL Server Performance Monitors - Provides a comprehensive set of tools for tracking active queries, analyzing deadlocks, and identifying resource-intensive execution plans.
- Recovery Point Analysis - Provides capabilities to calculate estimated recovery time and data loss windows by analyzing backup history.
- Disaster Recovery Workflows - Analyzes backup reliability and automates restoration workflows to meet recovery time and data loss objectives.
- Backup and Recovery Systems - Analyzes backup history to calculate estimated recovery time and data loss windows.
- Database Backup and Restore - Automates database restoration to a specific point in time using a sequence of full, differential, and log backups.
- Database Performance Tuning - Identifies resource-intensive queries and optimizes database indexes to improve system throughput.
- Index Tuning - Analyzes index usage and size to generate prioritized advice for improving data retrieval speeds.
- Active Query Inspections - Tracks currently running queries and sessions in real-time to inspect memory grants, parallelism, and execution plans.
- System Metadata Analyzers - Analyzes system views and metadata tables using predefined rules to identify configuration errors and performance bottlenecks.
- SQL Database Management - Offers a management framework for executing scripts across multiple databases and performing emergency session control.
- Diagnostic Toolkits - Provides a collection of stored procedures for analyzing health, performance, and configuration issues.
- Database Deadlock Diagnosis - Parses system health and event logs to identify and filter deadlock events by date, object, or application.
- Database Session Controllers - Tracks active sessions and terminates resource-heavy or blocking queries to resolve immediate performance degradation.
- Diagnostic Health Assessments - Performs automated server diagnostics and analyzes system metadata to find configuration errors and security risks.
- Cross-Database Command Dispatchers - Allows executing scripts across multiple databases by filtering for matching names or properties.
- Cross-Database Script Dispatchers - Enables the execution of diagnostic scripts across multiple databases based on name patterns or property matches.
- Execution Plan Analysis - Implements tools to compare query execution plans and identify environmental discrepancies causing performance variations.
- Plan Cache Analysis - Scans the plan cache to find queries with the highest resource impact and identify execution plan warnings.
- Plan Cache Analyzers - Inspects the internal plan cache to identify resource-intensive queries and execution plan warnings.
- Plan Comparison - Compares query plans across different servers to identify environmental discrepancies that cause performance variations.
- SQL Index Advisors - Analyzes index usage and size to provide prioritized recommendations for improving data retrieval.
- SQL Query Profilers - Compares execution plans and analyzes deadlock events to troubleshoot complex database performance issues.
- System Health Log Parsers - Parses system health and event logs to extract and filter specific deadlock or health events.
- Performance Trend Analysis - Retrieves and filters historical performance data from diagnostic tables to identify long-term trends and issues.
- Real-time Performance Monitoring - Samples system views over short intervals to identify immediate causes of degradation like file growth or blocking.
- Server Health Checks - Analyzes server configuration and user databases to generate a prioritized list of potential health issues and warnings.
- Database Session Termination - Terminates resource-heavy or blocking database sessions using specific filters while logging actions and clearing the plan cache.
- Dynamic Management View Samplers - Captures snapshots of real-time dynamic management views to identify blocking and resource contention.
