Statement Cache Sizing

Each cached statement requires approximately 1K memory in the statement cache, depending on the length of the SQL text.

Each cached plan requires at least 2K of memory in the procedure cache. To estimate the statement cache memory required, account for the following for each statement to be cached: