To reserve a cache for use by only the transaction log, change the cache’s type to “logonly.” The change is dynamic.
This example creates the cache pubs_log with the type “logonly:”
sp_cacheconfig pubs_log, "7M", "logonly"
This shows the initial state of the cache:
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 the default value is twice the server’s logical page size (for a server with 2K logical page size, it is 4K, for a server with 4K logical page size, it is 8K, and so on).. For larger page sizes (4, 8, and 16K) use sp_sysmon to find the optimum configuration for your site. See “Matching log I/O size for log caches”.
