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

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.

About service packs for SQL Server
About service packs for SQL Server

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.
Vlastnosti

ID článku: 3170015 – Posledná kontrola: 16. 11. 2016 – Revízia: 1

Pripomienky