For further tuning after configuring a cache for the log, check sp_sysmon output. Look at the output for:
The cache used by the log
The disk the log is stored on
The average number of writes per log page
When looking at the log cache section, check “Cache Hits” and “Cache Misses” to determine whether most of the pages needed for deferred operations, triggers, and rollbacks are being found in cache.
In the “Disk Activity Detail” section, look at the number of “Reads” performed to see how many times tasks that need to reread the log had to access the disk.
