New options that allow administrators to fine tune system performance are listed in this section.
In This Chapter
COMMIT_DELAY Value Modified for Windows Systems
Reduce Performance Impact of Dynamic Dump
Transaction Log Index ON by Default
RECOVER_MEMLOG for Faster Automatic Recovery with Advanced Encryption
Increased Scalability of Memory Suballocator Lists
Configurable Memory File Hash Bins
Improved Performance Using Unbuffered I/O on Windows Systems
Enable Unbuffered I/O for Transaction Logs
c-treeACE SQL Statement Cache Tuning Options
Support Critical Section Spin Count on Windows
Reader/Writer Lock Support for Enhanced Performance
TOCIndex