Bhupesh,We did not implement the No Lock setting on Ar.cg We are implementing
BMC recommended DB setting related to PARAMETERIZATION ,
READ-COMMITTED_SNAPSHOT ,SNAPSHOT_ISOLATION etc...
Ravi
> Date: Mon, 17 Dec 2012 12:24:09 -0500
> From: gupta.bhupesh3...@gmail.com
> Subject: Re: No Lock Setting on AR CFG
> To: arslist@ARSLIST.ORG
>
> Hi Ravi - Can you please let me know the version of ARS and ITSM where you
> are facing this issue.. for one of our customer we are facing the same issue,
> there is one issue SRM form indexing that we have identified causing sql
> select queries to take longer time and was causing locks..
>
> Is the CPU od DB spiking to 100%?
>
> We are still working on it and BMC has also suggeasted to use No Lock
> Parameter.. but customer is yet to implemente the same..
>
>
> For more details on No Lock, please refer to Knowledge Article ID:
> KA314759.
>
> Hope this helps..
>
> Regards,
> Bhupesh
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> "Where the Answers Are, and have been for 20 years"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"
