Re: Getting deadlock issue when querying data directly, from a MSSQL 2008 DB and on 7.6.4 ARserver

2012-10-09 Thread Hullule, Kiran
@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

Re: Getting deadlock issue when querying data directly, from a MSSQL 2008 DB and on 7.6.4 ARserver

2012-10-08 Thread Richter, Howard (CEI - Atlanta)
HCL-America Date: Mon, 8 Oct 2012 12:44:19 -0400 From: hbr4...@gmail.com<mailto: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<mailto:arslist@ARSLIS

Re: Getting deadlock issue when querying data directly, from a MSSQL 2008 DB and on 7.6.4 ARserver

2012-10-08 Thread ravi rai
Side Regards Ravi Rai Date: Mon, 8 Oct 2012 10:51:59 -0400 From: 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 ** Good morning, afternoon and evening all, Before we upg

Re: Getting deadlock issue when querying data directly, from a MSSQL 2008 DB and on 7.6.4 ARserver

2012-10-08 Thread Howard Richter
s > Ravi Rai > > Date: Mon, 8 Oct 2012 10:51:59 -0400 > From: 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 > > ** > Good morning, afternoon and evening a

Re: Getting deadlock issue when querying data directly, from a MSSQL 2008 DB and on 7.6.4 ARserver

2012-10-08 Thread ravi rai
: 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 ** 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

Re: Getting deadlock issue when querying data directly, from a MSSQL 2008 DB and on 7.6.4 ARserver

2012-10-08 Thread Longwing, LJ CTR MDA/IC
x27;s new. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Richter, Howard (CEI - Atlanta) Sent: Monday, October 08, 2012 8:52 AM To: arslist@ARSLIST.ORG Subject: Getting deadlock issue when querying data directly, from a

Re: Getting deadlock issue when querying data directly, from a MSSQL 2008 DB and on 7.6.4 ARserver

2012-10-08 Thread Sylvain YVON
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

Getting deadlock issue when querying data directly, from a MSSQL 2008 DB and on 7.6.4 ARserver

2012-10-08 Thread Richter, Howard (CEI - Atlanta)
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 us