Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
imarchenko
Yak Posting Veteran
57 Posts |
 Posted - 2008-12-05 : 19:09:13
|
| Hello! This is a follow up to my previous post: ' We have just configured SQL Server 2005 64-bit two node active/passive cluster with 32 GB of RAM. I have limited SQL Server memory usage to 26 GB. Total Server Memory (KB) shows value 16MB at the moment. Target Server Memory (KB) is showing 27262976 (26 GB). ...'. I have noticed that there are multiple messages (not just on start up) in SQL Server error log:'MessageA significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration: 331 seconds. Working set (KB): 95276, committed (KB): 204776, memory utilization: 46%.'. We are running SQL Server 2005 SP2 64-bit Standard Edition on Windows 2003 Enterprise R2 64-bit and 'Lock Pages in Memory' is ignored. I did some research and the general consensus is if this error only shows up on start up it is OK. But it is not the case in my enviroment. I am really concerned about performance implications and hesitant to start using this enviroment. Any advice is greately appreciated. Thanks,Igor |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-05 : 19:41:33
|
| Enable 'Lock pages in Memory' and you should be good. |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-05 : 19:42:59
|
| It was addressed here too:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=115660 |
|
|
|
|
|
|
'A significant part of sql server process memory h