What is SQL Memory - Procedure Cache Size value
The Procedure Cache Size" value shown in Megabytes says how much memory currently allocated for storing SQL execution plans. When identifying bottlenecks in SQL Server DB performance, the "Procedure Cache Hit Rate" value can be much more informative. It shows percentage of execution plans found in cache matched to executed SQL statements. The higher value, the less recompiles required, and as a result less CPU resources used.
