SQL Server 2000 Sizing and Capacity Planning Guidelines

An IBM Redpaper publication

Published 08 March 2008

cover image

IBM Form #: REDP-4273-00
(42 pages)

Authors: Alex Osuna, Gerson Finlev


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.

Follow IBM Redbooks

Follow IBM Redbooks