Re: DEADLOCKS
From: Greg Linwood (g_linwoodQhotmail.com)
Date: 07/14/04
- Next message: --CELKO--: "Re: Hierarchic tables in Queries ??"
- Previous message: Greg Linwood: "Re: uniqueidentifier column"
- In reply to: Gina L. Hernandez: "DEADLOCKS"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 14 Jul 2004 14:50:35 +1000
Hi Gina
Are you controlling transactions in the web layer .net code or in SQL Server
TSQL code?
If you're doing it in the .net code, make sure you set the transaction
isolation level to the lowest acceptable level to support your intended
transactional semmantics. This usually means setting it to Read Uncommitted.
Regards,
Greg Linwood
SQL Server MVP
"Gina L. Hernandez" <pdwhitt@nospam.wdsinc.com> wrote in message
news:esDGuwRaEHA.3704@TK2MSFTNGP09.phx.gbl...
> Hello :
>
> I have a table called invmstr, and my WEB-SYSTEM written in VISUAL.NET and
> ASP.NET and SQLSERVER, is giving me a lot of deadlocks because all my
users
> are trying to update, write or delete this table. What should I set in
> the database or in my stored procedures to avoid this deadlocks?
>
>
>
> Thanks,
>
>
>
> Gina
>
>
>
>
>
>
>
>
- Next message: --CELKO--: "Re: Hierarchic tables in Queries ??"
- Previous message: Greg Linwood: "Re: uniqueidentifier column"
- In reply to: Gina L. Hernandez: "DEADLOCKS"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
