December 18, 2006 at 11:21 am
Hi everyone,
Since October 25 the Server Logs have indicated 25 transaction
deadlocks. The engine is running ok. Is this an indication of
an impending problem? If so where should I begin to look for the
source of a possibe problem? Thanks for eveyone being there to
help. SQL2000 SP4
December 18, 2006 at 12:44 pm
You have to look at what else is happening at the same time. Deadlocks usually mean that two transactions are trying to use the same resources at the same time.
-SQLBill
December 19, 2006 at 6:38 pm
This is very subjective. You need to consider the size of your db, the movement of data, the number of users, the number of concurrent connection, and a lot more.
In our case (the database is used by a popular web site), 25 deadlocks in 48hrs is very acceptable.
December 20, 2006 at 2:35 pm
Did you try to execute the following commands?
dbcc traceon(1204)
dbcc traceon(1205)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply