NUMA and PLE Behavior in SQL Server 2012 Core by Tommy.Bollhofer

Closed

as External Help for as External

Type:	Bug
ID:	778968
Opened:	2/11/2013 7:36:38 AM
Access Restriction:	Public

Workaround(s)

view

User(s) can reproduce this bug

Since upgrading from SQL Server 2008 Enterprise to SQL Server 2012 Core on a 4 socket, 8 core system we are experiencing large drops in PLE across the 4 NUMA nodes and/or large flucations on individual NUMA nodes. This occurs during the quietest periods on the system with a min memory setting of 80GB and a max memory setting of 112GB. There is no internal or external memory pressure on the system when this occurs.

Details (expand)

English

Sync Framework 2.1

SQL Engine

Windows Server 2008 R2 Enterprise

English

NUMA system with 4 sockets/8 cores with hyperthreading enabled.
Closely monitor PLE on NUMA nodes during active and quiet periods.

Large drops in PLE on individual NUMA nodes unexplainable.

PLE shouldn't be affected during quiet periods.

X64

0 attachments

Posted by Microsoft on 2/19/2013 at 10:36 AM

Thanks for reporting this and engaging the support team.
We will work with the support team to investigate this.

Ajay Jagannathan
Senior Program Manager
Microsoft Corporation

Posted by Tommy.Bollhofer on 2/11/2013 at 12:04 PM

FYI, opened an SR for this; 113021110207338.

Microsoft