SharePoint Database "There is insufficient memory in resource pool 'internal to run this query"
We are using SP2019 On-Premise with two-tier architecture, Application Tier and DB Tier. We just did a fresh installation with the basic configuration for SP services and applications and everything works fine on the Application server
However, the DB server is giving this error with regard to server memory:
There is insufficient memory in resource pool 'internal to run this query
We executed the following queries:
sys.dm_os_process_memory
sp_readerrorlog
Our server specs is as follows:
- Windows Server 2019
- Microsoft SQL Server 2019 (RTM) - 15.0.2000.5 (X64) Sep 24 2019 13:48:23 Copyright (C) 2019 Microsoft Corporation Enterprise Edition (64-bit) on Windows Server 2019 Standard 10.0 (Build 17763: ) (Hypervisor)
- RAM: 128 GB, 120 GB allocated for SQL Server
I don't think that really SP needs more than the allocated RAM but I believe it is a configuration issue. Also, it might be a problem occurring from the running app services such as User Profiles and other SP default app services.
As David mentioned, it was because of CU.
Although I installed multiple CUs after installation, the KB5024276 seems to be the one solving the problem.
Thanks.
- Reorder rows in a MySQL table
- Need to truncate a timestamp and add a minute to it in SQL
- Shortcut for Question marks in preparedStatement for parameterized query
- Correctly Migrate Postgres least() Behavior to BigQuery
- Dealing with single quotes in excel vba sql queries
- Data is Null. This method or property cannot be called on Null values
- Redshift GROUP BY ALL syntax not supported
- How to simulate GREATEST() in Sybase ASE?
- Retrieve data from 3 tables with 2 conditions
- How to LOCK with READ COMMITTED SNAPSHOT
- How to save the result of a condition (IF) into a variable?
- SQL query to get students who have enrolled in English or Urdu course but not in both
- Mysql Where Calculate
- MySql reuse alias for WHERE clause
- Filter by distance in the same query that calculates it with MySQL?
- Age calculation not working
- MYSQL using alias in the WHERE clause
- WHERE clause to filter times that are under an hour
- Unknown column for calculate field in MySQL
- Calculated column in where-clause - performance
- mysql calculation results in WHERE clause
- Getting previous column values in a new column
- Why do we always prefer using parameters in SQL statements?
- SQL Statement using Where clause with multiple values
- I am getting the following error when I am inserting a all the lines of a very large log file into ms sql server 2008
- how to see generated sql from a linq query
- Snowflake PARSE_JSON pattern match for keys
- Get a result set flagging where there is a history going back 3 months
- Chaining joins in SQL based on dynamic table
- what are the alternative methods to replace SSRS Subscription?