statement cache size

statement cache size increases the server allocation of procedure cache memory and limits the amount of memory from the procedure cache pool used for cached statements.

Summary Information

Default value

0

Valid values

Size of cache in 2K pages

Status

Dynamic

Display level

Comprehensive

Required role

System administrator

Configuration groups

Memory Use, SQL Server Administration

Note: If you enable the statement cache, you must configure set chained on/off in its own batch.

Because cached statements are transformed into lightweight stored procedures, statement caching requires additional open object descriptors.