In the case of Alkan, the Next Request ID Block Size would need to be set for the entire AR System, since he does not know what form(s) are causing contention on the ARSCHEMA table. The Next Request ID Block Size cannot be set for the arschema, as you know.
The arschema has been a signficant contention hot spot in the past, for pretty much any Remedy environment, until the Next Request ID Block Size feature was introduced. Just ask any DBA that monitors a Remedy database to find contention hot spots. ________________________________ From: Action Request System discussion list(ARSList) [[email protected]] on behalf of Rick Cook [[email protected]] Sent: Wednesday, June 08, 2011 1:27 PM To: [email protected] Subject: Re: Looooooooooong update times on ARSCHEMA ** What I think we have is some confusion in terms. While the nextId value for each form is stored in the arschema table for each form, there isn't any need (I would argue that it would be counterproductive) to have that value set at anything greater than zero FOR the arschema form itself. Since he reported issue wasn't with any form except arschema, and since the only time a nextId is requested for that form is when a new form is created, I fail to see the connection between your solution and the reported problem. Now if you had suggested adding a db index to the arschema table, I could see the potential for performance improvements. Rick On Jun 8, 2011 12:13 PM, "Guillaume Rheault" <[email protected]<mailto:[email protected]>> wrote: > Well, contention on the ARSCHEMA table affects all tables related to Remedy > forms, since as you know the ARSCHEMA table stores the nextId for any Remedy > form, and this table is updated and queried constantly. It therefore can > frequently become a contention hot spot. > > Since the Remedy admin does not have control over the locking mechanisms on > the table for insert, update or queries, then the only thing that can be done > at the Remedy level is to set the Next Request ID Block Size. > > Guillaume > > ________________________________ > From: Action Request System discussion list(ARSList) [<a href="mai_attend > WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are?_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
