SQLTeam.com | Weblogs | Forums

DBCC Integrity Check Error - insufficient system memory in resource pool

Hello,
We have Sql server STD 2012 SP2 and from last 3 days, we are getting error while running the DBCC Integrity Check for both User and system Databases, we are using Ola Maintenance solution script.
We have Total Physical Memory 8 GB, Total Virtual Memory 9.25 GB (showing in system Information Available Physical Memory 925 Mb and Available Virtual Memory 2.25 Gb).
MAX Memory configured as 4096 MB and MIN Memory 1024 KB)
We are seeing following error in sql server error log:
indent preformatted text by 4 spaces
Level 17, State 123, Server line 1 There is insufficient system memory in resource pool 'internal' to run this query.
Msg 8921, Level 16, State 1, Server ,Line 1 Check terminated. A failure was detected while collecting facts.
Possibly tempdb out of space or a system table is inconsistent. Check previous errors.
Outcome: Failed Duration: 02:55:03 DateTime: 2020-04-24 07:39:12
DateTime: 2020-04-24 07:39:12. Process Exit Code 1. The step failed.

When i checked Event log then i see the following error:
There is insufficient system memory in resource pool 'internal' to run this query.

We have TEMP DB configure as:
Size" 2046 MB and space available: 1360 MB
Temp Files: TempDB, TempDev2 and TempLog

We have only one real DB with 6 Gb.

We don't have Resource pool enabled:
SELECT is_enabled FROM sys.resource_governor_configuration;
GO ==> It returns '0'

As SQL20212 SP2 went out of support on 2017-01-10 it might be an idea to backup the server and patch to SP4 with the latest GDR first.

Thanks Ifor, I am agreed with you and will do the patch.
I increased MAX Memory and job run successfully last night.