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 |
Because cached statements are transformed into lightweight stored procedures, statement caching requires additional open object descriptors.