A customer is in the design phase of their SQL server implementation. They request your
guidance concerning the number of disk drives needed to properly configure the database for
performance. The current utilization of the database is shown below: S
85% reads and 15% writes
10K SAS disks
RAID 1/0
1150 IOPS
What is the minimum number of disk spindles required to service the random I/O requests during
usage of the SQL Server database?

Your customer has a new VNX solution configured with Flash, SAS, and NL-SAS drives. The
customer requires their OLTP, VDI, Software Development, and Regulatory Compliance
workloads to be distributed between the different drive types. Due to limited drive quantities only
one workload type can be configured using Flash drives.
According to best practices which configuration best assigns the workloads?

A customer is in the design phase of their SQL server implementation. They request your
guidance concerning the number of disk drives needed to properly configure the database for
performance. The current utilization of the database is shown below:
80% reads and 20% writes
10K SAS disks
RAID 5
1150 IOPS
What is the minimum number of disk spindles required to service the random I/O requests during
usage of the SQL Server database?

A VNX storage system is being configured to provide storage for an Exchange 2010
implementation for 2,000 users. Performance and reliability are more important than cost for the
customer.
What RAID configuration should be used?

As a result of suffering a catastrophic failure, your customer has requested a DR solution. The
solution must introduce a higher level of availability for their Exchange 2010 system. You have
recommended a strategy that involves Replication Manager with native DAG.
In what state(s) of the database would the replication occur?

A company has added a large number of users to a VMware VDI deployment. The users are
complaining that the system (VNX-Block) is slow, especially when they start their shift. You have
been tasked to provide an economical solution.
Which technology would you use to improve performance?

A customer has designed an environment using block based LUNs presented to individual hosts.
They have configured a pool to start using both thick and thin LUNs. One of the standalone
servers is an archive server running on Windows. They want to maximize capacity on the
standalone server since the data is no longer accessed. They have no more drives to increase

LUN capacity.
How can the customer increase available capacity to the archive server?

A customer is checking a NAR file in Unisphere Analyzer. They see that a RAID Group with only a
single LUN is shown with consistently large Disk – Average Seek Distances.
What could this indicate?

A SQL Data Warehouse database is replicating between two VNX storage systems with
Incremental San Copy. The production database is on 15, 15k rpm SAS drives and the Reserved
LUN Pool uses five NL-SAS drives. The database is continuously updated locally and replicated
once a day to maximize the benefits of write folding. Replication takes place from 6 PM until 10
PM. At 6 PM the storage administrator notices an increase in response time of the application,
which steadily improves until 10 PM.
What should be done to improve performance during replication without affecting recovery data
granularity?

A pair of VNX storage arrays is replicating between two data centers over an iSCSI connection.
The SQL Admin has noticed that a small OLTP database with a write size of 4k periodically
experiences increased disk response times. The Storage Admin reports that during the same
period, replication sessions are taking longer to complete. The Network Admin reports degraded
performance between the sites during the same period.
Why is the SQL application seeing increased disk response times from the local array?