Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 932
  • 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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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