question

reuvygroovy avatar image
0 Votes"
reuvygroovy asked AlexZhu-MSFT edited

HealthService (2232) A significant portion of the database buffer cache has been written out to the system paging file.

I started seeing this error on a bunch of my servers:

Event ID 906:

HealthService (2232) A significant portion of the database buffer cache has been written out to the system paging file. This may result in severe performance degradation.
See help link for complete details of possible causes.
Previous cache residency state: 100% (3852 out of 3852 buffers) (20636 seconds ago)
Current cache residency state: 2% (92 out of 3912 buffers)
Current cache size vs. target: 99% (29.344 / 29.414 MBs)
Physical Memory / RAM size: 8191.016 MBs

I see people mention this event when related to Exchange, but these servers are not Exchange servers.

msc-operations-manager
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

AlexZhu-MSFT avatar image
0 Votes"
AlexZhu-MSFT answered AlexZhu-MSFT edited

Hi,

If the process is svchost, it may relate to Exchange. If the process is HealthService, it may relate to Microsoft Monitoring Agent and/or Operations Manager database server.

The first thing we could try is to verify that the SQL server service account is set to allow lock pages in memory. We could verify that locked pages are working by reviewing the SQL server error log. It shows something like this:

Using locked pages in the memory manager.

If this is already allowed, we may ask the DBA to help check if the database server is in healthy state.

Hope the above information helps.

Alex Zhu


If the response is helpful, please click "Accept Answer" and upvote it.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.