Sql-Server
不斷收到消息：分配頁面失敗：FAIL_PAGE_ALLOCATION 540
我很感激以下方面的幫助，我已經做了一些Google搜尋，但還沒有設法解決這個問題。
我在 SQL 日誌中不斷收到一條消息“分配頁面失敗：FAIL_PAGE_ALLOCATION 540”，然後是一個轉儲，我將添加到這個問題的末尾。
供您參考，建構是：
- 在 vCenter 上執行的虛擬伺服器
- Windows Server 2008 R2 64 位 SQL
- Server 2012 SP1 Enterprise (11.0.2100) 8GB RAM SQL Server 最大和最小記憶體設置為 6144 MB
伺服器是 2 節點可用性組的一部分，這是目前的主節點。
此實例託管 Microsoft SharePoint 的數據庫
我執行了 24 小時的 Perfmon 跟踪，結果只顯示 PLE 在一次轉儲後下降，然後又上升。沒有什麼特別奇怪的。
SQL Server 仍在執行。
從 SQL 日誌中提取：
10/03/2014 09:59:52,spid866,Unknown,CACHESTORE_XMLDBELEMENT (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>Pages Allocated 8 10/03/2014 09:59:52,spid866,Unknown,CACHESTORE_XMLDBTYPE (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>Pages Allocated 8 10/03/2014 09:59:52,spid866,Unknown,CACHESTORE_VIEWDEFINITIONS (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>Pages Allocated 16 10/03/2014 09:59:52,spid866,Unknown,CACHESTORE_NOTIF (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>Pages Allocated 16 10/03/2014 09:59:52,spid866,Unknown,CACHESTORE_TEMPTABLES (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>Pages Allocated 448 10/03/2014 09:59:52,spid866,Unknown,CACHESTORE_XPROC (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>Pages Allocated 120 10/03/2014 09:59:52,spid866,Unknown,CACHESTORE_PHDR (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>Pages Allocated 157688 10/03/2014 09:59:52,spid866,Unknown,CACHESTORE_SQLCP (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>Pages Allocated 886856 10/03/2014 09:59:52,spid866,Unknown,CACHESTORE_OBJCP (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>Pages Allocated 409760 10/03/2014 09:59:52,spid866,Unknown,MEMORYCLERK_FSCHUNKER (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>Pages Allocated 48 10/03/2014 09:59:52,spid866,Unknown,MEMORYCLERK_LWC (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>Pages Allocated 8 10/03/2014 09:59:52,spid866,Unknown,MEMORYCLERK_SQLLOGPOOL (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>Pages Allocated 8208 10/03/2014 09:59:52,spid866,Unknown,MEMORYCLERK_HADR (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>Pages Allocated 688 10/03/2014 09:59:52,spid866,Unknown,MEMORYCLERK_XE (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>Pages Allocated 218176 10/03/2014 09:59:52,spid866,Unknown,MEMORYCLERK_FILETABLE (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>Pages Allocated 16 10/03/2014 09:59:52,spid866,Unknown,MEMORYCLERK_SQLSERVICEBROKERTRANSPORT (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>Pages Allocated 232 10/03/2014 09:59:52,spid866,Unknown,MEMORYCLERK_FULLTEXT_SHMEM (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 24<nl/>SM Committed 24<nl/>Pages Allocated 0 10/03/2014 09:59:52,spid866,Unknown,MEMORYCLERK_SOSMEMMANAGER (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 474880<nl/>VM Committed 474736<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>Pages Allocated 0 10/03/2014 09:59:52,spid866,Unknown,MEMORYCLERK_SOSOS (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>Pages Allocated 192 10/03/2014 09:59:52,spid866,Unknown,MEMORYCLERK_SOSNODE (Total) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>Pages Allocated 71968 10/03/2014 09:59:52,spid866,Unknown,MEMORYCLERK_SOSNODE (node 64) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>Pages Allocated 2432 10/03/2014 09:59:52,spid866,Unknown,MEMORYCLERK_SOSNODE (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>Pages Allocated 69536 10/03/2014 09:59:52,spid866,Unknown,MEMORYCLERK_HOST (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>Pages Allocated 24 10/03/2014 09:59:52,spid866,Unknown,MEMORYCLERK_XTP (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>Pages Allocated 16 10/03/2014 09:59:52,spid866,Unknown,MEMORYCLERK_XE_BUFFER (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 206208<nl/>VM Committed 206208<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>Pages Allocated 0 10/03/2014 09:59:52,spid866,Unknown,MEMORYCLERK_SQLQERESERVATIONS (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>Pages Allocated 1328 10/03/2014 09:59:52,spid866,Unknown,MEMORYCLERK_BHF (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>Pages Allocated 192 10/03/2014 09:59:52,spid866,Unknown,MEMORYCLERK_SQLXP (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>Pages Allocated 16 10/03/2014 09:59:52,spid866,Unknown,MEMORYCLERK_FULLTEXT (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>Pages Allocated 296 10/03/2014 09:59:52,spid866,Unknown,MEMORYCLERK_SNI (Total) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>Pages Allocated 1024 10/03/2014 09:59:52,spid866,Unknown,MEMORYCLERK_SNI (node 64) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>Pages Allocated 16 10/03/2014 09:59:52,spid866,Unknown,MEMORYCLERK_SNI (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>Pages Allocated 1008 10/03/2014 09:59:52,spid866,Unknown,MEMORYCLERK_SQLHTTP (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>Pages Allocated 8 10/03/2014 09:59:52,spid866,Unknown,MEMORYCLERK_SQLSERVICEBROKER (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>Pages Allocated 984 10/03/2014 09:59:52,spid866,Unknown,MEMORYCLERK_SQLCLR (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 1603008<nl/>VM Committed 28096<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>Pages Allocated 4816 10/03/2014 09:59:52,spid866,Unknown,MEMORYCLERK_SQLCONNECTIONPOOL (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>Pages Allocated 20464 10/03/2014 09:59:52,spid866,Unknown,MEMORYCLERK_SQLSTORENG (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 23040<nl/>VM Committed 23040<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>Pages Allocated 40144 10/03/2014 09:59:52,spid866,Unknown,MEMORYCLERK_SQLUTILITIES (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>Pages Allocated 408 10/03/2014 09:59:52,spid866,Unknown,MEMORYCLERK_SQLOPTIMIZER (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>Pages Allocated 2224 10/03/2014 09:59:52,spid866,Unknown,MEMORYCLERK_SQLQUERYEXEC (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>Pages Allocated 2856 10/03/2014 09:59:52,spid866,Unknown,MEMORYCLERK_SQLBUFFERPOOL (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 3251552<nl/>VM Committed 137416<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>Pages Allocated 3188808 10/03/2014 09:59:52,spid866,Unknown,MEMORYCLERK_SQLGENERAL (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>Pages Allocated 23920 10/03/2014 09:59:52,spid866,Unknown,Memory node Id = 64 KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 20<nl/>Locked Pages Allocated 0 10/03/2014 09:59:52,spid866,Unknown,Memory node Id = 0 KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 274536504<nl/>VM Committed 6291428<nl/>Locked Pages Allocated 0<nl/>Pages Allocated 5393336<nl/>Pages Free 10504<nl/>Target Committed 6291432<nl/>Current Committed 6291432<nl/>Foreign Committed 0<nl/>Away Committed 0 10/03/2014 09:59:52,spid866,Unknown,Memory Manager KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 274536568<nl/>VM Committed 6291448<nl/>Locked Pages Allocated 0<nl/>Large Pages Allocated 0<nl/>Emergency Memory 1024<nl/>Emergency Memory In Use 16<nl/>Target Committed 6291456<nl/>Current Committed 6291448<nl/>Pages Allocated 5393336<nl/>Pages Reserved 1224<nl/>Pages Free 10504<nl/>Pages In Use 3093536<nl/>Page Alloc Potential 2883352<nl/>NUMA Growth Phase 2<nl/>Last OOM Factor 2<nl/>Last OS Error 0 10/03/2014 09:59:52,spid866,Unknown,Process/System Counts Value<nl/>---------------------------------------- ----------<nl/>Available Physical Memory 787546112<nl/>Available Virtual Memory 8514575921152<nl/>Available Paging File 8859074560<nl/>Working Set 6637367296<nl/>Percent of Committed Memory in WS 100<nl/>Page Faults 256980685<nl/>System physical memory high 1<nl/>System physical memory low 0<nl/>Process physical memory low 0<nl/>Process virtual memory low 0 10/03/2014 09:59:52,spid866,Unknown,Failed allocate pages: FAIL_PAGE_ALLOCATION 540
因為在摘錄中只有 8208 頁分配給 MEMORYCLERK_SQLLOGPOOL，所以不確定 kb2769594 是罪魁禍首/修復。也沒有像 kb2769594 範例中那樣引用內部池或 HADR。 https://support.microsoft.com/kb/2769594
所以我認為罪魁禍首/修復可能是別的東西。
令人驚訝的是根本沒有分配大頁面 - 我希望伺服器上有一些具有 8 GB RAM 的非 bpool。SQL Server 企業版？低系統記憶體有點令人驚訝 - 除了 SQL Server 之外，還有另一個大記憶體消耗者嗎？哪個作業系統版本？NTFS 文件記憶體是否得到很好的控制？
編輯 通過 twitter 還詢問是否需要“鎖定記憶體中的頁面”LPIM - 上面沒有顯示鎖定頁面。