My Ultimate SQL Server Like you, I don’t yet have my ultimate SQL Server. Yea, I do have a couple of “larger” servers, but not the kind I can really brag about at the upcoming SQLPass conference.
So what if I could choose my ultimate SQL Server, what would I choose? After a little thought (about 5 nanoseconds), I think it would look something like this:
- Eight CPUs. Sure, you can stuff more CPUs in a server, but these high-end servers are hard to come by. I want to be realistic, you know. Any more than eight CPUs would just be plain self-indulgent.
- Intel Pentium III 900MHz Xeon Processors with 2MB L2 cache. When will Intel ever get their Xeon CPUs up to 1.7GHz, like their new Pentium IV line? Doesn’t Intel realize that SQL Servers need more oomph that a measly 900MHz? [Since this article was written, Intel has come out with much faster Xeons — Brad]
- 64GB RAM. You might as well max out what the operating system can handle. Anything less will be a waste of potential performance. Besides, I want my entire database to fit into physical RAM, with room to spare.