I am using SQL Server 2016 Standard Edition that shows the following errors on DBCC CHECKDB and also on updating statistics.
Version: Microsoft SQL Server 2016 (SP2-CU2) (KB4340355) - 13.0.5153.0 (X64)
Jun 28 2018 17:24:28 Copyright (c) Microsoft Corporation Standard Edition
(64-bit) on Windows Server 2012 R2 Standard 6.3 <X64> (Build 9600: ) (Hypervisor)
MAX Memory set at 215GB from 244GB x1e.2xlarge AWS EC2 There are around 260 databases. Locked Pages in Memory is on. Page File size is 8GB.
Memory optimized tables that uses less than 10GB of memory.
Failed to reserve pages: FAIL_PAGE_RESERVATION
Error: 8645, Severity: 17, State: 1. A timeout occurred while waiting for memory resources to execute the query in resource pool 'internal' (1). Rerun the query.
Error: 701, Severity: 17, State: 135. There is insufficient system memory in resource pool 'internal' to run this query.
After multiple errors like these, the server shutdown itself.
Page life expectancy is 1297050, no memory grants pending, doesn't appear to have any memory pressure.
Any ideas on this issue?
DBCC CHECKDB
on a specific database? How big is the database? Same for the size of the table where update statistics runs on. Also, is the update statistics on a mem optimized table when the error happens?select @@version
,select * from sys.dm_os_process_memory
in the question. Also to actually find root cause please upload output ofsp_readerrorlog
on shared drive and post the link in question. Solving OOM error sometime requires excessive analysis of logs. Do mask imp details in errorlog before uploading. Normally when you get OOM message the output ofdbcc memorystatus()
is dumped in the errorlog.128GB
for database engine. Are you aware about this ? Could this not be the reason for what you are seeing ?