| Subject | Re: High "Mutex wait" value, after increase in "Hash Slots" to 90001 |
|---|---|
| Author | Dmitry Yemanov |
| Post date | 2017-03-12T04:58:32Z |
12.03.2017 00:12, 'Leyne, Sean' wrote:
could be completely unrelated to the lock manager (e.g. bad plans,
undesired access to MON$ tables inside triggers, whatever else).
Dmitry
>Yes. But we're still guessing in the dark, the reason of the slowdown
> 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?
could be completely unrelated to the lock manager (e.g. bad plans,
undesired access to MON$ tables inside triggers, whatever else).
Dmitry