AXISHK
asked on
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 ?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Run 'sp_who" and 'sp_who2' but I can't find the 'blocked" or 'blocked by" column. Do I make something wrong ?
Tks
Tks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Tks
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.