查询服务器登录个数

select host_name,login_name, count(session_id) FROM sys.dm_exec_sessions
where database_id=9
group by host_name, login_name
order by host_name