RE: Physical I/O and databases other than oracle

> -----Original Message-----
> From: rgaffuri_at_cox.net [mailto:rgaffuri_at_cox.net]
> Sent: Friday, October 03, 2003 3:15 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Physical I/O and databases other than oracle
>
>
> my email states that in oracle this isnt true. HOWEVER, what
> about other databases?

At the risk of trivialising things, there are basically no differences with other databases. It's a question of how quickly the DBA community for a given database has woken up to the fact that BCHR is a rarely-useful measure.

For instance, the DB2 people worked this out a long time ago (though they still focus heavily on buffer pool tuning, as many of them genuinely have physical i/o issues with the huge batch jobs they run). As for the SQL Server people, the light is only just starting to dawn. 90% or more of the performance posts to the sql2k list (see www.sswug.com) start with "My windoze box has 2GB of RAM, and my instance has 99.9999999% hit ratio, but performance is still a dog. Help me add more memory". Gentle attempts at suggesting they attempt to find the real culprit, rather than guess, are howled down in the stamped of the hit ratio mob.

Ciao for now
Fuzzy
(It's good to be back)

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Grant Allen
  INET: Grant.Allen_at_towersoft.com.au

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).