SQL Server 2008 Deadlock

How to identify dead lock in SQL 2008 ? How do I know whether a dead lock occur in production environment ? Will the SQL server slow down the performance ?
AXISHKAsked:
Who is Participating?
 
mike706Connect With a Mentor Commented:
It should look something like this.
sp_who2
sp-who2.jpg
0
 
Koen Van WielinkConnect With a Mentor Business Intelligence SpecialistCommented:
Try running the SP_WHO and SP_WHO2 stored procedures. They will show you blocked and blocked by columns that correspond with a session ID. Look up the session ID to see who is locking the database.
0
 
mike706Commented:
You can also use the activity monitor to see this information.

You can find more information about deadlocks here http://technet.microsoft.com/en-us/library/ms177433%28v=sql.105%29.aspx

Deadlocks are a performance problem because they can prevent 2 or more processes from being able to process data.  A deadlock chain can occur and impact hundreds of spids based on the data access patterns, number of users, object dependencies, etc.
0
 
AXISHKAuthor Commented:
Run 'sp_who" and 'sp_who2' but I can't find the 'blocked" or 'blocked  by" column.  Do I make something wrong ?

Tks
0
 
AXISHKAuthor Commented:
Tks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.