首页 > 数据库技术 > 详细

sqlserver check running process 1

时间:2020-02-16 22:12:31      阅读:58      评论:0      收藏:0      [点我收藏+]

check process script 1, check which is current running:

use master


SELECT
spid,ER.percent_complete,
CAST(((DATEDIFF(s,start_time,GetDate()))/3600) as varchar) + ‘ hour(s), ‘
+ CAST((DATEDIFF(s,start_time,GetDate())%3600)/60 as varchar) + ‘min, ‘
+ CAST((DATEDIFF(s,start_time,GetDate())%60) as varchar) + ‘ sec‘ as running_time,
CAST((estimated_completion_time/3600000) as varchar) + ‘ hour(s), ‘
+ CAST((estimated_completion_time %3600000)/60000 as varchar) + ‘min, ‘
+ CAST((estimated_completion_time %60000)/1000 as varchar) + ‘ sec‘ as est_time_to_go,
DATEADD(second,estimated_completion_time/1000, getdate()) as est_completion_time,
ER.command,ER.blocking_session_id, SP.DBID,LASTWAITTYPE,
DB_NAME(SP.DBID) AS DBNAME,
SUBSTRING(est.text, (ER.statement_start_offset/2)+1,
((CASE ER.statement_end_offset
WHEN -1 THEN DATALENGTH(est.text)
ELSE ER.statement_end_offset
END - ER.statement_start_offset)/2) + 1) AS QueryText,
TEXT,CPU,HOSTNAME,LOGIN_TIME,LOGINAME,
SP.status,PROGRAM_NAME,NT_DOMAIN, NT_USERNAME
FROM sysprocesses SP
INNER JOIN
sys.dm_exec_requests ER
ON SP.spid = ER.session_id
CROSS APPLY sys.dm_exec_sql_text(ER.sql_handle) est

技术分享图片

 

 

You see if there happen lock , you can see them  

After that you may execute "kill  xxx"

sqlserver check running process 1

原文:https://www.cnblogs.com/partition-liu/p/12317880.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!