June 23, 2014 at 8:31 am
Hi -
I have two servers, one with 80 cores and another with 64 cores. Both are HP 980's. Different chip set and both connected to a flash appliance.
My question - is there anyone running a windows cluster and SQL server with nonlike for like hardware?
June 23, 2014 at 8:40 am
With different chip sets, you couldn't just restore a backup of one at the operating system level on the other machine. You could restore a SQL backup, just not an OPSYS one, without a tested process for updating the drivers. I was a server break-fix tech in the late 90's and we had tested restoring an opsys backup to dis-similar hardware, and we did eventually make it work, after considerable tweaking and testing. We had to do so to allow our DR vendor to have some shot at providing sufficient server hardware for a DR scenario. Does that help?
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
June 23, 2014 at 8:47 am
cheshirefox (6/23/2014)
Hi -I have two servers, one with 80 cores and another with 64 cores. Both are HP 980's. Different chip set and both connected to a flash appliance.
My question - is there anyone running a windows cluster and SQL server with nonlike for like hardware?
This is certainly doable, and I have client's doing it. Hopefully with the shiny recent/new hardware you are also on new(er) Windows Server OS versions (2012 or even better 2012 R2). LOTS of scalability and clustering improvements in those builds!
I hope your DL980s work better for you than I have heard and seen in the past!!
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
June 25, 2014 at 7:54 am
cheshirefox (6/23/2014)
Hi -I have two servers, one with 80 cores and another with 64 cores. Both are HP 980's. Different chip set and both connected to a flash appliance.
My question - is there anyone running a windows cluster and SQL server with nonlike for like hardware?
Not ideal but doable, most important is to ensure the nodes are on the same OS and software patch level, also wise to ensure the same NIC hardware is used as different NIC hardware usually have different features
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 25, 2014 at 1:13 pm
One thing to make sure of is that the weaker server (the 64 core machine) will be able to support the whole load. With a 20% difference in cores between the two machines, you may get surprised when the 80 core machine goes on break.
June 25, 2014 at 2:04 pm
Also be careful if using cpu affinity in the sql instance . If you apply affinity on the 80 core system and it tries to failover to less cores the instance may fail to start.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply