June 9, 2011 at 12:09 am
I was just wondering what DMV's people use on a Daily basis for administration\daily checks?
Best Regards
Chris
June 9, 2011 at 12:38 am
Sys.databases,
Sys.sysdatabases,
Sys.master_files,
Sys.dm_os_buffer_descriptors,
Sys.dm_exec_connections,
Sys.Objects,
Sys.Sysobjects,
Sys.dm_xe_sessions,
Sys.configurations,
Sys.database_files,
Sys.database_mirroring_endpoints,
Sys.sysprocesses,
Sys.dm_io_virtual_file_stats,
Sys.tables,
Sys.system_internals_allocation_units,
Sys.dm_db_mirroring_connections,
Sys.dm_os_memory_clerks,
Sys.dm_db_persisted_sku_features,
Sys.dm_os_latch_stats,
Sys.dm_exec_query_stats,
Sys.server_permissions,
Sys.server_principals,
Sys.Data_Spaces
Sys.dm_exec_cached_plans
Sys.dm_exec_requests
Sys.dm_exec_query_plan
Sys.dm_exec_procedure_stats
sys.dm_tran_locks
syslockinfo
sys.dm_os_buffer_descriptors
sys.dm_os_sys_infoSys.dm_os_schedulers
Sys.dm_db_index_physical_stats
Sys.dm_exec_query_optimizer_info
sys.dm_os_waiting_tasks
sys.sysfiles
Thanks
June 9, 2011 at 6:53 am
I would pick up a copy of Louis Davidson's and Tim Ford's book. That will give you a bunch of the standard DMOs and how to use them.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply