This section contains the following topics:
Sources of Database Contention
Once you have refined the database model to optimize each individual database transaction, you should determine how the system will be affected by the concurrent execution of several transactions. You need to consider making changes to the physical model to minimize the likelihood of system bottlenecks.
Bottlenecks are often caused by excessive contention for database resources. For example, bottlenecks can occur when two or more programs (or terminal operators) attempt to execute update transactions against the same entity occurrences at the same time. Since the likelihood of contention increases with the number of database transactions, you need to determine whether the physical database model can accommodate the number of transactions executed at your corporation.
This chapter explains why database contention occurs and also shows you how to minimize contention.
|
Copyright © 2014 CA.
All rights reserved.
|
|