Executing DMVs

• DBA-640728

  SSChampion

  Points: 12898

  More actions

  January 29, 2009 at 2:13 pm

  #134097

  guys is it bad to run DMVs to troubleshoot performance issues in a production server?, i was querying some DMVS and i saw the Memory on the server spiking up tremendously.

  Thanks in advance

• ravikanth.

  Hall of Fame

  Points: 3472

  More actions

  January 29, 2009 at 6:56 pm

  #935219

  some DMVs can impact overall system performance.

  these are few of them.

  sys.dm_os_schedulers

  sys.dm_os_workers

  sys.dm_os_threads

  sys.dm_os_tasks

  sys.dm_os_waiting_tasks

  sys.dm_os_ring_buffers

  Reference : http://sqlblog.com