PrepAway - Latest Free Exam Questions & Answers

Why is the SQL application seeing increased disk response times from the local array?

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?

PrepAway - Latest Free Exam Questions & Answers

A.
Increased latency causes the MirrorView/A update cycles to take longer, increasing
COFW activity.

B.
The 64 KB chunk size for MirrorView/A does not match the small transaction size of the
database, increasing the bandwidth required between the arrays.

C.
The MirrorView/A update cycle time is too short. It should be increased to improve write
folding.

D.
The MirrorView/A buffer size should be adjusted to match the smaller write I/O size.


Leave a Reply