Capacity planning

[femendez]

We are looking for information about capacity planning for a SQL database with the following configuration:

-200 online users that update about 10,000 registers
every day.
-200,000 Registers with 10 fields with 2 keys.
-That project only works for 3 months!
-Access time is no factor, we need handle all
information in a centralized site.
-The information is stored for Data Mining, but such is
other project.

Our main question is about server size. How can I calculate number of CPU's???

And, how can planning the SQL Server capacity planning??

Thanks in advance.

 

[tlbroadbent]

Check out chapter 6 of the SQL Server 2000 Operations Guide.

http://www.microsoft.com/technet/prodtechnol/sql/maintain/operate/opsguide/sqlops6.asp

Most of the contents of "Microsoft SQL Server 7.0 Storage Engine Capacity Planning Tips" is applicable to SQL 2000.

http://msdn.microsoft.com/library/en-us/dnsql7/html/storageeng.asp

Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.