ENQ and DEQ rates

[Gesmundo]

We have a cluster of 7 Itanium blade servers running OpenVMS 8.3-1H1.

We observed local lock conversion of around 10500 at one time and another around 340000 on the active node. using the T4 data.

I believe that the rates are site specific but what are the "normal" lock rates (lock conversions, ENQ, and DEQs)? What values should we be vigilant?

Thanks.

Noel

[abrsvc]

A lot of this will depend on how you are using locks. With one environment here, I see locking rates exceed 10000 on occassion on an Alpha DS10 without any appearance of a performance problem. Knowing the application, this is normal and only happens under certain conditions.

There is no majic number at which the rate would be considered excessive. It all depends upon your environment. If you are seeing transaction delays coincide with these high locking rates, perhaps a review of the application and how locks are used would be in order.

Hope this helps a bit,,,

Dan

[Hein van den Heuvel]

10,000 is nothing to worry about.

100,000 you want to  make sure that it is inat reasonable relation to the work performed.

FOr example, when processing an aggregate 20,000 records/sec in an share RMS file it would be fine.

340,000 probably means you are maxed out/bottlenecked.

Details investigation is in order.

Use ANALYZE/SYSTEM extension to see the top locks.

What is the main database used? Main access? Version?

Good luck!

Hein

[Gesmundo]

Thanks for the replies.

The cluster is using RDB V7.2.

I looked at the T4 graphs for the other days and I can see spikes of more than 100,000 local conversions but not consistent to specific times.

We were trying to relate the reported slow response to ENQs and DEQs but the graphs show otherwise.

Thanks again.