After seeing messages like this throughout the ERRORLOG:
A significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration: 1569 seconds. Working set (KB): 14541620, committed (KB): 47456492, memory utilization: 30%.
I ran the following query:
select * from sys.dm_os_ring_buffers where ring_buffer_type='RING_BUFFER_RESOURCE_MONITOR';
The output is too large for this forum but the question I have pertains to this section from the 'record' column:
<Effect type="APPLY_HIGHPM" state="EFFECT_ON" reversed="0">0</Effect>
Can someone explain what this means? At the time we our cluster had failed over such that the SQL Server 2008 R2 instance was supporting twice the load as normal, i.e. 4 instances were running on the node instead of the normal two. The windows 2003 server
has 64 gig of memory configured, each SQL Server instance has 30 gig allocated for MAX mem - so I can see where there would be a problem - but I'd like a decent explanation of the above XML data as well as any further explanation about the query and its result
set in general.
View Complete Post