Anybody knows this?
Thanks a lot.....
orz~

"Steven" <songxin328 (AT) gmail (DOT) com> wrote

43


In all seriousness your question is near the level of "What is the meaning
of life?" What do you mean by cost? License cost? Site license cost (for
how many servers with how many CPUs, etc)? Over what time span? Or perhaps
you are asking about cost based optimizers?

Yeah, actually, I mean the cost based optimization.
I think in general they were based on System-R model in calculating
the execuation cost.
that is: Total cost = i/o cost + cpu cost

but Is there anything different when to implement this formula?
I read this article below
Cost Control: Inside the Oracle Optimizer
and I am looking for similar articles about other dbms...
=========
Anyway, 3x for your reply~


Carl Kayser wrote:

On 21 Apr 2007 01:19:30 -0700, Steven <songxin328 (AT) gmail (DOT) com> wrote:

Don Tov wrote a book on sql tuning published by O'Reilly discussing
Oracle, DB2 and sqlserver.
Please do not top post.

--

Steven wrote:
I am not aware of person or persons that have done the hard work of
Oracle experts such as Jonathan Lewis and Julian Dyke with either DB2
or SQL Server.

In SQL Server, likely, the tools to do so don't even exist in the
product.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

On Apr 21, 12:59 pm, DA Morgan <damor... (AT) psoug (DOT) org> wrote:
Exist to do what? There is lots of info on the SQL Server QP,
especially in SQL 2005. I'd start with the Inside SQL Server T-SQL
Querying, Any docs on the dynamic management views, this blog:
http://blogs.msdn.com/craigfr/ and there is a new book in the inside
SQL Server series coming on query optimisation?

-Euan

euan.garden (AT) gmail (DOT) com wrote:

Pick up a copy of Jonathan Lewis' Cost-Based Oracle Fundamentals.

I don't believe the tools exist in the product to allow this type
of research.

Not to mention there is no equivalent to X$ anything, GV$ anything,
ASH or AWR. The metrics are just are not there to analyze.

Is there a SQL Server equivalent of a 10053 trace?
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

On Apr 22, 11:15 am, DA Morgan <damor... (AT) psoug (DOT) org> wrote:
You know Danel if you ever want to have a meaningful conversation
about this stuff then you need to stop thinking in Oracle technology
terms and start thinking in customer solution terms, that way we can
actually compare Oracle to SQL Server, DB2, MySQL etc.

Does SQL Server have a feature called AWR? No but if I try and
abstract it out (feel free to correct me its been a while since I used
10g) AWR feels like an analytical/DW store that maintains history for
a bunch of "operational" metrics about the database and the systems
associated with it. That is then used as the source for some rules( is
this where ADDM comes into play).

Assuming for now my interpretation is somewhat close then SQl Server
does expose internal structures and state via Dynamic Management
Views, some of those views actuqlly maintain history (although by no
means would I call them a DW). You can see this by using the
management reports in management studio as these are mostly based off
DMVs.

There are several different samples that are shipped by MS and the
community ( the latest of which is a performance dashboard shipped by
the customer support team) that are much more analytical.

Now I have no doubt that your first response is going to be that these
are not as complete as AWR, that may or may not be true, but again
thats not the issue. SQL Server does not have as many switches and
knobs as Oracle (and yes we can argue over this for ever but right now
the 2 companies have different philosphies on this sort of stuff, lets
agree they are different and that has implications in terms of how
much info is needed in an operations analytics tool) and hence it may
be ok that there is less info in the SQL Server solution.

in terms of plan generation. Seems like a good tool to have, there are
ways of debugging plans in SQL Server they may or may not be as good
as the 10053 trace, without spending time debugging both on real
systems I couldn't say.

Seems like ASH and x$ are related to diagnostics and history of wait
events, as these are different in SQL Server and Oracle again I am not
sure there needs to be a match. There was a lot of effort put into
documenting the wait states in SQL Server 2005 and there have been
plenty of articles written about them. I am pretty sure there are
DMVs related to this but I don't remember them all off the top of my
head.

However the point here is that I don't hear of a lot of people asking
for ASH like functionality relating to wait states in SQL Server so
perhaps they are less of an issue given the different architectures.

euan.garden (AT) gmail (DOT) com wrote:

Wonderful idea. Lets talk about Oracle and not use Oracle terms and
talk about SQL Server and not talk about Microsoft terms.

I suggest we use the following common terms to begin the discussion.

1. Database
2. Instance
3. Log File
4. NULL
5. Temp Table
6. Transaction
7. Locking
8. Cluster

You go first.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

On May 27, 11:42 am, DA Morgan <damor... (AT) psoug (DOT) org> wrote:
LMAO you know sometimes I wonder why I bother having alerts on this
forum and then you post something like this, oh the entertainment
value.