Yesterday one of our SQL2019Std instances allocated over 70% of memory to the OBJECTSTORE_LOCK_MANAGER clerk, causing memory grant waits. No excessive locking seemed to be occurring, and we manually had to flush the clerk.
1. Should this clerk not have freed itself?
#sqlhelp
1/x
1
69