Load profiles let you define the operating criteria for a logical cluster.
Load profile criteria are typically called “load score metrics,” with the value associated for each criteria rolled into a “score” for each instance in the logical cluster that uses the load profile. You can periodically compare load scores for different instances within a logical cluster to detect when the workload is undesirably skewed to one or more instances, or to determine if an instance is underutilized.
Instances included in multiple logical clusters can be impacted by multiple load profiles, so take care when associating instances with multiple logical clusters and when defining and applying load profiles.
The Cluster Edition includes two system load profiles: sybase_profile_oltp for OLTP environments and sybase_profile_dss for DSS environments. You cannot modify or delete system load profiles. However, you can duplicate them and modify the duplicates to create your own load profiles.
The load profile status reports the:
- Name – the name for the load profile configuration.
- Type – the load profile type: system or user.
- Metric weights – relative weight assigned to each metric in the load profile. Metrics include:
- User connections – the weight of users connected to the particular load profile.
- CPU busy – the weight of CPUs that are currently busy.
- Run queue length –the weight of the run queue.
- IO load – the weight of the I/O load.
- Engine deficit – the weight of the engine deficit.
-
Users – the weight for a metric the user chooses to measure.
- Thresholds – configured difference (as a percentage) in the load between two instances in a logical cluster at which point the following can occur:
- Login redirection – used for connection-time load balancing and routing connections to a logical cluster. If necessary, an instance directs a client to stop the current login attempt and try connecting to instances it supplies as a list of available network addresses.
-
Dynamic migration – (also known as the hysteresis value) the dynamic migration configuration.
- Minimum load score – load score necessary to trigger login redirection and dynamic migration.