Thursday, November 1, 2007

How to simulate a deadlock for testing purposes?

How to simulate a deadlock for testing purposes?
In Query Analyzer, run the following statements first:
CREATE TABLE t1 (i int)CREATE TABLE t2 (i int)
INSERT t1 SELECT 1INSERT t2 SELECT 9
Open a new window (say Window1) in Query Analyzer, paste the following SQL statements:
BEGIN TRANUPDATE t1 SET i = 11 WHERE i = 1WAITFOR DELAY '00:00:20'UPDATE t2 SET i = 99 WHERE i = 9COMMIT
Open another window (say Window2) in Query Analyzer and paste the following code:
BEGIN TRANUPDATE t2 SET i = 99 WHERE i = 9WAITFOR DELAY '00:00:20'UPDATE t1 SET i = 11 WHERE i = 1COMMIT
Now run the code from Window1, followed by Window2 simultaneously. Briefly after 20 seconds, one of the windows will experience a dead lock!

No comments: