April 11, 2007 at 12:09 pm
I just looked at the TPC results and noticed that Sql Server really can't compete with Oracle (or DB2) in the clustering arena. SS does great in non-clustered machines. 2005 addressed a lot of the aintenance/availability/larger database issues as well, so this seems to be Sql Server's only major weak area.
Is Sql Server going to push itself into the clustering arena more strongly? Does anyone MS's plans?
April 11, 2007 at 2:55 pm
As far as I can see, that's the only cluster participating in the TCP-C benchmark... which makes those results pretty useless.
As you stated yourself, MS SQL Server does a great job in non-clustered machines:
If you check out these results, you will finds lots of MS SQL Servers in the top performers list: http://www.tpc.org/tpcc/results/tpcc_advanced_sort.asp?PRINTVER=false&FLTCOL1=tpcc.c_original_recv&FLTCOLOPR1=%3E%3D&FLTCHO1=2006-01-12&ADDFILTERROW=&filterRowCount=1&SRTCOL1=tpcc.c_tpmc&SRTDIR1=DESC&ADDSORTROW=&sortRowCount=1&DISPRES=100+PERCENT&include_withdrawn_results=none
Furthermore, if you look at price/performance (your financial manager will like that very much), MS SQL leads the pack: http://www.tpc.org/tpcc/results/tpcc_price_perf_results.asp
Btw the TPC-C is about OLTP performance, while clustering is about availability, that's probably the reason why so little clustered environments participate in those benchmarks.
_____________________________________________________
Do not go past the mark you aimed for, but learn when to stop.
You can find me on LinkedIn.
I support The Programmer's Bill of Rights.
MCITP, MCDBA, MCSD
April 11, 2007 at 5:06 pm
I agree with you that by definition clustering is not really for performance. But, in fact, if you look at the 300G-10T TPC-H results, it shows that clustered is just as fast as non-clustered.
In fact, Sql Server has almost no presence in the 300G+ size for either clustered or non. Could this be because all the big, fast results are running on Unix/Linux? Or does Sql Server itself bog down at the bigger sizes?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply