Hello:

I have an .NET application that has stored procedures in SQL and is
interchanging information with AS400, bringing transactions that I use to
update an inventory master and sending transactions to a table in AS400 (I
am processing this trough schedule DTS packages). These packages have the
connection to AS400 and my SQLOLEB related to my server. The system
receives many transacations on line that affect my inventory master. I was
experiencing many deadlock, because I guess the packages was taking most of
the processor, so the other process were victims of the deadlock, so I
change the isolation level of my packages to CHAOS. I wanna be sure that
this isolation level it's not gonna causing problems to my system.

Thanks,



Thanks

SQL Server does not support the CHAOS isolation level.

You should really troubleshoot the deadlocks.

You can enable traceflags to give you more information as well as use SQL
Server profiler.

There is some good information here for deadlocks

http://search.microsoft.com/search/r...=0&s=1&s wc=0

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


"Gina L. Hernandez" <pdwhitt (AT) nospam (DOT) wdsinc.com> wrote

Hi Allan:

SQL does not support this level, but my provider does SQLOLE PROVIDER.



"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

I am not sure then how that would translate to SQL Server as SQL Server does
not support it.

As I said in my previous mail your main focus should be to look at WHY you
are having deadlocks and address those issues first.

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


"Gina L. Hernandez" <pdwhitt (AT) nospam (DOT) wdsinc.com> wrote