sqlserver 查询分析

 

--存放有关在 Microsoft SQL Server 实例中运行的进程的信息

SELECT * FROM master.dbo.sysprocesses WHERE dbid IN

(

SELECT dbid FROM master.dbo.sysdatabases

WHERE NAME='BPMDB'

)

 

--根据hotProcess 查询正在运行的语句

SELECT at.text,sp.*  FROM[Master].[dbo].[SYSPROCESSES] sp

CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS at

WHERE hostprocess=2300