Deadlocks problems

Hi everybody,
I have deadlocks problems, somebody could tell me how is the best way to
handle concurrency'
Thanks in advance,
RICHARD_SQLRichard (Richard@.discussions.microsoft.com) writes:
> I have deadlocks problems, somebody could tell me how is the best way to
> handle concurrency'
A very broad question, and far too broad to answer in a newsgroup.
Books Online has a section on troubleshooting deadlook. In Books Online for
SQL 2000, it's under Troubleshooting->Server and Database Troubleshooting->
Troubleshooting Deadlocks.
In Books Online for SQL 2005, the URL is
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/2018a963-2f83-492e-ae53-45af
e65025f7.htm
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||http://sql-server-performance.com/deadlocks.asp
Madhivanan
Erland Sommarskog wrote:
> Richard (Richard@.discussions.microsoft.com) writes:
> A very broad question, and far too broad to answer in a newsgroup.
> Books Online has a section on troubleshooting deadlook. In Books Online fo
r
> SQL 2000, it's under Troubleshooting->Server and Database Troubleshooting-
> Troubleshooting Deadlocks.
> In Books Online for SQL 2005, the URL is
> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/2018a963-2f83-492e-ae53-45
afe65025f7.htm
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/pr...oads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodin...ions/books.mspx