SP; search Query plan cache for issues, like table scans, missing indexes or stats, or any other command
What is the Used, Free and Reserved space per DB / LOG
What is the relative load per DB in CPU, IO and CLR?
What is the actual (sparse) file size on disk of a snapshot?
Determine the page life expectancy per NUMA node (is it balanced?)
Displays the IO in bytes per database per drive [table id=3 /]
Displays the free space,free space percentage plus total drive size for a server [table id=2 /]
Show the CPU load in last 256 minutes
How much memory each DB is using for sql plan cache?
Ever wondered how much memory each DB is using for buffering data? And in detail