You work as DBA at AIOTestKing.com. You administer a SQL Server 2005 computer named AIOTestKingA. AIOTestKing A runs Windows Server 2003 and hosts a database named DB1.
DB1 is used for a critical, enterprise-level application that all sales representatives in the company use. The database is currently 87 GB and grows 5 GB each quarter. AIOTestKing A recently experienced a hard disk failure that resulted in significant system downtime.
You purchase two new hardware RAID controllers named Controller1 and Controller2.
You also purchase five new hard disk drives to try to prevent reoccurrences of hardware-related downtime. The new hard disk drives are configured as shown in the following table.
Disk drive Size RPM Disk1 100 GB 7200 Disk2 100 GB 7200 Disk3 100 GB 7200 Disk 460 GB 7200 Disk5 60 GB 7200 The operating system is configured for redundancy. You decide to build a RAID5 array on Controller1 and a RAID1 array on Controller2.
You need to ensure that DB1 continues to perform in the event of a disk failure.
What should you do?
A.
Explanation:
RAID-5 requires at least 3 disks. The database files should be put on the RAID-5 array. It is faster.
RAID-1, mirroring, uses 2 disks. Transaction log files are sequential and well fit for mirrored disks.