Tell me more ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.
up vote -2 down vote favorite

What will be the best Server Configuration for SQL 2008 as on date with DB Size of 5 GB?

So far my experience with Desktops, AMD processors gives better performance than of Intel. Is Opteron processors are better for SQL 2008 or should I stick with Intel Xeon.

share|improve this question
3  
"what is the best..." questions are virtually unanswerable due to the multitude of possible requirements which are frequently omitted in such questions - just as has happened in your case. – syneticon-dj Jun 8 '11 at 11:44

migrated from stackoverflow.com Jun 8 '11 at 10:34

closed as not a real question by squillman, Ben Pilbrow, jscott, John Gardeniers, Chopper3 Jun 8 '11 at 12:41

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, see the FAQ.

1 Answer

up vote 0 down vote

Unless you have an extreme amount of traffic, it most likely won't make any difference if you've got modern dedicated hardware for a DB of just 5 gigabytes. With just 8GB of memory you can probably get a cache hit ratio of ~100% which will render disks less important, except for the logs.

As for CPU's I personally prefer Xeons over AMDs line of CPU's, but I have no facts to base it on besides personal experience.

share|improve this answer
5 GB is current db size with 2 years data. And it's growing. No. of concurrent users are 20. It may go up to 30 this year. My inserts and updates are taking long time and users have to wait till screen finishes its work. – Sivaa Jun 8 '11 at 11:43
2  
But how have you concluded that it's lack of CPU power? What profiling have you done? Before throwing hardware at it, you should be absolutely certain of where your bottleneck is, or you may just waste money. 20-30 concurrent users is not much for a 5GB database. Either those users are very heavy users or there are some more fundamental problems at hand, which should be identified first. – Mark S. Rasmussen Jun 8 '11 at 12:02
@Sivaa, throwing money or hardware at the problem merely hides it. Best thing to do is FIX it by performing proper analysis and redesigning and/or recoding as necessary. – John Gardeniers Jun 8 '11 at 12:32

Not the answer you're looking for? Browse other questions tagged or ask your own question.