You need to optimize the performance of the database by maximizing disk bandwidth and reducing the contention in the storage allocation structures

You administer a SQL Server 2008 instance. The instance runs on a computer that has the
following features: A 64-GB RAM Four quad-core processors Several independent physical
raid volumes You plan to implement a transactional database on the instance. The
database is expected to have a high volume of INSERT, UPDATE, and DELETE activities.
The activities include creation of new tables. You need to optimize the performance of the
database by maximizing disk bandwidth and reducing the contention in the storage
allocation structures. What should you do?

You administer a SQL Server 2008 instance. The instance runs on a computer that has the
following features: A 64-GB RAM Four quad-core processors Several independent physical
raid volumes You plan to implement a transactional database on the instance. The
database is expected to have a high volume of INSERT, UPDATE, and DELETE activities.
The activities include creation of new tables. You need to optimize the performance of the
database by maximizing disk bandwidth and reducing the contention in the storage
allocation structures. What should you do?

A.
Configure the affinity mask option appropriately.

B.
Configure the affinity I/O mask option appropriately.

C.
Place database and log files on the same volume.

D.
Create multiple data files for the database.



Leave a Reply 0

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