Memory Status

dbcc memorystatus select * from sys.dm_exec_requests dbcc sqlperf (spinlockstats) select * from sys.dm_os_wait_stats select * from sys.dm_os_waiting_tasks select * from sys.dm_os_latch_stats select * from sys.dm_os_spinlock_stats