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