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.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 What does lock page in memory does???

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
Go to Top of Page
   

- Advertisement -