December 22, 2011 at 3:42 am
Hi ,
Will Dead locks occur when multiple insertions are happening in a sql table at the same time ?
Please provide the possible reasons for dead locks in sql server
Thanks,
Giri
December 22, 2011 at 3:53 am
Maybe. Depends on a whole lot of things, schema, indexes, code, isolation level.
To write a list of all things that cause deadlocks would take a week or two. In short, it's when two processes hold locks that the other process wants. So process A has a lock on resource 1, process B has a log on resource 2. Process A wants a lock on resource 2, process B wants a lock on resource 1. That's a deadlock.
Take a look at this, chapter 7: http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 22, 2011 at 4:00 am
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply