SQLServer模拟死锁以及查询死锁进程和表

1、连接SQLServer

2、新建一个查询框

3、创建2个表：CREATE TABLE Lock1(C1 int default(0));觊皱筠桡CREATE TABLE Lock2(C1 int default(0));INSERT INTO Lock1 VALUES(1);INSERT INTO Lock2 VALUES(1);

4、继续新建一个文件执行：Begin Tran Update Lock2 Set C1=C1+1; WaitFor Delay '00:00:30'; SELECT * FROM Lock1Rollback Tran;

5、再新增一个文件执行：Begin Tran Update Lock1 Set C1=C1+1; WaitFor Delay '00:00:30'; SELECT * FROM Lock2Rollback Tran;

6、这样就能模拟死锁报错了

7、然后通过这个SQL查报错的表和进程：SELECT request_session_id spid, OBJECT_NAME( resource_associated_entity_id )tableName FROM sys.dm_tran_locks WHERE resource_type = 'OBJECT'