Need some initial direction

Hi all. The company I work for is looking for a new SQL server. Where can I find information and or a tool for sizing information? By sizing information I mean how big a pile of hardware am I going to need to run MS SQL for x number of connected users with x size database, etc. I've been tooling around the internet and MS' site but can't find any info on this.

Can anyone shed some light for me?

To be honest it totally depends.

The DB's I manage on my SQL box have about 50 users, the data is <20gig and im running the Dell PowerEdge750 Server with a Pentium4 HT Processor and it really does fly. By saying fly I mean its really quick, I have never had a problem with it. I cant comment on larger production environments as I simply dont have the experience.

Edit: I should add I am using 2 gigabytes of RAM for this particular server.

hth

Barry Andrew

|||

Following MSDN libraries might be a good start for you to get familiar with Microsoft SQL Server 2005.

http://msdn2.microsoft.com/en-us/library/ms166352.aspx

http://msdn2.microsoft.com/en-us/library/ms188607.aspx

And following articles might be a good start for data warehousing, Architecture and Design.

http://msdn2.microsoft.com/en-us/library/aa226328(SQL.70).aspx

http://msdn2.microsoft.com/en-us/sql/aa336281.aspx

hope this helps. :-)

Thanks

|||Excellant! Thank you. That should get me started.sql