sqlserver内存、会话、连接查询

1、连接查询

select * from sysprocesses where dbid in (select dbid from sysdatabases where name='dbname')

–或者

SELECT * FROM
[Master].[dbo].[SYSPROCESSES] WHERE [DBID] IN ( SELECT 
   [DBID]
FROM 
   [Master].[dbo].[SYSDATABASES]
WHERE 
   NAME='dbname'
)

2、当前正在执行的sql查询

SELECT  [Spid] = session_id ,
            ecid ,
            [Database] = DB_NAME(sp.dbid) ,