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