Re: Know 1 database, know them all?

Not quite true, as far as I know.... There's wait stuff in there, although not enough to my taste. There's cpu in there, and the start and stop time, which makes it possible to at least make a crude R = S + W, where the difficult part is breaking down the W into meaningful stuff. A long way to go, but I think they're aware of it. The guys from SQL Server Development I spoke to about it were very interested in the method and liked the whole idea.

But don't forget that I'm always wrong.

Mogens

Broodbakker, Mario wrote:

>Mogens, the only problem with your statement about 'oracle myths & king of the new world' is that the only way of looking at SQLServer performance is probably looking at ratio's: there are no wait statistics, there is one(1) latch wait counter though! for the complete system :( (apart from some other almost useless perfmon counters, taht is..)
>
>regards,
>Mario
>
>
>-----Original Message-----
>Sent: maandag 17 februari 2003 23:29
>To: Multiple recipients of list ORACLE-L
>
>
>I see it from a slightly different (and probably wrong) angel, at least
>regarding the performance of things and databases: If you've worked with
>Oracle databases for some time (and have real experience), and know
>about the myths and their anti-thesis (use the wait interface instead of
>the €&#% ratio crap, know about RAID-5, don't have too many indexes,
>concentrate on LIO instead of PIO, etc.,etc.) you'll do quite fine. As
>Peter Gram once said to me: It's all about getting a database to perform
>on a platform.
>
>You can take your old presentations regarding Oracle myths and change it
>into a SQL Server or mySQL presentation, change a few details, and be
>king in the new world.
>
>Mogens
>
>Robert Eskridge wrote:
>
>
>
>>Curiously, the basics are common across styles of cooking. You have
>>to learn to coax the flavors out of the fresh ingredients and transform
>>them into the proper texture and finish. Once you've mastered Italian
>>cooking, you may not be a top notch German cook, but you're probably
>>just a recipe or two away from being able to produce a very nice
>>German meal...
>>
>>Databases have a certain similarity. If heading an Oracle project and
>>I was given the choice between two people to work on my project, one
>>having been the lead architect for a top notch product based on
>>Sybase, and the other being an OCP that had worked on lack luster
>>products, it would be hard not to pick the former.
>>
>>
>>
>>F> Following the same logic..... if I learn to cook a good Italian dish, then I
>>F> must automatically be an expert in preparing top-class Chinese, German,
>>F> Malay, Hungarian and French cuisine .... Yeah, right !
>>
>>F> Ferenc Mantfeld
>>
>>
>>
>>
>>
>
>
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
  INET: mln_at_miracleas.dk

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).