If you
aren??™t careful, you could end up with one huge drive array with multiple partitions. If that happens, and
if I/O is your concern (and if it isn??™t, you shouldn??™t be a DBA), your options for maximizing I/O performance
just got a lot smaller.
When discussing disk performance, people often use block size and stripe size synonymously,
when in fact the two are quite distinct. Be sure that you know the difference
(which means being able to describe the difference) when discussing disk configuration
with your hardware colleagues.
From a disaster recovery standpoint, I want to minimize the number of times that a
drive is actively writing. If my disk is formatted in something other than 8K blocks, I??™ll
face additional discrete writing operations at the low level of the disk. This increases my
chances (however slim they may already be) of having a checksum or torn-page error.
Even though SQL Server 2005 supports page-level recovery, I??™d rather not recover an individual
page if I can avoid it.
Locally Attached Storage
Any storage device that is directly attached to the database server is considered local
storage.
Pages:
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454