-- Top Cached SPs By Execution Count -- Top Cached SPs By Avg Elapsed Time -- Top Cached SPs By CPU -- Top Cached SPs By Total Logical Reads -- Top Cached SPs By Total Physical Reads -- Top Cached SPs By Total Logical Writes
similar to AdHocPlanCacheBloat. This will show you the breakdown of adhoc vs prepared vs proc, etc. the USE_COUNT will show you if parameterization is working for you.
Logs cases where writes>reads. This may mean the index can be dropped. But you must understand your workload. However, if Total Reads is ZERO then you can generally drop that index. Unless you have a year-end process that needs it or some other edge case where the index is only needed occassionally.
Lists transactions and query plans that are using more than 50MB of tempdb log space.
Shows spids and statements that are using more than 50MB of tempdb space.