Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
zaty2405
Yak Posting Veteran
58 Posts |
 Posted - 2010-07-01 : 04:54:41
|
| Hi,I run a profiler trace on my system to capture Deadlock graph.After 30 min, I have 200 deadlock XML events being generated.Where should I start? How do I resolve this deadlock issue?What is consider an acceptable num,ber of deadlock?Thanks |
|
|
namman
Constraint Violating Yak Guru
285 Posts |
Posted - 2010-07-07 : 13:08:00
|
| Where should I start? How do I resolve this deadlock issue?Analyze the cause of deadlocks, narrow down queries involve. Provide more info about XML events here, people can help you out.What is consider an acceptable num,ber of deadlock?When a deadlock occurs, at least 1 process will be terminated by the engine. So the number of acceptable deadlocks depends on how you tolarate the fail process in your application. For me, 200 deadlocks in 30 min is unacceptable. |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-07-07 : 13:33:43
|
| If you have READSs blocking WRITEs then setting the database to READ_COMMITTED_SNAPSHOT may be all you need to do. |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2010-07-07 : 14:24:25
|
| There are many strategies for analysing\dealing with deadlocks. Query analaysis and application analysis , will help you focus on the cause of the deadlock. Focus on transaction management and releasing resources as quickly as possibleJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2010-07-09 : 11:12:01
|
| Read thishttp://www.sqlteam.com/forums/topic.asp?TOPIC_ID=138686 |
|
|
|
|
|
|
deadlock issue