This IBM Redbooks publication discusses database sizing guidelines for deploying SQL Server 2000 databases that use IBM System Storage N series.
Enterprise-level SQL Server environments require careful planning driven by performance and reliability criteria that are the critical components for many SQL Server implementations. Servicing user transactions and delivering consistent and acceptable response times are critical for most applications using SQL Server for storing and retrieving data from databases. Performance degradation can only be prevented when resource utilization is monitored and capacity planning guidelines are in place, well understood, and implemented properly. Therefore, capacity planning guidelines are an obvious part of this paper.
The focus of this paper is storage requirements for SQL Server databases. Space requirements are fairly easy to calculate and not really an issue, but throughput and service time requirements are less exact and more difficult to define. This paper provides the background knowledge that will make it easier to work with administrators to size storage correctly for both space and throughput.
Table of contents