Re: ** FOR IMMEDIATE RELEASE - RECORD-BREAKING TPC-C RECORD!! **
Posted in 1995
Topics: Performance & Tuning
jlee@panix.com (John Lee) wrote: >In <4727g0$4pq@terminus.intermind.net> an350133@anon.penet.fi (Wow! That's fastttttttt) writes: > >I attended the Sybase's SYSTEM 11 rollout thing this Monday in NYC. I'll >say about 400-600 people showed out. Some _very_ impressive TPC-C benchmarks >numbers were mentioned for HP, SUN, and DEC boxes. But due to my normally >bad memory, I cannot give any real numbers(so please don't flame me for my >bad memory). I'm impressed by System 11 too. I'm not surprised that it has some great performance numbers. It's a wonderful system, IMHO. >They had a Sun SparcCenter-2000 with 20 cpus on the stage running some >app. (I think the app was a real-world app. from one of the beta test >customers). They started out with 4 cpus and gradually ramped up to 20 >cpus, the server scaled beatifully utilizing all 20 cpus evenly(unless >they tweaked the perf. monitor:-) ). In addition to the fact that System 11 scales beautifully to the number of cpus, it scales also beautifully to the number of users (partly due to the per-session private log cache.) By the way, it is the only DBMS I know of that can scale well to a large number of concurrent users. >They also had IS directors from Bankers Trust, Swiss Banc, Nielson(sp?, >they do tv ratings/surveys), and PeopleSoft singing praises about the >perf. improvement and stability(which is important to me). Great. >There's performance impovement across the board, from index builds, bcps, >db dumps/loads, complex queies, to dbcc......and we are not talking about >improvements of just 50% but hundreds of percents. Tunable io size, ability to "pin" an object or even an entire database (such as tempdeb) in memory, user-controll of buffer replacement strategy (LRU vs MRU), ..., and so on, all contribute to the huge performance gains. Sybase has a product family that they can be proud of. This is not all. Just wait for the bitmap index technology they got from Expressway to come along, and we can expect to see orders of magnitude performance jumps for some typical decision support workloads. >Basically, what I'm trying to say is that don't even bother trying to >refute what people say about Oracle because System XI is going to kick >some serious a__. Personally I can't wait go get my hands on it :). Agreed. Buy Sybase. Paul Chen, Ph.D. surfing the net from home