question

narendba avatar image
narendba asked

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

Windows Server is 64bit and SQL SERVER is in 32bit .... And we are having total RAM is 4GB... We are getting the following error freaquently and we decided to dedicate 3GB of RAM to SQL SERVER and 1GB of space to WINDOWS 64BIT... Is this solution will solve this issue or not? If we will dedicate 3GB to SQL SERVER 32bit and 1GB to windows 64bit, will get any problems in future? **Error:** A significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration: 0 seconds. Working set (KB): 581604, committed (KB): 3468328, memory utilization: 16%.
memory-utilization
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Kev Riley avatar image
Kev Riley answered
Have you followed the troubleshooting steps and recommendations in this KB article : [How to reduce paging of buffer pool memory in the 64-bit version of SQL Server ( http://support.microsoft.com/kb/918483)][1] Ultimately though, can you get more RAM? It really will help SQL Server. Running a server with 4GB is pushing it. [1]: http://support.microsoft.com/kb/918483
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.