Reducing Redo Copy latch contention in 7.3 NT server
From: Casey Husar <chusar_at_empirical.com>
Date: 1997/02/07
Message-ID: <32FB59D2.7762_at_empirical.com>#1/1
Date: 1997/02/07
Message-ID: <32FB59D2.7762_at_empirical.com>#1/1
I am running an NT 7.3 server and am only getting a .014 hit ratio on my Redo copy latch. I have already increased the log_simultaneous_copies to 2*cpu's (4). According to the book, I should next set log_entry_prebuild_threshold. Only one problem, this parameter doesn't seem to exist on my database. Any suggestions would be greatly appreciated.
Thanks in advance. Received on Fri Feb 07 1997 - 00:00:00 CET