You are looking for a very specific comparison, you will not find it. You can research for days and still not have a true benchmark of both the CPUs running.your database. Some CPU benchmarks but not database specific, in link below. CPU speed/cores are only half the issue... bus bandwidth, disk raid subsystem, raid setup, memory access are just as important.
I'm building an SQL server as well. But I am in a SBS enviroment, so I am limited to 32G RAM. We will have 30-40 users on the data base. I am planning for SAS drives. I feel the RAID setup and disc preforamce will be more critical than the CPU speed.
Unforturnitly, the Dell server web site for building a server does not explain very much about each option.
If the server is primarily for SQL, and resources are sufficient, as to the raid...
Best off running a database on a separate Win 2008 server, non SBS server, to much going on in Small business server as a default. Not to say you can not run other resident programs along with SQL on the non SBS server. On my clients I have no issues running backup, server base AV, defraggers, other small DB programs (Access) etc.
Dell's top end controller, SAS for all drives, figure a hot spare drive,( possibly global), raid 1 for the OS/programs (75 gig is sufficient), raid 10 for data (4-6 disk), 1 or raid 5 (4-6 disks) if the DB is primarily reads, disk raid 0 for the temp/log files,pagefile (possible SSD),write back enabled, battery backup for the server system, disk defragger with option to defrag on reboot (such as PerfectDisk). Sometimes changing the stripe size from the default may speed up SQL but takes a great deal of time to figure out the best size, unless you benchmark with real data I would not change the default size. Network, if you wiring infrastructure is up to cat specs, turn off flow control on NICs or on switches will speed up network. With larger disks configurations as above, you would need a larger server or external storage, no nearline slow disks.
pcmeiners
4 Operator
•
1.8K Posts
0
May 19th, 2011 14:00
You are looking for a very specific comparison, you will not find it. You can research for days and still not have a true benchmark of both the CPUs running.your database. Some CPU benchmarks but not database specific, in link below. CPU speed/cores are only half the issue... bus bandwidth, disk raid subsystem, raid setup, memory access are just as important.
http://www.cpubenchmark.net/multi_cpu.html
the blur
12 Posts
0
May 20th, 2011 19:00
I'm building an SQL server as well. But I am in a SBS enviroment, so I am limited to 32G RAM. We will have 30-40 users on the data base. I am planning for SAS drives. I feel the RAID setup and disc preforamce will be more critical than the CPU speed.
Unforturnitly, the Dell server web site for building a server does not explain very much about each option.
pcmeiners
4 Operator
•
1.8K Posts
0
May 21st, 2011 06:00
If the server is primarily for SQL, and resources are sufficient, as to the raid...
Best off running a database on a separate Win 2008 server, non SBS server, to much going on in Small business server as a default. Not to say you can not run other resident programs along with SQL on the non SBS server. On my clients I have no issues running backup, server base AV, defraggers, other small DB programs (Access) etc.
Dell's top end controller, SAS for all drives, figure a hot spare drive,( possibly global), raid 1 for the OS/programs (75 gig is sufficient), raid 10 for data (4-6 disk), 1 or raid 5 (4-6 disks) if the DB is primarily reads, disk raid 0 for the temp/log files,pagefile (possible SSD),write back enabled, battery backup for the server system, disk defragger with option to defrag on reboot (such as PerfectDisk). Sometimes changing the stripe size from the default may speed up SQL but takes a great deal of time to figure out the best size, unless you benchmark with real data I would not change the default size. Network, if you wiring infrastructure is up to cat specs, turn off flow control on NICs or on switches will speed up network. With larger disks configurations as above, you would need a larger server or external storage, no nearline slow disks.
Lot of decent info here...
http://msdn.microsoft.com/en-us/windows/hardware/gg463392