SQL Server Support Toolkit is a practical collection of SQL Server scripts, troubleshooting guides, monitoring queries, performance tuning techniques, and production support resources designed for Application Support Engineers, Production Support Engineers, Technical Leads, and Database Administrators.
The repository focuses on solving real production issues rather than teaching basic SQL syntax. Every script and document is intended to help investigate incidents, monitor database health, analyse performance problems, validate deployments, and support day-to-day SQL Server operations.
- Application Support Engineers
- Production Support Engineers
- L2/L3 Support Engineers
- Technical Leads
- SQL Server DBAs
- DevOps Engineers
- Developers working with SQL Server
sql-server-support-toolkit/
│
├── docs/
├── scripts/
├── troubleshooting/
├── examples/
├── interview/
└── assets/
- SQL Server Architecture
- T-SQL Fundamentals
- Indexing
- Stored Procedures
- Performance Tuning
- Transactions & Locking
- Backup & Restore
- SQL Server Security
- Best Practices
- SQL Cheat Sheet
- Health Checks
- Monitoring
- Performance Analysis
- Index Management
- Blocking Sessions
- Deadlock Analysis
- Backup & Restore
- Security
- SQL Agent Jobs
- TempDB Monitoring
- Deployment Validation
- Utility Scripts
- High CPU Usage
- Blocking Sessions
- Deadlocks
- Slow Queries
- Connection Issues
- Database Offline
- Login Failures
- TempDB Issues
- Performance Degradation
- Incident Investigation
- Root Cause Analysis
- Deployment Validation
- Performance Troubleshooting
- Database Health Checks
- SQL Server Interview Questions
- Scenario-Based Questions
- Stored Procedure Questions
- Performance Tuning Questions
- Provide production-ready SQL Server scripts.
- Simplify SQL Server troubleshooting.
- Improve performance investigation skills.
- Share practical SQL Server knowledge.
- Support enterprise application support teams.
Contributions are welcome.
If you'd like to improve an existing script, add a new utility, or enhance the documentation, feel free to open an Issue or submit a Pull Request.
This project is licensed under the MIT License.
If you find this repository useful, consider giving it a ⭐ to support the project.