Record transaction profile information for each database on the server.
Process (Xact) name |
Process type (OLTP, batch) |
Xact priority |
Frequency per user (per hour) |
Source code type (stored procedure, ESQL, etc.) |
Average response time required |
Maximum response timer required |
Current average and maximum response time |
|---|---|---|---|---|---|---|---|
|
|||||||
|
|||||||
|
|||||||
|
|||||||
|
|||||||
|
To quickly identify response time problems, save showplan output for
all critical transactions.
