sqlserver如何查看里面的各个sessions的CPU，memory, disk io.etc.

自带的工具有 ：

1. Activity monitor

2. select "DB instance"-->right click, report-->standard report-->user statistic.

3. DMV

4. SELECT login_name ,COUNT(session_id) AS session_count FROM sys.dm_exec_sessions GROUP BY login_name;

5. select * from sys.sysprocesses.