To reserve a cache for use by only the transaction log, change the cache’s type to “logonly.” This example creates the cache pubs_log with the type “logonly:”
sp_cacheconfig pubs_log, "7M", "logonly"
This shows the state of the cache before a restart:
Cache Name Status Type Config Value Run Value ------------------- --------- -------- ------------ ------------ pubs_log Pend/Act Log Only 7.00 Mb 0.00 Mb ------------ ------------ Total 7.00 Mb 0.00 Mb
You can change the type of an existing “mixed” cache, as long as no non-log objects are bound to it:
sp_cacheconfig pubtune_cache, logonly
In high-transaction environments, Adaptive Server usually performs best if you allocate two logical pages to the transaction logs. For larger page sizes (4, 8, and 16K) use sp_sysmon to find the optimum configuration for your site. For information on configuring caches for improved log performance, see “Matching log I/O Size for log caches”.
