Collections
BLOCKTREE
Blocked processes
DBUSAGE
Database space usage
DMV_CURRENTSHOWPLAN
SQL plans for current executing statements
DMV_CURRENTSQLTEXT
SQL text of current executing statements
DMV_CURRENTSTMT
Current executing statements
DMV_SESSIONSUM_BYDB
Session summary by database
DMV_SESSIONSUM_BYLOGIN
Session summary by login name
FGUSAGE
Filegroup space usage
FILEUSAGE
File space usage
GLOBALSTATS
Global statistics
LOCKS
Locks
PROCESS
Processes
SP_CONFIGURE
SQL Server settings, or parameters