We are running a system on SQLServer 2017 Enterprise (RTM-CU22) with 839GB of memory.
I think we appear to be experiencing some memory pressure as we seem to have plans dropping from the cache and I can see various clock-hands running (including CACHESTORE_OBJCP – EXTERNAL and CACHESTORE_SQLCP – EXTERNAL).
When I check the Memory Clerks the bulk of memory is taken up by MEMORYCLERK_SQLBUFFERPOOL around 750GB, with about 26GB for CACHESTORE_OBJCP and CACHESTORE_SQLCP of around 8GB. Typically no other clerks are over 1 GB.
When I look in the RING_BUFFER_RESOURCE_MONITOR the only RESOURCE_MEMPHYSICAL_LOW events we see are for IndicatorsPool.
I’m a bit at a loss as to working out what is causing the pressure and what the RESOURCE_MEMPHYSICAL_LOW for IndcatorsPool is telling me (and if this is related).
Could anyone give me any pointers on where to look next?