An organization has a database server with three disk devices. The accounting and payroll applications share one of these disk devices and are experiencing performance problems. You have been asked to investigate the problem and tune the databases. What might you suggest to reduce I/O contention?
The Solution to the Problem
Usually, for database applications, the I/O is exhaustive because, in a database, the more number read and write operations are performed. Input/Output contention is the corruption of execution that happens when a disk or virtual machine struggles for Input/Output assets. Input/Output conflicts are regularly seen in cases of overwhelming workloads when there's a high number of peruses and composes, bringing on idleness and bottlenecks.
The steps to reduce I/O contention are as follows:
- To decrease I/O conflict, information records need to be differentiated that are, no doubt got together.
- The large database questions that will be gotten to simultaneously be striped crosswise over plates. This might additionally decrease I/O conflict.
- On the other hand, it may be conceivable to reschedule cluster employments that utilize records on the one drive under discord, so the occupations do not run simultaneously.
- At long last, it could be conceivable to revamp the database to take into consideration more productive preparation by utilizing better indexing plans.
See Also: MDM Chapter 11 Problem and Excercise 12
Post a Comment