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

reuvygroovy 781 Reputation points
2020-10-27T05:17:09.52+00:00

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.

Operations Manager
Operations Manager
A family of System Center products that provide infrastructure monitoring, help ensure the predictable performance and availability of vital applications, and offer comprehensive monitoring for datacenters and cloud, both private and public.
1,488 questions
{count} votes

1 answer

Sort by: Most helpful
  1. AlexZhu-MSFT 5,956 Reputation points Microsoft Vendor
    2020-10-27T07:19:24.683+00:00

    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.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.