Alan Hargreaves' Weblog
The ramblings of an Australian SaND TSC* Principal Field Technologist
* Solaris and Network Domain Technology Support Centre - The group I work forTags
(update 1) acoustic bind birthday blues bugs cec cec2007 cec2008 china cmt contention cringley debugging dogs dtrace earthquake encumbered-binaries extra flash funny google guitar halloween huron install kids linux liveupgrade locking mdb music mysql newyear niagra openjava opensolaris oracle patches patents percussion performance redhat secondlife security solaris sru sun support sxcr t2 t2000 timeslider ufs upgrade virtualbox windows youtube zfs
Tuesday Mar 03, 2009
My CMT machine loads Oracle Databases slower than ..
This is more of an "Oh no not again" type post, ...
I am constantly amazed at the number of escalations that make it to the performance group with this as the problem.
It really is a case of an unrealistic expectation and knowledge of what the machines excel at.
The most recent of these to cross my desk talks of a customer concerned that a dual core 2.5GHz x86 based box loads data into an Oracle database much faster than his shiny new T5220.
Until such a time as Oracle makes their SQL Loader run multi-threaded (which may bring in problems all of their own) this will always be the case.
The design of the system is such that it will run single threaded applications much slower than the x86 counterparts. These machines, however, come into their own once we enter production and start getting lots of parallel requests on the database. As we are running far more cpus, the load on the database must be much higher before we start to see any significant degradation.
The question that really should be asked here is, "Where do you want your performance? In the database load that you will do once, or in responding to production queries?"
Posted at 06:30PM Mar 03, 2009 by Alan Hargreaves in Solaris | Comments[4]
Subscribe!
