KILL SPID
KILL 83
if 1=1
SELECT r.scheduler_id as 排程器识别码,
status as 要求的状态,
r.session_id as SPID,
r.blocking_session_id as BlkBy,
substring(
ltrim(q.text),
r.statement_start_offset/2+1,
(CASE
WHEN r.statement_end_offset = -1
THEN LEN(CONVERT(nvarchar(MAX), q.text)) * 2
ELSE r.statement_end_offset
END - r.statement_start_offset)/2)
AS [query],
r.cpu_time as [CPU Time(ms)],
r.start_time as [开始时间],
r.total_elapsed_time as [执行总时间],
r.reads as [读取数],
r.writes as [写入数],
r.logical_reads as [逻辑读取数],
-- q.text, /* 完整的 T-SQL 指令码 */
d.name as [资料库名称]
FROM sys.dm_exec_requests r
CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS q
LEFT JOIN sys.databases d ON (r.database_id=d.database_id)
WHERE r.session_id > 50 AND r.session_id <> @@SPID
ORDER BY r.total_elapsed_time desc
if 1=1
begin
SELECT
'现在有什麽排程正在跑',run_requested_date,
datediff(minute, activity.run_requested_date, getdate()) AS Elapsed
,name x
,*
FROM msdb.dbo.sysjobs_view job
INNER JOIN msdb.dbo.sysjobactivity activity ON (job.job_id = activity.job_id)
WHERE
run_requested_date is not null
AND start_execution_date is not null
AND stop_execution_date is null
AND activity.session_id=(select max(session_id) from msdb.dbo.syssessions)
end
exec sp_context
sp_configure
sp_monitor
<<: Docker in docker .解决技术环境问题
>>: [Pytorch] torchvision.transforms()
对於组合语言,最大的迷思在於:「有了编译器,为什麽我还要学组合语言?」,关於学习组合语言的好处我认为...
透过昨天我们提到的路由,今天我们要实现登入後将token存入sessionStorage後转导到首页...
这是在找linked list资料看到harry xie大神文章提到的 里面是常见演算法的时间复杂度...
又来到预计会拆成上中下篇幅的大单元了!大家有看过游戏王吗?你们知道青眼白龙跟别人借钱会变成什麽吗?答...
GitHub Repo https://github.com/b2etw/Spring-Kotlin...