Hardware requirements for SQL Server 2005

5 pts.
Tags:
Database design
SQL Server 2005
SQL Server performance
Hi all, We are looking into creating a SQL 2005 server (Windows 2003 R2 SP2 Enterprise Ed.) with 3 databases. Size of the db 's will be app. 50 GB, 15 GB and 7 GB. Amount of continuous logged on users is app 20. Can anyone recommend the amount of CPU + clockspeed of the CPU's, RAM memory and pagefile to have an as good performance as possible? Thank you! Arne

Answer Wiki

Thanks. We'll let you know when a new response is added.

THIS IS NOT A BAD CHOICE ON THE CHEAP CP1-AM2-6400A MADE BY AMD. Though depending on what the server is being used for. If you are working for or own the company. Depending on how much growth your company might predict in the future dual/quad xeon might be the best way to go. Don’t let possible environment of the server room get hot think green. When its time to upgrade your possibilities your boss will appreciate you for his roi. As far as clock speed this can be a touchy situation under most circumstances while in full operation (under full workload) of all employees logged in monitor task manager and watch the CPU usage monitoring is key here. if it is under 15% leave alone no reason to cause more work on the CPU. If the percentage is hire think about more ram so instructions and algorithms have more space to go to. This should bring down the bottle neck on CPU in theory you should be lower than 15% you can increase speeds in increments.Good luck!!

———-

With SQL Server more RAM is always better. Buy what you can afford. 4 Gigs is usually the minimum. How much data will be changing within your database? The more RAM that you have the more data SQL Server will cache into RAM.

As for CPU speed, any of the CPUs which are available will be fine. You’ll want to get as many cores as you can. A couple of AMD 64bit quad core CPUs will be just fine, if not overkill for the workload you are talking about. As long as your databases are properly indexed and optimized a single dual core CPU will probably be just fine. That said, be sure to plan for the future. It’s easier to buy a bigger box now, than to explain why the 1 year old server needs to be replaced. What do you think the work load will be like in 12-36 months?

Page file should be set for a couple of Gigs. You don’t want SQL Server to be able to page to much data as it’s easier for SQL to load the data from disk than from the page file.

Some articles which you might find helpful are:

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following