TriCore Blog SQL SERVER RESOURCE BOTTLENECK – CPU -The first in a four part series.

Posted By: Vikas Agarwal When you fire a query, the SQL optimizer decides the best execution plan after considering the cost effectiveness.. [Re]Compilation is CPU Intensive and to leverage the system resources SQL stores the recently used execution plan in the system memory.