Data, Log and Temp file placement

Posted by jchang on SQL Blog See other posts from SQL Blog or by jchang
Published on Tue, 23 Mar 2010 15:56:00 GMT Indexed on 2010/03/23 16:03 UTC
Read the original article Hit count: 498

Filed under:
|
|
|
|
First especially for all the people with SAN storage, drive letters are of no consequence. What matters is the actual physical disk layout. Forget capacity, pay attention to the number of spindles supporting each RAID group. If the RAID group is shared with other application, make sure there the SLA guarantees read and write latency. One very large company conducted a stress test in the QA environment. The SAN admin carved the LUNs from the same pool of disks as production, but thought he had a really...(read more)

© SQL Blog or respective owner

Related posts about data

Related posts about disks