试题详情
- 单项选择题 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、Create multiple data files for the database.
B、Place database and log files on the same volume.
C、Configure the affinity mask option appropriately.
D、Configure the affinity I/O mask option appropriately.
- A
关注下方微信公众号，在线模考后查看
热门试题