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 |
|
SCHEMA
Posting Yak Master
192 Posts |
 Posted - 2009-06-23 : 09:33:25
|
| We have New 64-bit SQL Server Enterprise Edition with 16GB of RAM. Should I enable 'Lock pages in Memory' or not? Does it affect the performance? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-06-23 : 09:48:06
|
Do you suffer from page flushing?
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2009-06-23 : 11:56:03
|
| Yes. Its recommended to use it.. BOL says its not required on 64bit however its recommended.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
SQLBuddy123
Starting Member
26 Posts |
Posted - 2009-06-23 : 14:57:16
|
| Hi Schema,For 64-bit SQL Server Enterprise edition , its recommended to turn on the option "Lock Pages in Memory" for better memory and paging management.Best Regards,SQL Buddy. |
|
|
|
|
|
|
Should I enable 'Lock pages in Memory'