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

Hi Experts,

We have a new SQL Cluster built. Windows 2008 R2/ SQL Server 2005 SP3 with 96 GB RAM.

It is not in production and was a fresh install.

I limited SQL Server to 90 GB RAM and see this error in the error log:

A significant part of sql server process memory has been paged out. This may result in a performance degradation.

Any idea why this occurs and how to resolve.

Thanks,
LVL 8
dba2dbaAsked:
Who is Participating?
 
HumpdyConnect With a Mentor Commented:
This is a fully documented issue, with fix, from Microsoft.
http://support.microsoft.com/kb/918483
0
 
EvilPostItConnect With a Mentor Commented:
To fix this you should just need to assign the "Lock Pages in Memory" attribute to the service account that SQL Sevrer is running under. You can do this in secpol.msc.
0
 
dba2dbaAuthor Commented:
I have gone through the articles.

Can you please advice  if there are any ill affects of enabling this privilege.

Thanks,
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
HumpdyCommented:
I had to go through it not so long ago....no issues........................................YET
0
 
EvilPostItCommented:
This is pretty standard. I would also make sure that you set your memory limits too though. Ie min server memory & max server memory. These settings are both in SQL. Otherwise it will be possible for SQL Server to all memory and not give anything back to the os.
0
 
FrancoCarusiCommented:
Hi

You don't mention if you are running in X32 or X64?
Set the service account to lock pages in memory and then enable AWE on the sql.
0
All Courses

From novice to tech pro — start learning today.