| How to simulate deadlock for test purpose |
|
|
|
|
Simulating Deadlock for test purpose is simple, can be achieved by updating 2 tables with a delay in one query window & the reverse update in the second query window as shown below. Query Create table TableA(id int,name varchar(50)) Insert into TableA values(1,'krishna')
--Enter in secondquery window You can see the deadlock issue happened in the second query windows as shown below.
Server: Msg 1205, Level 13, State 50, Line 1
Comments (43)
Powered by !JoomlaComment 4.0 beta2
|


