capacity planning question

• George Kwong

  SSC Rookie

  Points: 28

  More actions

  June 23, 2006 at 1:13 am

  #97182

   Hello,

  I am working on planning for an SQL Server application, I have some gerenal capacity planning question, thanks any one who can help:

  Capacity and resource planning for SQL Server 2000

  1) resource requirements for 500, 1000, 2000 concurrent users (database, memory, CPU, etc.)

  2) deployment requirements for 500, 1000, 2000 concurrent users (server configuration, architecture model, etc.)

• K. Brian Kelley

  SSC Guru

  Points: 114642

  More actions

  June 23, 2006 at 7:40 am

  #645534

  A lot of this is dependent upon how the data is accessed (OLTP, OLAP, etc.). Here are some references that might help:

  Planning for Consolidation with Microsoft SQL Server 2000

  See the appendix on that one for a lot of additional resources.

  SQL Server 2000 Sizing and Capacity Planning Guidelines (from NetApp)

  HP's Sizing and Configuration documents for SQL Server

  K. Brian Kelley
  @kbriankelley