DBA Scripts
A curated collection of practical SQL Server scripts used in real production environments. Focused on performance, backups, configuration, security, and operational visibility. Built for DBAs who need answers quickly.
Performance Troubleshooting
- Script: Identify Long-Running Queries
- Script: Identify Missing Indexes
- Script: I/O Usage by Database
- Script: Top Wait Statistics
- Script: Check Worker Threads and Active Sessions
High Availability & Disaster Recovery
- Script: Check AG Replica Role and Synchronization State
- Script: Check Always On Availability Group Latency