Summary
In this chapter you have been introduced to the fundamentals of I/O and performance characteristics of disk drives and RAID. Because I/O performance is so important to SQL Server, you must carefully plan and design the SQL Server System. This has been briefly covered here and will be covered in future chapters as well. It is important that the I/O subsystem be monitored and tuned as necessary. In Chapter 6, you will see how to monitor and benchmark the storage system to plan for the future.
This chapter provided the fundamentals and basics of I/O performance. The chapter started with the fundamentals of disk drive performance. These fundamentals are important since the disk drive is the basic building block of most I/O subsystems. By exceeding ...
Get Microsoft® SQL Server™ 2005 Administrator's Companion now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
