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 |
The statement cache size parameter increases the server allocation of procedure cache memory and limits the amount of memory from the procedure cache pool used for cached statements. The statement cache feature is enabled server-wide:
statement cache size size_of_cache
You must configure set chained on/off in
its own batch if you enable the statement cache.
Because cached statements are transformed into lightweight stored procedures, statement caching requires additional open object descriptors
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
