SQL All Procs have WITH RECOMPLILE so how to maintain a bloated plan cache
0
votes
1
answer
78
views
I'm working a star schema data warehouse created in Azure SQL database where the last developer included
WITH RECOMPILE
on all the Procs.
This I believe was because the ETL only executes these Procs twice a day so the overhead of recompiles is minimal.
However, isn't there a risk of the cache becoming bloated with all those plans and if so, what's the best way to maintain the plan cache to keep it trim and as efficient as possible?
Asked by Geezer
(513 rep)
Aug 7, 2022, 03:51 PM
Last activity: Aug 7, 2022, 03:58 PM
Last activity: Aug 7, 2022, 03:58 PM