WID Database Page Error Event 17890 - Since January 2021 update

Question

I have noted the following entries in the Application Log since the January 2021 update
I manage a bunch of RDS server and they all show the same

Event 17890
A significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration: 1520 seconds. Working set (KB): 152332, committed (KB): 369624, memory utilization: 41%%.

While this is just an Informational message, the CPU for SQL is now in the 10-12% consitently and is causing RDS performance issues

Is there a way to manage the WID memory and fix this ?
But, the CPU for SQL is now high as well and causing RDS performance issues

Steve

Answer 1

Hello @Steve Babcock

"SQL Server monitors the various memories related information about the SQL Server process. In this case, it has detected that the working set of the process is less than 50% of the committed process memory. As a result this warning is printed. The normal causes of this warning are:

• The operating system pages out large portions of the SQL Server committed memory to the paging file.
• This could be due to sudden increased demand for memory from other applications or operating system needs.
• This could also happen when certain device drivers request contiguous memory allocations for their needs."

Quoted from MSSQLSERVER_17890

Best Regards
Karlie

----------

If the Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.