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 |
|
anoop_mig25
Starting Member
20 Posts |
 Posted - 2013-07-22 : 13:55:24
|
| Hi i want to know what lock pages in memory option does.i donot gets it wording " Windows not to swap out SQL Server memory to disk ".by sql server memory does it means RAM and by disk does it means secondary storage (or harddrives).And when it should be used |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2013-07-22 : 14:00:45
|
It means it will not flush data cache in memory (RAM) to disk when memory is low.
Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA |
 |
|
|
|
|
|
What does lock page in memory does???