
B-8 Worksheets for Your Current Environment
Data Architecture Worksheet Adaptive Server Enterprise 11.5
Transaction Profile
Repeat this section for each database on the SQL Server. Application
processing information at the transaction level is helpful for
documentation and success criteria.
➤
To quickly identify response time problems, save showplan output for all
critical transactions.
Table B-6: Transaction profile
Process
(Xact)
Name
Process
Type
(OLTP,
batch)
Xact
Priority
Frequenc
y 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
Comentários a estes Manuais