Identifying a Transaction’s Process

Get information about a currently running transaction, including the process that initiated the transaction.

  1. In the Perspective Resources view, select the server to monitor, click the drop-down arrow, and select Monitor.
  2. In the left pane, select Transactions.
    You can also display the Transactions screen by clicking an SPID link on the Running Processes tab of the Databases screen.
  3. Locate the transaction in the Transactions table.
  4. In the SPID column, click the SPID of the process associated with your transaction. (The ID number is a link.)
    You see the Processes screen, which shows information about your transaction’s parent process.
Related reference
Process Statistics and Details
Transaction Statistics and Details