Transaction Profile

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

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

NoteTo quickly identify response time problems, save showplan output for all critical transactions.