Archive for July 5th, 2010

SQL Server 2008 R2 – DMV Changes July 5th, 2010

Vinod Kumar

Majority of the folks over various conversations tell me there are not much of changes with the R2 version. Well, there are tons of little things that make the product better and better both for Developers and ITPro’s alike. In this list is some subtle additions to the DMV’s which make some interesting insights into the product itself. I will make another post to get some interesting insights with these DMV’s for you … Some of the DMV extensions made are around –

SYS.DM_OS_THREADS

  • processor_group

SYS.DM_OS_WORKERS

  • processor_group

SYS.DM_OS_NODES

  • online_schduler_mask
  • processor_group

SYS.DM_OS_SYS_INFO

  • affinity_type
  • affinity_type_desc
  • process_kernel_time_ms
  • process_user_time_ms
  • time_source
  • time_source_desc

SYS.DM_OS_MEMORY_NODES

  • cpu_affinity_mask
  • online_scheduler_mask
  • processor_group

Surely, these don’t form the complete list but can be something to explore for the future.

Continue reading...