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 Time Required |
Current Average and Maximum Response Time |
|---|---|---|---|---|---|---|---|
|
|||||||
|
|||||||
|
|||||||
|
|||||||
|
|||||||
|
To quickly identify response time problems, save showplan output for
all critical transactions.
