admin管理员组

文章数量:1530305

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

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

本文标签： sqlPartsignificantServerpaged

版权声明：本文标题：A significant part of sql server process memory has been paged out 内容由热心网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：https://m.elefans.com/dongtai/1725721140a1038389.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。