469,621 Members | 1,700 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,621 developers. It's quick & easy.

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 2186
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
reply views Thread by devrayhaan | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.