Database stuck in “Restoring” state
Find the modified date of SQL Server Agents Jobs
Script to Check TempDB Speed
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
