Enable Lock Pages in Memory to Prevent Database Paging to Disk使鎖的頁面在內存中，以防止數據庫內容分頁到磁盤
Lock Pages in Memory is a Windows security setting policy that determines which accounts can use a process to keep data in physical memory, which prevents the system from paging the data to virtual memory on disk, directly improves the response time speed of the process, especially data-intensive program such as SQL Server database management system, as access time from RAM is definitely faster than disk I/O.頁面鎖定在內存中是一個Windows安全設置的政策，決定哪些帳戶可以使用一個過程來防止數據在物理內存，防止系統傳呼數據，以虛擬內存在磁盤上，直接提高了響應時間的速度的過程中，尤其是數據密集型的程序，如SQL Server數據庫管理系統，作為存取時間從RAM是絕對速度比磁盤的I / O 。
Lock Pages in Memory option privilege must be enabled to頁面鎖定在內存選項的特權，必須使 configure Address Windowing Extensions配置地址窗口擴展 ( （ AWE敬畏 ) which allow a 32-bit software application to access more physical memory than it has virtual address space. ）讓一個32位軟體應用程式存取更多的物理內存比它的虛擬地址空間。 Both settings are normally used to optimize Microsoft SQL Server database server running on Windows 2000, Windows Server 2003 and Windows Server 2008 by allowing the user account running SQL Server to load the whole process in physical memory without using any paging file flow over to disk.雙方設定通常是用來優化Microsoft SQL Server數據庫服務器運行於Windows 2000 ， Windows Server 2003和Windows服務器2008年，允許用戶帳戶運行SQL Server的負荷，整個過程在物理內存中不使用任何分頁文件流量超過到磁盤。
Note that exercising or enabling this privilege could significantly affect system performance by decreasing the amount of available random access memory (RAM).請注意，行使或使這項特權，能顯著影響系統性能降低的數額可隨機存取存儲器（ RAM ） 。 So, a system is recommended to have large memory size, typically bigger than 4 GB.因此，建議制度是有大量記憶體的大小，一般大於4 GB的。 Which mean that on 32-bit operating system,即在32位元作業系統， PAE has to be enabled PAE的是要啟用 , although neither Lock Pages in Memory nor AWE depend on PAE. ，雖然沒有鎖的頁面在內存中，也不依賴於敬畏的PAE 。 Beside, on 32-bit operating systems, setting this privilege when not using AWE can significantly impair system performance.旁邊，對32位元作業系統，設置這項特權，當不使用敬畏可顯著損害系統的性能。 However, on 64-bit operating system, although not required, it’s recommend to lock pages in memory.然而， 64位元作業系統，雖然不是必需的，它的建議鎖定的頁面在內存中。
To enable Lock Pages in Memory setting, system administrator has to use the Windows Group Policy tool (gpedit.msc) to enable this policy for the account used by SQL Server.使鎖在記憶體中的頁面設置，系統管理員使用Windows組策略工具（ gpedit.msc ） ，使這項政策，該帳戶所使用的SQL Server中。
- On the Start menu, click Run .在開始菜單上，單擊運行 。 In the “Open” box, type gpedit.msc .在“打開”框中，鍵入gpedit.msc 。
- On the “Group Policy” console, expand Computer Configuration , and then expand Windows Settings .關於“組策略”控制台中，展開計算機配置 ，然後展開Windows設置 。
- Expand Security Settings , and then expand Local Policies .展開安全設置 ，然後展開本地策略 。
- Select the User Rights Assignment folder.選擇用戶權利指派文件夾中。
- In the right details pane, double-click Lock pages in memory .在右邊的詳細資料窗格中，雙擊頁面鎖在記憶體中 。
- In the “Local Security Policy Setting” dialog box, click Add .在“本地安全策略設置”對話框中，單擊添加 。
- In the “Select Users or Groups” dialog box, add an account with privileges to run sqlservr.exe (eg NetworkService).在“選擇用戶或組”對話框中，添加一個帳戶與權限才能運行的Sqlservr.exe （例如networkservice ） 。
IMPORTANT : You're reading a machine translated page which is provided "as is" without warranty. 重要說明：您正在閱讀的機器翻譯網頁是“按原樣”提供的擔保。 Unlike human translation, machine translation does not understand the grammar, semantics, syntax, idioms of natural language, thus often produce inaccurate and low quality text which is misleading and incomprehensible.不像人類翻譯，機器翻譯不明白的語法，語義，語法，成語自然語言，因此，往往產生不準確的和低品質的文字，是具誤導性的和難以理解的。 Thus, please refer to因此，請參閱 original English article英文原版的文章 when in doubt.有疑問時。
Related Articles相關文章
- How to Enable PAE on 32-bit Windows Vista for 4 GB or More Memory如何啟用PAE的32位Windows Vista的4 GB或更多的內存
- Data Protection and Encryption with MSD Strongbox數據保護和加密與美國默沙東藥廠StrongBox的
- VMWare Server Causes System Frozen, Hang and Unresponsive When Power/Start Up in Vista VMware服務器系統的原因被凍結，坑及反應遲鈍時，電源/啟動在Vista
- How to Enable PAE in x86 32-bit Windows Server 2003 and 2000 to Use Large 4GB or More RAM Memory如何啟用PAE在x86 32位元Windows Server 2003和2000年使用大型4 GB的或更多的RAM記憶體
- Windows Cannot Hibernate Computer with More Than 4 GB Memory Windows無法休眠的電腦與4 GB以上的記憶
- Test Memory On Computer for Errors with Windows Memory Diagnostic RAM Tester測試內存對電腦的錯誤與Windows內存診斷RAM的測試
- How to Crack Open Safe and Vault in 5 Minutes (Locksmith or Safe-Cracker Documentary)如何打擊公開的安全和跳馬在5分鐘（鎖匠或安全裂解紀錄片）
- MySQL Workbench - Visual Database Deign Tool Free Download MySQL的工作台-可視化數據庫的設計工具免費下載
- Create Booklet From PDF Documents with BookletCreator創建小冊子，從PDF文件與bookletcreator
- Download Softick Card Export II Trial to Emulate Windows Mobile as Portable Hard Disk下載softick卡出口II試驗效仿Windows Mobile的便攜式硬盤
