1748178 Members
4142 Online
108758 Solutions
New Discussion

ENQ and DEQ rates

 
Gesmundo
Advisor

ENQ and DEQ rates

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

3 REPLIES 3
abrsvc
Respected Contributor

Re: ENQ and DEQ rates

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
Honored Contributor

Re: ENQ and DEQ rates

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
Advisor

Re: ENQ and DEQ rates

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.