High Compilers

Bright Light City

If you’re here, you most likely have a plan in your cache that uses a lot of resources to compile.

By itself, this isn’t a very interesting or actionable metric, but if you add in some other stuff, you can find interesting problems.

If plans like this compile or recompile frequently, you could be using a whole lot of server power just coming up with query plans.

If you’re seeing warnings from sp_Blitz or sp_BlitzFirst about RESOURCE_SEMAPHORE_QUERY_COMPILE, you could have queries sitting around waiting for memory just to create a plan.

Fixing the problem has lots of different possible solutions: forced parameterization, parameterized dynamic SQL, removing recompile hints, breaking queries up into smaller pieces, or even using plan guides or plan stability hints.