Hello Andres, Do you have both, longrunning transactions and transactions with many > subtransactions? > > Yes long running plane SQL queries as well as many short SQL queries running one after another in one long spanning transaction (we are working on eliminating this kind of behavior, but it is some of the analysis tools opening a transaction and then fetching lots of data with small queries).
Also many relatively short running calls (up to 500ms) to quite complicated read-only stored procedures is being done constantly on that machine. Regards, -- Valentine
