.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links


Posted By:      Posted Date: October 04, 2010    Points: 0   Category :Sql Server

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.

Thanks -


View Complete Post

More Related Resource Links

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend