This is your data, your database, your SQL Server instance, and your operating system.
No hard disk storage, no job.
CHAPTER 10 n HARDWARE CONSIDERATIONS 244
nNote Many DBAs have a strong understanding of disk storage, configuration, and optimization when it
comes to databases and potential issues involved. No DBA knows everything (myself included), and some
may know nothing about disk storage (I hope I??™m wrong about that). Even if you feel you fully understand the
topic, don??™t disregard this section. Even if you learn one new tidbit, it??™s worth it.
One of the more frustrating aspects of storage technology is the overlap in terminology.
It is easy to sound like a Luddite just by using the right term in the wrong way. When
mistakes like that happen, you often won??™t even be given the respect to have your misunderstanding
corrected by your hardware counterparts.
From a hardware perspective, the basics of storage I/O are relatively complex, even
when a single internal disk drive is involved. I??™ll skip what happens when the write or
read request goes through SQL Server to the OS and jump right down to the hardware.
Pages:
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451