AlwaysOn synchronize performance can affect memory?


In an AlwaysOn environment, if you found your memory is slowly increasing or out of memory, you can use below way to check if it’s caused by slow synchronization.

 

Firstly, check the errorlog or use DBCC MEMORYSTATUS to dump the memory usage, and see if the allocation mainly stayed on OBJECTSTORE_SERVICE_BROKER, for example:

 

OBJECTSTORE_SERVICE_BROKER (node 0) KB
—————————————- ———-
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 55028152   –near  52GB

 

Then we can use a dmv to check the detailed usage under this object store, identify if it is used on the part