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