当前位置: 代码迷 >> Sql Server >> 数据库。小白求教
  详细解决方案

数据库。小白求教

热度:12   发布时间:2016-04-25 00:36:41.0
数据库高手进。小白求教
使用的SQL数据库,允许很慢。使用网上的方法查看堵塞情况。
sp_lock

查询结构后。

326 5 1082655846 5 KEY (500237c460c5)                   U GRANT
326 5 1082655846 1 KEY (2a0184b096e7)                   U GRANT
326 5 1082655846 5 KEY (50029d3c820e)                   U GRANT
326 5 1082655846 1 KEY (bb013850858c)                   U GRANT
326 5 1082655846 1 KEY (bc016a138f39)                   U GRANT
326 5 1082655846 1 KEY (b4010083c67f)                   U GRANT
326 5 1082655846 1 KEY (b30152c0ccca)                   U GRANT
326 5 1082655846 1 KEY (ba0137af791b)                   U GRANT
326 5 1082655846 5 KEY (3802306291a3)                   U GRANT
326 5 1082655846 1 KEY (b201424cfcac)                   U GRANT
326 5 1082655846 1 KEY (b90126d38a9a)                   U GRANT
326 5 1082655846 1 KEY (b501229ba6fb)                   U GRANT
326 5 1082655846 1 KEY (c901516e0fac)                   U GRANT
326 5 1082655846 1 KEY (b6017c351c3d)                   U GRANT
326 5 1082655846 5 KEY (a9015c692dd4)                   U GRANT
326 5 1082655846 1 KEY (b901d3b71997)                   U GRANT
326 2 13 1 KEY (070074380aeb)                   X GRANT
326 5 1082655846 5 KEY (4f026dde1705)                   U GRANT
326 5 1082655846 5 KEY (ac01f6ac3e0f)                   U GRANT
326 5 1082655846 1 KEY (b40155bd3e1f)                   U GRANT
326 5 1082655846 1 KEY (bb01777b295c)                   U GRANT
326 5 1082655846 5 KEY (5002faadc63c)                   U GRANT
326 5 1082655846 1 KEY (ba018d1dbc6d)                   U GRANT
326 5 1082655846 5 KEY (af01e7692600)                   U GRANT
326 5 1082655846 1 KEY (b501b5ceff9e)                   U GRANT
  相关解决方案