[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.sqlserver.programming

Deadlock

frank

3/22/2007 8:29:00 PM

How would we find deadlock? What can we do to address it? is there any script

thanks
3 Answers

clay

3/22/2007 9:36:00 PM

0

Review your sql server logs around the time that the deadlock occurred
and it should tell you the two objects that were in conflict to cause
the deadlock. Here's some more info for you if you want to read about
them...

http://www.sql-server-performance.com/dea...

-Clay


On Mar 22, 1:29 pm, Frank <F...@discussions.microsoft.com> wrote:
> How would we find deadlock? What can we do to address it? is there any script
>
> thanks

AK

3/22/2007 9:56:00 PM

0

On Mar 22, 3:29 pm, Frank <F...@discussions.microsoft.com> wrote:
> How would we find deadlock? What can we do to address it? is there any script
>
> thanks

read this:

http://www.code-magazine.com/article.aspx?quickid=0309101&...

bob

3/23/2007 11:46:00 AM

0

The article 'Detecting and Ending Deadlocks ' in SQL2005 BOL is pretty good.
Plus there are the new Deadlock Graphs in Profiler. Run a custom profile
with only the deadlock events checked and you'll get a very informative chart.

wBob

"Frank" wrote:

> How would we find deadlock? What can we do to address it? is there any script
>
> thanks