Using the Active Processes For dialog box

The Active Processes For dialog box enables you to view SQL statements for one or all users in a sort order defined by you.
In the Active Processes For dialog box,

1. To select one user, type the login name in the text box.
   To select all users, leave the text box blank.
2. Click the item you want the list sorted by: spid, CPU usage, memory usage, I/O.
   CPU usage, memory usage, and I/O do not display in the report unless selected as the sort criterion.
3. Click Accept.
   The Active Processes by <sort order> dialog box opens and lists all active processes for the selected user or for all users by the sort criterion selected.

To continue, go to Using-the-Active-Processes-by-dialog-box.