471,854 Members | 1,861 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,854 software developers and data experts.

SQL Server Hardware Setup

I have a SQL Server 2000 database that I will need to take from
development and put into production. Currently the database is on a
workstation running Windows 2K Server for development purposes. The
database will have dozens of users with data entry capability and
hundreds of users with viewing/querying capability. The users will
have a web front end to the database. I need to know the best possible
hardware setup I will need to purchase to support this user scenario.
Money is no object but the cost must still be within reason. Can
anybody give me any recommendations or point me to some websites that
have hardware specs for SQL Server?
Jul 20 '05 #1
1 2224
armusis

There are a couple of chapters in SQL Server 2000 Performance Tuning
Technical Reference book that I have found very useful in sizing an
application.

You need to analyse the transactions within your application and then
you can calculte cpu, memory and I/O depending on projected number of
users, amount of data, required response time etc. I found it very
useful, quite a lot of work to do it properly though.

Hope this helps

Regards

John
Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

23 posts views Thread by BlackHawke | last post: by
35 posts views Thread by English Teacher | last post: by
2 posts views Thread by Mały Piotruś | last post: by
NeoPa
reply views Thread by NeoPa | last post: by
aboka
reply views Thread by aboka | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.