Get information about
a currently running transaction, including the process that initiated the transaction.
-
In the Perspective Resources view, right-click the server you want to monitor and select Monitor.
-
In the left pane, select Transactions.
You can also display the Transactions screen by clicking a SPID link on Running Processes tab of the Databases screen.
-
Locate the transaction in the Transactions table.
-
In the SPID column, click the SPID of the process associated with your transaction. (The ID number is a link.)
The Processes screen appears, displaying information about your transaction’s parent process.