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.

Tags: , , , , , , ,

This entry was posted on Monday, July 5th, 2010 at 14:18 and is filed under Uncategorized. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.


2 Responses to “SQL Server 2008 R2 – DMV Changes”

  1. vinodkumar says:

    Simon – Yes, they make a lot more easier to work with >64 cores with these columns. These will also be interesting with NUMA or HT technologies too to debug possible CPU problems. The options are endless. BTW, thanks for dropping by :) … Much appreciated.

  2. Simon Sabin says:

    That looks like mostly stuff to support the >64cores introduced in R2

Leave a Reply