[Info-vax] Lock rates

abrsvc dansabrservices at yahoo.com
Mon Nov 9 14:28:27 EST 2020


On Monday, 9 November 2020 14:17:25 UTC-5, Rod Regier  wrote:
> Just confirming that on a non-cluster node w/proper AUTOGEN tuning that
> I don't need to worry about large lock rates that appear in concert with large direct I/O rates.

Lock rates can be large if the application itself does not use them efficiently or there are multiple updates to singular records from many sources.  Try to understand where the locking is coming from and why rather than looking just at the rates.



More information about the Info-vax mailing list