SQL Server DBA Troubleshooting Queries

This repository contains various SQL scripts and documents to aid SQL Server DBAs in troubleshooting common issues.

Queries and Scripts

1. Performance Monitoring:

   • 10_IO Warnings.sql
   • 11_Drive Level Latency.sql
   • 12_Waits.sql
   • 13_Expensive Queries.sql
   • ...

2. Index Management:

   • 15_1 ms missing index.txt
   • 15_Index Fragmentation.sql
   • 16_Duplicate Indexes.sql
   • ...

3. Security Audits:

   • 29_Server Level Security.sql
   • 30_DB Level Security.sql
   • ...

4. Backup and Restore:

   • 25_Backup in Last 7 days.sql
   • 34.2 Backup for each db last 7 days.txt
   • ...

5. Server Configuration:

   • 1_1_ServerReport_Universal_v2.1_2005.sql
   • 2_Configuration Values.sql
   • ...

6. Additional Tools and Utilities:

   • 40.1 Index options.sql
   • 42 SQL Job owners.sql
   • 43 Flush or Clear SQL Server Cache.txt
   • ...

Contributing

Feel free to contribute by submitting pull requests or opening issues for discussion.

License

This repository is licensed under the MIT License. See LICENSE for more information.