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.