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.這兩個設置通常用於優化微軟SQL Server數據庫服務器上運行的Windows 2000 ， Windows Server 2003和Windows Server 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抗生素後效應已啟用 , although neither Lock Pages in Memory nor AWE depend on 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 。

1. On the Start menu, click Run . 在開始菜單上， 單擊運行。 In the “Open” box, type gpedit.msc .在“打開” 框中 ，鍵入gpedit.msc 。
2. On the “Group Policy” console, expand Computer Configuration , and then expand Windows Settings .在“組策略”控制台中，展開計算機配置 ，然後展開 Windows設置。
3. Expand Security Settings , and then expand Local Policies . 展開安全設置，然後展開本地策略。
4. Select the User Rights Assignment folder.選擇用戶權利指派文件夾。
5. In the right details pane, double-click Lock pages in memory .在右邊的詳細信息窗格中，雙擊鎖的網頁在內存中。

   

6. In the “Local Security Policy Setting” dialog box, click Add .在“本地安全策略設置” 對話框中，單擊添加。
7. 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相關文章

• Data Protection and Encryption with MSD Strongbox數據保護和加密與默沙東保險櫃
• How to Enable PAE on 32-bit Windows Vista for 4 GB or More Memory如何啟用PAE的32位Windows Vista的4 GB或更多的記憶體
• 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年使用大型4GB或更多的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內存診斷內存測試儀
• How to Crack Open Safe and Vault in 5 Minutes (Locksmith or Safe-Cracker Documentary)如何打開保險櫃裂紋和閥門在5分鐘（鎖匠或安全破解跟單）
• Create Booklet From PDF Documents with BookletCreator創建小冊子從PDF文件與BookletCreator
• MySQL Workbench - Visual Database Deign Tool Free Download MySQL的工作台-可視化數據庫設計工具免費下載
• Download Softick Card Export II Trial to Emulate Windows Mobile as Portable Hard Disk下載Softick卡出口二審判效仿的Windows Mobile的便攜式硬盤

This entry was posted on Sunday, June 1st, 2008 at 1:37 am and is filed under 本條目被張貼在週日， 2008年6月一號在上午01時37分，並提交下 Databases 數據庫 . 。 You can follow any responses to this entry through the 您可以按照任何反應，這個項目通過 RSS 2.0 2.0 feed. You can 飼料。您可以 leave a response 留下一個反應 , or 或 trackback 引用 from your own site. 從您自己的網站。