Scalability Demystified
Scalability refers to the server’s behavior either as more work is added or as more resource is added, either separately or together. As system resource is increased, if the amount of workload that can be processed increases at the same rate, then the scalability is said to be linear. For example, if twice as many transactions can be completed by a doubling of the number of CPUs, then processing of transactions has scaled linearly.
Some workloads scale better than others; for example, data warehouse queries often scale almost linearly since there is little contention between processes. Some OLTP workloads may show poorer scalability characteristics.
Another way of achieving excellent scalability is to host multiple workloads ...
Get Configuring and Tuning Databases on the Solaris™ Platform now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
