As an experienced SQL Server DBA, you'll begin to notice that the most common issues you focus on end up falling into a handful of logical categories.
I have assembled a collection of very data-dense SQL Server scripts that will help you focus and identify the issues in these categories, to provide a fast, complete picture of what is going on, and the direction to take to fix the issues.
"The Right Now Emergency Bucket" queries that help you see exactly what is going on quickly, so you can focus on the resolution "The Performance is Slow Bucket" queries that help you find bad statistics, missing indexes and poor procedure/sql statement performance.
"The Stuff is Not Working as Expected Bucket" queries that find errors, job problems, SSRS reports and subscription failures, login orpermissions issues, and application errors.
