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" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
