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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).