Forum Discussion
Blocking due to recompile locks
I am seeing a lot of blocking with wait resource as OBJECT: n:zzz:0 [COMPILE] and TAB: n:zzz:0 [COMPILE] with a lot of RESOURCE_SEMAPHORE_QUERY_COMPILE waitstypes. This is causing a lot of CPU overh...
Most of this is still totally relevant to these issues: https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2012/dn148262(v=msdn.10)?redirectedfrom=MSDN
Will go over the document to understand the situation.
Can you also look at the below link https://techcommunity.microsoft.com/t5/sql-server/sql-2019-std-edition-high-recompilation-and-cpu-spike/m-p/3290396#M1563
This is also one issue that we are facing and the one reported here- 'Blocking due to recompile lock' is a part of it.
Let me know if you could add anything to it.
