Wednesday, January 19, 2011

Dynamic Management Views

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