DMV sys.dm_os_memory_nodes returns a non-zero value for the pages_kb value for the DAC node in SQL Server 2014

Applies to: SQL Server 2014 DeveloperSQL Server 2014 DeveloperSQL Server 2014 Enterprise More

Symptoms


In Dynamic Management View (DMV), sys.dm_os_memory_nodes returns a non-zero value for the pages_kb value for the DAC node in SQL Server 2014 or 2016.

Resolution


This issue is fixed in the following service pack for SQL Server:


After you install this update, the DMV sys.dm_os_memory_nodes returns 0 for the pages_kb value for the DAC node.

Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

More Information


Nodes are created to correspond with the physical NUMA memory nodes. These might differ from the CPU nodes in sys.dm_os_nodes.

The DAC node is reserved for the Dedicated Administrative Connection.

The Pages_kb value specifies how much committed memory in kilobytes (KB) is allocated from this NUMA node by the Memory Manager Page Allocator. This value cannot be null.

References


Learn about the terminology  that Microsoft uses to describe software updates.