You are creating an Inventory database that requires 60 GB of data space and 20 GB of log space. Your servers’ hard disks are configured as shown in Table 5-2. Your OS files are on the C drive. You want to maximize performance. What should you do?

You are creating an Inventory database that requires 60 GB of data space and 20 GB of log space. Your servers’ hard disks are configured as shown in Table  5-2. Your OS files are on the C drive. You want to maximize performance. What should you do?


Answer– Add a 20 GB log to drive D, a 30 GB data file to drive E, and a 30 GB data file to drive F.

( The best strategy is to place the log file on drive D and the data files on E and F. That way, all of them can grow if necessary, the transaction log and data files are separate, and the OS is on its own partition.)