Database stuck in “Restoring” state
Find the modified date of SQL Server Agents Jobs
PING all the Linked Servers and get a status report
Script to Check TempDB Speed
Total Server Memory and Target Server Memory
Moving the tempdb database
SQL Server buffer pool
Log shipping Alerts failing to send emails
View queries waiting for memory grant
