processor speed recommendations for SQL Server 2005

SQLServerCentral is supported by Red Gate Software Ltd.

Home Tags Articles Editorials Forums Scripts Videos Blogs QotD Books Ask SSC SQL Jobs Training Authors About us Contact us Newsletters Advertise Write for us

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 General Discussion » processor speed recommendations for SQL...

processor speed recommendations for SQL Server 2005

Rate Topic

Display Mode

Topic Options

Author

Message

BP-428602

Posted Thursday, April 12, 2007 1:33 PM

Forum Newbie

Group: General Forum Members
Last Login: Friday, July 31, 2009 5:57 PM
Points: 1, Visits: 15

Does anyone have any recommendations for processor speed for SQL Server 2005? We are a medium sized company with about 200 end-users. We're going to be purchasing a new server for SQL Server 2005. (And and it will have Windows Server 2003 (32 bit) as the operating system.) We're running SQL Server 2000 on HP servers that are about 3 years old. The HP servers have a processor speed of 3.2 GHz and 2.0 GB of RAM. We're looking at getting the Standard Edition of SQL Server, and using the processing license model. We probably need to stay under $25K for the total cost of hardware and software. Thanks.

Post #358014

CountCet

Posted Thursday, April 12, 2007 1:46 PM

Valued Member

Group: General Forum Members
Last Login: Wednesday, September 23, 2009 8:24 AM
Points: 69, Visits: 56

It really all depends on how many concurrent connections and how the database is used.

You may want to look into using sqlio to do a benchtest

Post #358016

« Prev Topic | Next Topic »

Permissions