Re: No Lock Setting on AR CFG
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 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: No Lock Setting on AR CFG
Bhupesh,It is still in test server. Regarding you SRM issue check indexes and any Overlaid or Custom Workflow which is not using Indexed field in Runif QualWe are on ARS 7604 SP2 ITSM 7604 SP1 SQL Windows and we have around 1200,000+ record is SRM request are not having any issues with SRM. 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 > > ___ > 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"
Re: No Lock Setting on AR CFG
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, and have been for 20 years"
Re: No Lock Setting on AR CFG
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"
Re: No Lock Setting on AR CFG
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"
Re: No Lock Setting on AR CFG
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 it in the ar.cfg. The up side is that none > of your queries will ever be blocked due to locking at the row or table > level. The down side is that your queries could be considered 'dirty' > because your query MIGHT get data that is not yet committed to the DB, and > subsequently rolled back, so in effect the results returned may not be 100% > accurate, but in general I don't consider that to be too much of an issue. > For greater concurrence, not having NOLOCK could cause your queries to take > longer (waiting in line for inserts and updates to complete before returning > results), but for accuracy, NOLOCK could cause 'inaccurate' results. So, as > with everything in life, there are tradeoffs for everything you do, you just > need to determine if your performance means more 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 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 > any issues > > BMC suggested:NOLOCK should NOT be enabled - this is contrary to our guides, > but is the correct settings per BMC Performance and deployment teams > > Please suggest > > Thanks > Ravi Rai > > > _attend WWRUG12 www.wwrug.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" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Re: No Lock Setting on AR CFG
Ravi, As you may remember, at Level3 we needed to use the NOLOCK hint on a lot of our processes, and even included it in the ar.cfg. The up side is that none of your queries will ever be blocked due to locking at the row or table level. The down side is that your queries could be considered 'dirty' because your query MIGHT get data that is not yet committed to the DB, and subsequently rolled back, so in effect the results returned may not be 100% accurate, but in general I don't consider that to be too much of an issue. For greater concurrence, not having NOLOCK could cause your queries to take longer (waiting in line for inserts and updates to complete before returning results), but for accuracy, NOLOCK could cause 'inaccurate' results. So, as with everything in life, there are tradeoffs for everything you do, you just need to determine if your performance means more 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 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 any issues BMC suggested:NOLOCK should NOT be enabled - this is contrary to our guides, but is the correct settings per BMC Performance and deployment teams Please suggest Thanks Ravi Rai _attend WWRUG12 www.wwrug.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"
No Lock Setting on AR CFG
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 any issues BMC suggested:NOLOCK should NOT be enabled – this is contrary to our guides, but is the correct settings per BMC Performance and deployment teams Please suggest Thanks Ravi Rai ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"