Re: No Lock Setting on AR CFG

2012-12-18 Thread ravi rai
. Ravi Date: Mon, 17 Dec 2012 22:31:08 -0500 From: gupta.bhupesh3...@gmail.com Subject: Re: No Lock Setting on AR CFG To: arslist@ARSLIST.ORG Hi Ravi - Is that issue resolved, beacuse I have laready has Is commited read and Allow snalp shot islotation to ON. Regards, Bhupesh

Re: No Lock Setting on AR CFG

2012-12-18 Thread Bhupesh Gupta
Hi Ravi - Few Queries, When Blocking occurs , how much DB CPU is? is it greater than 80%. What queries are blcking, please share. What are number of threads for the same. Once this issue is resolved at your end, please let me know, whay was the exact resolution. Regards, Bhupesh

Re: No Lock Setting on AR CFG

2012-12-17 Thread Bhupesh Gupta
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

Re: No Lock Setting on AR CFG

2012-12-17 Thread ravi rai
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

Re: No Lock Setting on AR CFG

2012-12-17 Thread Bhupesh Gupta
Hi Ravi - Is that issue resolved, beacuse I have laready has Is commited read and Allow snalp shot islotation to ON. Regards, Bhupesh ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are,

Re: No Lock Setting on AR CFG

2012-11-02 Thread Longwing, LJ CTR MDA/IC
than your accuracy. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of ravi rai Sent: Thursday, November 01, 2012 2:47 PM To: arslist@ARSLIST.ORG Subject: No Lock Setting on AR CFG ** Hi, We are getting few DB lock cases

Re: No Lock Setting on AR CFG

2012-11-02 Thread ravi rai
Thanks LJ Regards Ravi Rai Date: Fri, 2 Nov 2012 06:42:27 -0600 From: lj.longwing@mda.mil Subject: Re: No Lock Setting on AR CFG To: arslist@ARSLIST.ORG Ravi, As you may remember, at Level3 we needed to use the NOLOCK hint on a lot of our processes, and even included

No Lock Setting on AR CFG

2012-11-01 Thread ravi rai
Hi, We are getting few DB lock cases and planning to implement READ-COMMITTED_SNAPSHOT and ALLOW_SNAPSHOT_ISOLATION (Long term) There was a recent thread on NO Lock in Ar.cfg. Planning to add No Lock for short term What impact it has on performance of the system. Anyone implemented it faced