The UBS broker company has a database server with three disk

The UBS broker company has a database server with three disks. Both the accounting and stock exchange applications share the same disk, and they are experiencing performance problems. Discuss potential reasons for the performance problem, and suggest how to reduce I/O contention.

Solution

The potential reasons for the performance can be:

1. The response time provided by the server to accounting and stock exchange applications might be increased due to same disk usage, i.e. more reads than writes with small I/O size.

2.Intensive bandwidth usage may occur due to which the performance may get degraded.

3.It can be insufficient number of drives to service I/O’s.

4.Poor Indexing schemes.

5.Database structure might not well normalized.

6.Scalability problems occurring due to access patterns.

Methods for reducing I/O contention:

1.Use multiple disks to store files.

2.Seperate read-only data from writable data

3.Table Placement.

Place each table on different disk drives so that queries which access multiple tables will not create I/O contention on one disk.

4.Index Placement.

One should not place indexes on the same disk drive as other information that will likely be accessed by a query that uses the index.

5.Temporary File Placement.

temporary files must be placed on other disk which is not used for storing data and indexes.