Actually there are wait stats in SQL server that you can only see with
Precise Indepth for SQLServer ;-)
"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).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Broodbakker, Mario
> INET: Mario.Broodbakker_at_hp.com
>
> 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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Anjo Kolk
INET: anjo_at_oraperf.com
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).
Received on Tue Feb 18 2003 - 11:39:32 CST
