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.