XiaoCheng_T的博客

一.查看当前的数据库用户连接有多少 USE master GO SELECT * FROM sys.[sysprocesses] WHERE [spid] > 50 –AND DB_NAME([dbid])=‘gposdb’ SELECT COUNT(*) FROM [sys].[dm_exec_sessions] WHERE [session_id] > 5 二.选取前10个最耗CPU时间的会话 SELECT TOP 10 [session_id] , [request_id] , [star