You need to configure your system for optimum access to a 1.5 TB database. Approximately half of the tables are used primarily for writing; the rest are used primarily for reading and generating reports. How can you optimize this database for the fastest access?

You need to configure your system for optimum access to a 1.5 TB database. Approximately half of the tables are used primarily for writing; the rest are used primarily for reading and generating reports. How can you optimize this database for the fastest access?

You need to configure your system for optimum access to a 1.5 TB database. Approximately half of the tables are used primarily for writing; the rest are used primarily for reading and generating reports. How can you optimize this database for the fastest access?


Answer – Place the files that are used for reading in one filegroup and the files that are used primarily for writing in a second filegroup on another disk array.

(To specify which disk you want to place an object on, you must create a filegroup and then specify which filegroup to place the object in at the time it is created.)