You can use this to get a quick and dirty picture of what is going on with the server. We basically grab a snapshot, wait a second and then get a diff. Sort as needed. select r . cpu_time , r . logical_reads , r . session_id into #temp from sys.dm_exec_requests as r waitfor delay '00:00:01' select substring...