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 |
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.
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.
