Decoding an affinity mask

Posted by GavinPayneUK on SQL Blogcasts See other posts from SQL Blogcasts or by GavinPayneUK
Published on Wed, 07 Mar 2012 22:18:19 GMT Indexed on 2012/03/18 18:11 UTC
Read the original article Hit count: 272

Filed under:
Recently, in preparation for my SQLBits NUMA internals session I began looking at some of the SQLOS DMVs and trying to understand how their contents directly related to the physical server architecture that SQL Server was running on. While their contents used regular terms such as node and affinity mask the results were often in an “internals” format that can be distracting to the human reader.  An example of this is the DMV sys.dm_os_nodes (link to Technet here ), or more specifically the column...(read more)

© SQL Blogcasts or respective owner