SQL 2005 Deadlocks
In an asp.net application that I work on I wrote the data access layer
with try - catch on every call to the database and in the catch phrase i
log any errors that occur. I also write most of the stored procedure code
and all the select statements are using the nolock hint. Some of these
select statements are getting numerous but not always deadlock errors like
the following "Transaction (Process ID 86) was deadlocked on lock
resources with another process and has been chosen as the deadlock victim.
Rerun the transaction." I need to know a process to discover what other
process is that the error message is referring to. Any help appreciated -
thank you.
No comments:
Post a Comment