Turn resource manager off
Mladen Gogala, July 01, 2025 - 9:15 pm UTC
Don't bother checking, resource manager plan is a complex monstrosity which can be turned off easily. Most of the DBAs configure this only once and never again. The documentation is hard to read and plan directives are complex and confusing. Turn off the resource manager and the wait event will go away.
Also, make sure that you turn off concurrent statistics collection because it will not work without the resource manager.
July 09, 2025 - 6:51 am UTC
Turn off the resource manager and the wait event will go away.
and there's a good chance something else way worse might pop up, because if you are truly short on server resources, then that's a nice way to have your instance start misbehaving or crash altogether due to CPU starvation