To reduce database contention independent of making disk configuration changes, try approaches that may reduce database accesscontention or improve file access time.
In implementing systems with high concurrency requirements we can devise finer grained locking strategies based on the access requirements of the operations, hence reducing contention for resources.
在实现具有高并发性要求的系统时,我们可以基于操作的要求采用更细粒度的锁定策略,从而减少资源争用。
3
Placing the pieces on separate I/O paths reduces the contention of SQL operations that need to access the NPI.