You are designing the Symmetrix VMAX architecture for a DAS-to-SAN SQL Server
migration. Currently all user databases reside on a single locally-attached disk enclosure,
mounted to “M:\”. You have decided on RAID-1 protected 15,000 RPM drives for the new

SQL environment. Last week, you configured Perfmon to record the current IOPS load of the
databases during the 8-hour business day, Monday through Friday as shown in the exhibit.
During an average business day, the transaction log processes 43 GB worth of data.
Following EMC best practices, which discount can be taken from the overall write IOPS
when calculating for the database writes?

You are designing the Symmetrix VMAX architecture for a DAS-to-SAN SQL Server
migration. Currently all user databases reside on a single locally-attached disk enclosure,
mounted to “M:\”. You have decided on RAID-1 protected 15,000 RPM drives for the new
SQL environment.

Last week, you configured Perfmon to record the current IOPS load as shown in the
exhibit. Following EMC best practices, what is the minimum number of spindles required to
satisfy the performance needs of the database?

You are designing the Symmetrix VMAX architecture for a DAS-to-SAN SQL Server
migration. Currently all user databases reside on a single, locally-attached disk enclosure,
mounted to “N:\”. You have decided on RAID-5 protected 15,000 RPM drives for the new
SQL database and RAID-1 for the transaction log.Last week, you configured Perfmon to
record the current IOPS load of the databases during the 8-hour business day, Monday
through Friday as shown in the exhibit. During an average business day, the transaction log
processes 87 GB worth of data.

Following EMC best practices, what is the minimum number of spindles that must be
allocated for optimal transaction log performance?

You are designing the Symmetrix VMAX architecture for a DAS-to-SAN SQL Server
migration. Currently all user databases reside on a single, locally-attached disk enclosure,
mounted to “N:\”. You have decided on RAID-5 protected 15,000 RPM drives for the new
SQL database and RAID-1 for the transaction log. Last week, you configured Perfmon to
record the current IOPS load of the databases during the 8-hour business day, Monday
through Friday as shown in the exhibit. During an average business day, the transaction log
processes 87 GB worth of data.

Following EMC best practices, how many IOPS should be subtracted from the overall write
IOPS, when calculating for the database writes?