Hi, I'm no SQL Server expert ;) But you do have a snapshot functionnality that may be the source of your problems. Disabling or at least having it tuned could also benefit the whole application. You can use "WITH NOLOCK" with your select statement to force it at run time.
You have the equivalent in AR System configuration with "Select-Query-Hint: NOLOCK" in ar.cfg, see configuration guide. HTH On Mon, Oct 8, 2012 at 4:51 PM, Richter, Howard (CEI - Atlanta) <[email protected]> wrote: > > ** > > 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 > > Howard Richter, Remedy Administrator > > 6205 Peachtree Dunwoody Road, Atlanta, GA 30328-4524 > > Email = [email protected] > > Office = 678.645.4633, Cell = 404.226.2745 > > Cox Innovation Agent (CIA) > > 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 ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
