Re: ENQ and DEQ rates (481 Views)
Reply
Occasional Contributor
Gesmundo
Posts: 11
Registered: ‎08-06-2004
Message 1 of 4 (549 Views)

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

Trusted Contributor
abrsvc
Posts: 367
Registered: ‎06-08-2010
Message 2 of 4 (503 Views)

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
Honored Contributor
Hein van den Heuvel
Posts: 6,588
Registered: ‎05-19-2003
Message 3 of 4 (502 Views)

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

 

Occasional Contributor
Gesmundo
Posts: 11
Registered: ‎08-06-2004
Message 4 of 4 (481 Views)

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.

The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.