@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
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
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
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
: 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
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
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
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
8 matches
Mail list logo