A significant part of sql server process memory has been paged out

ywxj_001發表於2017-12-25
NifiSQLServer
問題現象：
Sqlserver 2014 alwayson架構主節點日誌依次報錯：

日期 2017/12/25 10:02:35
日誌 SQL Server (當前 - 2017/12/25 10:33:00)
源 spid33s
A significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration: 0 seconds. Working set (KB): 840, committed (KB): 48081936, memory utilization: 0%.

日期 2017/12/25 10:02:35
日誌 SQL Server (當前 - 2017/12/25 10:33:00)
源 Server
The lease between availability group 'HKERP_AlwaysOn' and the Windows Server Failover Cluster has expired. A connectivity issue occurred between the instance of SQL Server and the Windows Server Failover Cluster. To determine whether the availability group is failing over correctly, check the corresponding availability group resource in the Windows Server Failover Cluster.

日期 2017/12/25 10:02:35
日誌 SQL Server (當前 - 2017/12/25 10:33:00)
源 Server
AlwaysOn: The local replica of availability group 'HKERP_AlwaysOn' is going offline because either the lease expired or lease renewal failed. This is an informational message only. No user action is required.

日期 2017/12/25 10:02:35
日誌 SQL Server (當前 - 2017/12/25 10:33:00)
源 Server
The state of the local availability replica in availability group 'HKERP_AlwaysOn' has changed from 'PRIMARY_NORMAL' to 'RESOLVING_NORMAL'.  The state changed because the lease between the local availability replica and Windows Server Failover Clustering (WSFC) has expired.  For more information, see the SQL Server error log, Windows Server Failover Clustering (WSFC) management console, or WSFC log.

記憶體的page out導致sqlserver的網路超時進而導致sqlserver cluster超時。
因為在10:02時候有Mcafee對伺服器的掃描，懷疑是mcafee的掃描導致的記憶體的page out。
進而導致了網路問題而引起sqlserver cluster的超時。

解決辦法：
對sqlserver的伺服器進行資料庫的記憶體鎖定。

修改組策略的“鎖定記憶體頁”

設定鎖定記憶體頁，把sqlserver服務啟動賬號加入



後續觀察後，問題不再發生，解決。




來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/22996654/viewspace-2149233/，如需轉載，請註明出處，否則將追究法律責任。

相關文章