I am going through DMVs in 2008 and its astounding, there are too many views and functions that its difficult to remember.
Here are some I picked up seeing the names, its best to left to the readers or to me whenever I get a chance to browse through the list.
select * from sys.dm_db_task_space_usagego
select * from sys.dm_db_session_space_usagego
select * from sys.dm_exec_query_memory_grantsgo
select * from sys.dm_exec_query_optimizer_infogo
select * from sys.dm_exec_cached_plansgo
select * from sys.dm_exec_connectionsgo
select * from sys.dm_exec_query_plango
select * from sys.dm_exec_query_statsgo
select * from sys.dm_exec_text_query_plango
select * from sys.dm_io_pending_io_requestsgo
select * from sys.dm_os_memory_cache_countersgo
select * from sys.dm_os_memory_objectsgo
select * from sys.dm_os_memory_allocationsgo
select * from sys.dm_os_memory_poolsgo
select * from sys.dm_os_performance_countersgo
select * from sys.dm_os_ring_buffersgo
select * from sys.dm_os_threadsgo
select * from sys.dm_os_wait_statsgo
select * from sys.dm_tran_locksgo
select * from sys.dm_tran_active_transactionsgo
No comments:
Post a Comment