SELECT TOP 100 b.spid, b.lastwaittype, b.hostname, b.program_name, b.net_address FROM master.dbo.sysprocesses b (nolock) ORDER BY hostname DESC
SQL 客户端查看
原文：http://www.cnblogs.com/ilookbo/p/4972189.html
