SP; search Query plan cache for issues, like table scans, missing indexes or stats, or any other command
Category: Performance
What is the Used, Free and Reserved space per DB / LOG
What is the relative load per DB in CPU, IO and CLR?
Determine the page life expectancy per NUMA node (is it balanced?)
Displays the IO in bytes per database per drive [table id=3 /]
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