Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 945
  • Last Modified:

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,
0
dba2dba
Asked:
dba2dba
2 Solutions
 
HumpdyCommented:
This is a fully documented issue, with fix, from Microsoft.
http://support.microsoft.com/kb/918483
0
 
EvilPostItCommented:
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
A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now