mssql锁表解除
来源:互联网 发布:在线域名查询 编辑:程序博客网 时间:2024/05/24 15:39
-- 查看锁状态select spid, blocked, loginame, last_batch, status, cmd, hostname, program_name from sys.sysprocesses where spid in (select blocked from sys.sysprocesses where blocked <> 0) or (blocked <> 0)-- 终止进程 declare @spid int Set @spid = 83 --锁表进程 declare @sql varchar(1000) set @sql='kill '+cast(@spid as varchar) exec(@sql)
-- 查看语句-正在执行
SELECT [Spid] = session_id , ecid , [Database] = DB_NAME(sp.dbid) , [User] = nt_username , [Status] = er.status , [Wait] = wait_type , [Individual Query] = SUBSTRING(qt.text, er.statement_start_offset / 2, ( CASE WHEN er.statement_end_offset = -1 THEN LEN(CONVERT(NVARCHAR(MAX), qt.text)) * 2 ELSE er.statement_end_offset END - er.statement_start_offset ) / 2) , [Parent Query] = qt.text , Program = program_name , hostname , nt_domain , start_time FROM sys.dm_exec_requests er INNER JOIN sys.sysprocesses sp ON er.session_id = sp.spid CROSS APPLY sys.dm_exec_sql_text(er.sql_handle) AS qt WHERE session_id > 50 -- Ignore system spids. AND session_id NOT IN ( @@SPID ) -- Ignore this current statement.ORDER BY 1 , 2-- 查看语句执行过信息
select * from sys.sysprocesses where spid in (select blocked from sys.sysprocesses where blocked <> 0) or (blocked <> 0) ;SELECT TOP 1000 ST.text AS '执行的SQL语句', QS.execution_count AS '执行次数', QS.total_elapsed_time AS '耗时', QS.total_logical_reads AS '逻辑读取次数', QS.total_logical_writes AS '逻辑写入次数', QS.total_physical_reads AS '物理读取次数', QS.creation_time AS '执行时间' , QS.*FROM sys.dm_exec_query_stats QS CROSS APPLY sys.dm_exec_sql_text(QS.sql_handle) STWHERE QS.creation_time BETWEEN '2016-08-05 15:00:00' AND '2016-08-05 17:00:00' ORDER BY QS.total_elapsed_time DESC
0 0
- mssql锁表解除
- oracle锁表解除
- oracle锁表解除
- oracle锁表解除
- MSSQL中查表锁定与表解锁
- 表解锁
- [mssql]字符串移除指定长度字符
- [MSSQL]字符串移除指定长度字符
- oracle 锁表解锁
- mysql 锁表解锁
- Oracle 锁表解锁
- plsql锁表解锁
- oracle 锁表解锁
- mysql锁表解锁
- 如何将中被锁表解锁
- SQL表解锁步骤
- [oracle]: 表解锁
- oracle 表解锁
- CPU在内核中的位图表示
- hdu 1846 Brave Game (巴什博弈)
- 小飞鱼软件 大型生产企业设备档案管理系统介绍(图文)
- background 属性 个人心得
- 自定义View—弹性滑动
- mssql锁表解除
- 把控件设置到window 上
- 考虑载波和采样频率的2PSK调制 MATLAB仿真
- 学位到底有多重要
- javascript——实现继承的6种方式
- 混合结构
- rsync命令的使用
- 【经典优先队列例题整理】
- 手机浏览器上下滚动翻页效果