Use the Database Properties wizard to modify the transaction log cache and the log I/O buffer size.
Change the size of the transaction log cache and log I/O buffer by binding the log to a cache of different size. The log buffer size determines the number of I/O transactions that can be stored in the transaction log I/O cache.
- In the left pane of the Administration Console, expand .
- Select one of:
- User Databases
- System Databases
- Temporary Databases
- Proxy Databases
- Click the Name field of the database, then click the drop-down arrow and select
Properties.
- Click Transaction Log.
You see the list of caches; the highlighted cache is the one currently configured for your database I/O buffer.
- Select a different cache and click Apply.