查看sqlserver连接数

select   count (spid)  as  counts, 
status, 
hostname, 
dbname  =   case  
when  dbid  =   0   then   null  
when  dbid  <>   0   then   db_name (dbid) 
end  
from  master.dbo.sysprocesses 
where  spid  >= 0   and  spid  <=   32767   and  status = ' runnable '   and   db_name (dbid) = ' 数据库名 '  
group   by  status,hostname, 

case  
when  dbid  =   0   then   null  
when  dbid  <>   0   then   db_name (dbid) 
end  

转载于:https://www.cnblogs.com/zhangpengshou/archive/2011/05/26/2057944.html