Unsolved
This post is more than 5 years old
6 Posts
0
9488
May 18th, 2011 09:00
Looking for CPU performance info between Intel and AMD solutions for Microsoft SQL
I'm looking for some information on performance in MS SQL between the Intel and AMD CPUs in that application environment. We are looking to upgrade our old clustered servers to build up and out.
I'm currently looking at the r715 and the r710 series. With the 715 I'd like to use the AMD 6180SE which is an updated version of the 6176SE. For the r710 I'm looking at Intel's x5660.
Both servers will have 16 8GB DIMMs and will have SAN attached storage to house the data and logs. Both servers in the same configuration (sans CPU) have a minimal price difference. The AMD config will have 24 cores total and the Intel will have 12 cores total. The core count edge goes to the AMD and makes it an attractive option. The thing is I'm curious as to the performance between the CPU handling MS SQL.
Any white papers or online source of performance information would be beneficial.
pcmeiners
6 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
6 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