Mary, I did some extensive research on the Next-ID-Block size setting in 7.5 a couple years ago. That research involved formal performance testing and conversations with BMC Engineers about the results I found.
The results were that it didn't help. In fact, performance was actually diminished in over half of the cases. Maybe that was due to unrelated traffic, but at very least I can say that there was no noticeable improvement with the settings at anything above 1. The word from BMC when this feature was released was that it was in response to multiple Network Management applications (i.e. Patrol, Netcool, HP, Tivoli, etc.) feeding large number of records into the same form on the same AR Server at the same time. This caused contention for SQL pulls of the Entry ID, which was causing performance issues. The problem is that BMC, for some reason, is recommending increasing that number to something above 1 as a default setting, without apparent justification for that recommendation. I have seen nothing that has changed the justification for the setting beyond the initial requirement. I have seen nothing to indicate that either the function or the rationale have changed in 7.6x. So if you have MULTIPLE NM apps feeding the SAME form at the SAME time with LOTS of records (thousands/day), then yes, you should increase the setting for THAT form to a higher number. If you are not, then you shouldn't. The cost is far greater than any benefit you might see. Rick On Tue, Sep 11, 2012 at 9:27 AM, Mary Dollus <[email protected]> wrote: > Hi Everyone, > > We are going to set our Next ID Block size from 1 to 25 due to some issues > we had last week with our AR System Email Messages form tying up the system. > > We did some initial testing and it seems like there shouldn't be any > issues. Is there in anything particular we need to look out for? > > Has anyone noticed any gaps in the Request ID sequencing and if so, to > what extent? > > What is your environment if you noticed issues? Do you use a server > group? and what was the value of your Next ID Block size? > > Thanks so much in advance!! > Mary Dollus > ARS 7.6.04 > Oracle/UNIX > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
