Chapter 12. How Fast and Robust Is Your Storage?
The storage subsystem is the foundation for all the data that lives in SQL Server. The performance, robustness, and reliability of the storage subsystem affect everything you build on it in SQL. For this reason it is essential that you have a solid understanding of what your storage subsystem can deliver and have confidence in its robustness and reliability.
The best way to build that solid understanding of the storage subsystem's performance potential is to measure it using a performance test. There are several ways to do this, and this chapter discusses several options before diving into using one in more detail. The tool of choice for this chapter is SQLIO.
The best way to build confidence in the robustness and reliability of the storage subsystem is to run a stress test on it. There are multiple ways you can do this, and this chapter discusses several ways you might do this before digging into the details of using the latest tool from Microsoft: SQLIOSIM.
Obviously, everyone's system is different. You will have your system configured according to your various needs. Depending on your system, you will have a certain amount of disk space. You will have assorted programs running on different schedules. As you follow along with this chapter, it is likely that you will have different measurements and readings than some of the ones I will provide. That is fine. Don't get too caught up comparing those specific numbers. The important ...
Get Professional SQL Server® 2005 Performance Tuning 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.
