Having set Snapshot Isolation Level and Read Committed Snapshot on db , you do NOT need to have Select-Query-Hint: NOLOCK in ar.cfg
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of ravi rai Sent: Monday, October 08, 2012 10:25 PM To: arslist@ARSLIST.ORG Subject: Re: Getting deadlock issue when querying data directly, from a MSSQL 2008 DB and on 7.6.4 ARserver ** Howard, ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT Turning on these help Read operations retrieve a consistent snapshot of the database. SELECT statements do not lock data during a read operation (readers do not block writers, and vice versa). SELECT statements can access the last committed value of the row, while other transactions update the row without being blocked. Fewer deadlocks and lock escalations occur. Fewer locks required by a transaction occur, which reduces the system overhead required to manage locks. Please refere the below white paper for othet Performance tuning options BMC Remedy AR System Server 7.6- Performance Tuning for Business Service Management Regards Ravi Rai Remedy Consultant HCL-America ________________________________ Date: Mon, 8 Oct 2012 12:44:19 -0400 From: hbr4...@gmail.com Subject: Re: Getting deadlock issue when querying data directly, from a MSSQL 2008 DB and on 7.6.4 ARserver To: arslist@ARSLIST.ORG ** Ravi, We are on SP3 of the ARserver and SP2 of ITSM. I have asked my DB to look at the two snapshot values you talked about. By the way what should they be to prevent this type of issue. Thanks again and take care, Howard Sent from one of Howard's iPads On Oct 8, 2012, at 11:29 AM, ravi rai <ravira...@hotmail.com<mailto:ravira...@hotmail.com>> wrote: ** Howard Which SP you are on 7604 Overview console 7604 default installation is single threaded causing perfomance issues. BMC has a hot fix for this. Also check SNAPSHOT ISOLATION and READ COMMIT SNAPSHOT value on DB Side Regards Ravi Rai ________________________________ Date: Mon, 8 Oct 2012 10:51:59 -0400 From: howard.rich...@coxinc.com<mailto:howard.rich...@coxinc.com> Subject: Getting deadlock issue when querying data directly, from a MSSQL 2008 DB and on 7.6.4 ARserver To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> ** Good morning, afternoon and evening all, Before we upgraded to 7.6.4 (ITSM and Arserver) we were on 7.5.6 and ITSM 7.6.1, and was able to query the MSSQL 2005 database directly, to pull some reporting data back. Since upgrading to 7.6.4 (ITSM and ARserver) and going to MSSQL 2008, when our user load is high we are getting deadlock issue when querying data directly. When the user load is low (like 3am) we have no issues. Any ideas? Take care, Howard <image001.gif><http://www.coxenterprises.com/> Howard Richter, Remedy Administrator 6205 Peachtree Dunwoody Road, Atlanta, GA 30328-4524 Email = howard.rich...@coxinc.com<mailto:howard.rich...@coxinc.com> Office = 678.645.4633, Cell = 404.226.2745 Cox Innovation Agent (CIA) <image002.png><image003.png><http://innovation.coxenterprises.com/ideas/Badge%20Library/Badge20-Lg.png><image004.png><http://innovation.coxenterprises.com/ideas/Badge%20Library/Badge50-Lg.png> Submit your idea today for a chance to earn a badge and be entered into a monthly drawing for a $10 gift card. Submit your idea: http://innovation.coxenterprises.com/ideas View your badges: http://innovation.coxenterprises.com/ideas/SitePages/yourbadges.aspx _attend WWRUG12 www.wwrug.com<http://www.wwrug.com/> ARSlist: "Where the Answers Are"_ _attend WWRUG12 www.wwrug.com<http://www.wwrug.com/> ARSlist: "Where the Answers Are"_ _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ _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"
