Howard, When we performed the same upgrade, ironically from same app/db versions to same app/db versions, Part of the upgrade recommended running some commands to prevent deadlocks....did you by chance run those commands? You should be able to check the db guide for 7.6.04, or even the what's new.
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Richter, Howard (CEI - Atlanta) Sent: Monday, October 08, 2012 8:52 AM To: [email protected] Subject: Getting deadlock issue when querying data directly, from a MSSQL 2008 DB and on 7.6.4 ARserver ** 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 Description: Description: Description: Description: Cox Enterprises, Inc <http://www.coxenterprises.com/> Howard Richter, Remedy Administrator 6205 Peachtree Dunwoody Road, Atlanta, GA 30328-4524 Email = [email protected] <mailto:[email protected]> Office = 678.645.4633, Cell = 404.226.2745 Cox Innovation Agent (CIA) Description: Description: Description: http://innovation.coxenterprises.com/ideas/Badge%20Library/BadgeA-Md.pngDescription: Description: Description: http://innovation.coxenterprises.com/ideas/Badge%20Library/Badge20-Md.png <http://innovation.coxenterprises.com/ideas/Badge%20Library/Badge20-Lg.png> Description: Description: Description: http://innovation.coxenterprises.com/ideas/Badge%20Library/Badge50-Md.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 <http://innovation.coxenterprises.com/ideas> View your badges: http://innovation.coxenterprises.com/ideas/SitePages/yourbadges.aspx <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"
