I am designing a monitoring program using HP Sitescope SIS.

The goal is detect deadlocks.

In doing so, I created a deadlock on an existing but nearly unused SQL Server 2008.

I used the following link: http://panigorthi.blogspot.com/2012/01/how-to-create-deadlock-in-sql-server.html

Now the query has been running for over 23 hours. Would you then say the SQL Server cannot detect the deadlock?

How can I create a deadlock it can detect and kill?

What is an example output in the ERRORLOG when the deadlock is resolved?

  • You'll know the deadlock is detected because an error will be returned to whichever session is chosen as the deadlock victim. Deadlocks are typically detected immediately, 23+ hours indicates you have not created a deadlock. Did you follow the directions in the blog precisely? – Hannah Vernon Mar 28 '13 at 15:28

Here is a link I read awhile back about retrieving deadlock information via extended events.

My guess is that if your query is still running then you have blocking not a deadlock. Are you sure you went back to session 1 and ran the additional update statement?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.