Sybase provides two sample load profiles:
sybase_profile_oltp – is configured for OLTP environments. It tries to keep all connections on the same instance by disabling load-based login distribution and dynamic-load distribution. Emphasis is placed on requeue depth, which is a good predictor of response time.
sybase_profile_dss – is configured for primarily read-only, DSS environments. It uses load-based login distribution and dynamic load distribution to distribute load across multiple instances, but places emphasis on balancing CPU usage and user connections.
Table 6-4 lists the metrics for sybase_profile_oltp and sybase_profile_dss.
Workload metric |
“sybase_profile_oltp” |
“sybase_profile_dss” |
---|---|---|
Profile ID |
1 |
2 |
User connections |
0 |
40 |
CPU utilization |
10 |
40 |
Run-queue length |
70 |
0 |
I/O load |
20 |
10 |
Engine deficit |
0 |
10 |
User weight (not used) |
0 |
0 |
Login threshold |
0 |
20 |
Dynamic threshold |
0 |
50 |
Hysteresis |
20 |
20 |