通过sys.sysprocesses查询线程来源

SELECT hostname,loginame,* FROM sys.sysprocesses;

SELECT count(*),hostname FROM sys.sysprocesses where cmd='AWAITING COMMAND' group by hostname;

SELECT count(*),hostname,loginame FROM sys.sysprocesses where cmd='AWAITING COMMAND' group by hostname,loginame;

SELECT hostname,loginame,* FROM sys.sysprocesses;

DBCC INPUTBUFFER(@@spid)
【推广】 免费学中医，健康全家人
原文地址：https://www.cnblogs.com/dennysong/p/5703740.html