Activity | 10 Seconds | Active Queries

This is an effective way of answering the question "What is using most resources right now?"

All running queries are recorded over a 10 second period, and the most expensive in terms of logical reads and CPU time are displayed.

Queries With Most Logical Reads

What It ShowsComments
SQL handle
Database
Logical reads/sec

Queries With Most Worker Time

What It ShowsComments
SQL handle
Database
CPU (ms)/sec
< Activity | 10 Seconds | Performance Counters Activity | 10 Seconds | Operational Stats >