Blog

I am trying to monitor live performance data and usage, which cannot be tracked with PerformanceMonitor. What are the consequences of reading DMVs in a production live OLTP database? : Eg: sys.dm_tran_locks, sys.dm_os_waiting_tasks, sys.dm_os_performance_counters, sys.dm_exec_connections, sys.dm_io_virtual_file_stats, sys.dm_exec_sql_text,etc Should I just utilize WITH (NOLOCK) when querying Dmvs? Would this resolve many of the resource issues? IsRead more