Unfortunately I didn't have sa rights to check on that. But I'm almost certain that there were no other processes read or otherwise connected to it. It's something I would need to verify though with their DBA's on return to the site as he is unavailable for a couple of days after the new year and I don't believe there is anyone else shadowing him on his absence..
Joe _____ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Jason Miller Sent: Wednesday, January 02, 2013 3:05 PM To: arslist@ARSLIST.ORG Subject: Re: Configuration tasks to avoid deadlocks on MS-SQL 2008... ** Not only Remedy but other SQL activity on the ARSystem DB will cause SET READ_COMMITED_SNAPSHOT ON to wait. You may have to kill a few processes. On Wed, Jan 2, 2013 at 7:28 AM, Longwing, LJ CTR MDA/IC <lj.longwing....@mda.mil> wrote: Joe, Remedy can't be running when you execute that one...so, shut it down if you didn't already. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe D'Souza Sent: Monday, December 31, 2012 4:54 AM To: arslist@ARSLIST.ORG Subject: Re: Configuration tasks to avoid deadlocks on MS-SQL 2008... ** Ignore this request.. I found the documentation. Now only if I could get one of the queries to actually complete execution! I think something is wrong with it as its taking forever to execute it.. Over 5 hours now. And I do not recall it ever taking over 2 seconds to complete.. The one that seems to be 'stuck' is ALTER DATABASE ARSystem SET READ_COMMITED_SNAPSHOT ON; Its 5 hrs 17 minutes now and still displaying Executing query in the status bar.. Has anyone had trouble with this one before? Joe ________________________________ From: Joe D'Souza [mailto:jdso...@shyle.net] Sent: Monday, December 31, 2012 1:22 AM To: ARS Discussion List Subject: Configuration tasks to avoid deadlocks on MS-SQL 2008... How do you implement the NOLOCK configuration on an MS-SQL database? I recall doing this in the past, using hints on the installation document of the AR System server. But I can't seem to be able to find the installation document. This is the prompt that you get when installing AR System 7.6.04, which requires the DB to be set to NOLOCK.. When installing or upgrading on Microsoft SQL Server 2005 or higher, Microsoft recommends that you perform additional configuration tasks to avoid deadlocks. Please refer to the AR System Installation Guide in the "Additional Procedure for preparing a SQL Server database" for more information. Any help on this will be appreciated. Joe _ARSlist: "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" _ARSlist: "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"
