A significant part of sql server process memory has been paged out

Do you have the following occuring on your SQL Server system.

If so it is likely you are running SQL Server 2005 or SQL Server 2008 Standard edition on x64 hardware.

It will be causing you serious performance issues when it occurs, as all your database pages will be removed from memory and thus SQL will have to read them again from disk. The MVP community and especially Maciej Pilecki is trying to get Microsoft to do something more proactive about it.

The problem is due to bugs in third party drivers and OS bugs.

According to Microsoft all known bugs have been fixed by the relevant vendors and so you shouldn't be experiencing this issue, if you update your system

If you are still experiencing this, which we believ many people still are, then you must contact customer support  (https://support.microsoft.com/oas/default.aspx?iid=246306&iguid=bd81e653-64b3-4bf7-bec9-798309406d4d_2_1&ln=en-gb&prid=9455&gprid=347865) to get the to provide you with details of the updates that you will need to apply to your system. My understanding is that this will not cost you anything, as it is a known bug. (Some are detailed here http://blogs.msdn.com/psssql/archive/2007/05/31/the-sql-server-working-set-message.aspx 

If after contacting CSS you are unable to get an immediate fix, or they want you to pay please comment and vote on this connect item

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=422322

Or send me email using this form http://sqlblogcasts.com/blogs/simons/contact.aspx


-
Published 10 March 2009 21:52 by simonsabin

Comments

12 March 2009 08:38 by SQLGEEK

# [PL] Bug miesiąca – Lock pages in memory w Standard Edition

Jeśli zdarzyło Ci się kiedykolwiek, że w logach SQL Servera (najpewniej wersja 2005 lub 2008 Standard