Hi,

During heavy load times I get the following contention (on ASE 12.5.0.3):

sp_object_stats "00:10:00"

Object Name: db..test (dbid=4, objid=572526042,
lockscheme=Datarows)

Row Locks SH_ROW UP_ROW EX_ROW
---------- ---------- ---------- ----------
Grants: 3490 12278 3024
Waits: 144 156 42
Deadlocks: 0 0 0
Wait-time: 293635 ms 2343482 ms 93041 ms

The vendor of the application says that this waiting time is ok, but in my opinion the application code is the reason for the bad performance. I have done different configuration changes on the server, but nothing really helped (around 25% improvement, but it's still slow).

Any idea what else might be the problem?

Many thanks!

Ulrike