Subject Re: High "Mutex wait" value, after increase in "Hash Slots" to 90001
Author Dmitry Yemanov
12.03.2017 00:12, 'Leyne, Sean' wrote:
> Am I right to think that I need to create a process to run the command on a regular basis (every 5 secs?) to find what objects locks are waiting for?

Yes. But we're still guessing in the dark, the reason of the slowdown
could be completely unrelated to the lock manager (e.g. bad plans,
undesired access to MON$ tables inside triggers, whatever else).