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

问题现象：
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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22996654/viewspace-2149233/