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?