Przemol, I prefer to use the FX class when running with many more processes than CPUs in an OLTP setup, where the processes do no scream for CPU. When lots of context switches happen the FX class gives me better throughput and a more constant behavior.
In the "old" days (before FX) I used RT and put the log writer and dbwriter in that class to give me just that little bit of extra performance. All these experiences are from benchmarks of many types. Lets hope that in this context these do represent "real life behavior" :-) --Paul. On 29 apr 2008, at 08:30, [EMAIL PROTECTED] wrote: > Hi all, > > I have encountered mixed opinions regarding which scheduler is > better for OLTP databases (mainly: Oracle). Solaris Internals site > http://www.solarisinternals.com/wiki/index.php/FX_For_Databases > http://www.solarisinternals.com/wiki/index.php/Application_Specific_Tuning#Tuning_Recommendations > recommends using FX for databases. > However http://blogs.sun.com/travi/entry/database_scaling_on_sun_fire > says: "We also tried different scheduling classes. FX as well as RT > but noticed that at even at high throughput the default TS scheduling > class performs the best.". > > While the former says in general the latter is strictly for CMT cpu. > But I don't belive (am I wrong ?) that it depends on cpu type. > Can anybody share his/her experience with changing scheduler for > OLTP (Oracle ?) databases ? > > Regards > przemol > > -- > http://przemol.blogspot.com/ > > > > > > > > > > > > > > > > > > > > > > ---------------------------------------------------------------------- > Szalony rowerzysta ucieka policji! > http://link.interia.pl/f1d9d > > _______________________________________________ > perf-discuss mailing list > perf-discuss@opensolaris.org Regards, Paul van den Bogaard --------------------------------------------------------------------------------------------- Paul van den Bogaard [EMAIL PROTECTED] ISV-E -- ISV Engineering, Opensource Engineering group Sun Microsystems, Inc phone: +31 334 515 918 Saturnus 1 extentsion: x (70)15918 3824 ME Amersfoort mobile: +31 651 913 354 The Netherlands fax: +31 334 515 001 _______________________________________________ perf-discuss mailing list perf-discuss@opensolaris.org
