Load profiles consolidate all configurable aspects of the workload scoring system into a single named entity.
You can assign different load profiles to different logical clusters in the same physical cluster, thus enabling multiple applications with diverse workloads within the same physical cluster. You can also share the same load profile among multiple logical clusters.
For example, a shared-disk cluster can simultaneously host a DSS-based logical cluster that is primarily read-only and an OLTP logical cluster that handles frequent writes. The optimum thresholds for login redirection and connection migration for these two clusters may be very different. The ability to assign specific load profiles to each logical cluster allows each cluster to function more efficiently.
Adaptive Server gathers load statistics for each instance
without regard to logical cluster. Thus, if two logical clusters
run on the same instance, they will have the same raw data for that
instance. However, each logical cluster will interpret and use that
data according to its own load profile.
Sybase provides a preconfigured profile created for an OLTP environment. You can also create your own load profiles using sp_cluster profile.
