查看数据库的连接数

SELECT *
FROM sys.dm_exec_sessions AS t2,sys.dm_exec_connections AS t1
CROSS APPLY sys.dm_exec_sql_text(t1.most_recent_sql_handle) AS st
WHERE t1.session_id = t2.session_id
ORDER BY t1.session_id