You are a SQL Server administrator. You have a server with a database names Commerce that will be used to store sales transactions. The database must be available at all times and must be as fast as possible. Configure your server according to Table 5-1. Where should you place your database and transaction logs for maximum speed and fault tolerance?

You are a SQL Server administrator. You have a server with a database names Commerce that will be used to store sales transactions. The database must be available at all times and must be as fast as possible. Configure your server according to Table 5-1. Where should you place your database and transaction logs for maximum speed and fault tolerance?

You are a SQL Server administrator. You have a server with a database names Commerce that will be used to store sales transactions. The database must be available at all times and must be as fast as possible. Configure your server according to Table 5-1. Where should you place your database and transaction logs for maximum speed and fault tolerance?


Answer – Place the transaction log and the data file on the RAID-5 disk array.

(Both the data and log files should be placed on the RAID-5 array because it is the only array that offers fault tolerance. Physical disk 0 is just a disk with no fault tolerance whatsoever.)