Next on the Menu - Why is that recompiling?

In this short SQL Snacks™  we will look at a question that arose while I was at a customer site. While running load tests we were seeing abnormally high numbers of recompiles vs. compiles. Knowing that this could lead to higher CPU consumption we investigated. Thanks to Forrest McDaniel @TSQLAddict for the basis of this SQL Snack™

Check out his blog at Forrest Shares

[video width="1620" height="1080" mp4="https://msdnshared.blob.core.windows.net/media/2018/08/Recompiles.mp4"][/video]