What other factors would you consider before giving the go-ahead for the new hard disks?

You are working as a DBA for a DSS system, on which applications primarily perform large sequential I/Os. The company wants to upgrade the storage used by the database to faster hard disks.
What other factors would you consider before giving the go-ahead for the new hard disks? (Choose all that apply.)

You are working as a DBA for a DSS system, on which applications primarily perform large sequential I/Os. The company wants to upgrade the storage used by the database to faster hard disks.

What other factors would you consider before giving the go-ahead for the new hard disks? (Choose all that apply.)

A.
the sizing of PGA to meet the faster data access

B.
the sizing of buffer cache to meet the faster data access

C.
the time it takes for a submitted I/O request to be serviced by the storage

D.
the capacity of the I/O channel that connects the server to the storage array



Leave a Reply 2

Your email address will not be published. Required fields are marked *


vasya

vasya

why not A?
In DSS a system PGA should be about 70% of total memory

domq

domq

Yes, but we consider disk approach. Before someone buy new disk we have to make sure that they met DB requirements.