Summary

In this chapter, you have learned the fundamentals of sizing and capacity planning. You have reviewed some mathematics that you probably hope you’ll never use again. In addition, you have learned how to size a system for CPU, memory, I/O, and network capacity. This chapter has also introduced you to some new tools that are useful for benchmarking and load testing both the I/O subsystem and the network. You will find these tools and concepts important not only for sizing and capacity planning, but for performance tuning as well.

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.