Re: sybase system 10 limitation of 4 processors ?

> > In article <3luvmj$1he@athos.cc.bellcore.com> ahl@cc.bellcore.com writes: > >Hi: > > > >I am trying to find out the conceptual reason why sybase system 10 does > >not work well with more than 4 processors. I have heard that it has > >scalability problems. Is this true ? Are there any other major problems > >related to system 10 ? Is there an architectural flaw that is difficult > >to correct ? > > The technologies available to correct the scalability problem are > well-known. If Sybase wants to do it, they can correct it in short > order. There is no fundamental architectural flaw. > Sybase System 11 is positioned by Sybase as a re-architected product and is specifically designed to address the well known scalability issues. If this is so, that would indicate a flaw in the fundamental architecture. > > > >Do most database servers need more than 4 processors ? > > The scalability problem of Sybase only shows up in CPU-bound > environment. Most database installations out there are IO-bound > anyway. > I have had experience with large-scale ($2M) SMP architectures with Sybase. In situations where every bottleneck that was possible (disk,memory,network) was alieviated the Engine0 process was context switching like mad! Disk and memory are relatively cheap solutions and good SMP platforms provide excellent CPU scalability AS LONG AS THE SOFTWARE IS ARCHITECTED CORRECTLY. Sybase and Oracle both are hard at work in the R&D labs trying to catch-up to Informix in architecture. > > -- > Paul Chen, Ph.D. > consulting at DEC > Disclaimer: My opinions only! > -- //////////////// Mark Sigler, Systems Engineer ////////// // Informix Software, Inc. ////// / /// 1000 West McNab Road ///// // //// Fort Lauderdale, Florida 33069 //// // ///// Voice: (305) 781-2646 /// // ////// Fax: (305) 781-2029 // // /////// Voicemail: (800) 688-4217 x 2147 / /////////// Email: MSigler@Informix.Com //////////////// WWWeb: HTTP://WWW.Informix.Com/ --