Tuning on Oracle 10g and SQL Server 2005

[mleal]

Does anyone have some more detailed information about how Oracle and MS
implement / allow Tuning on Oracle 10g and SQL Server 2005 and the
differences between them?

Which of them, In a deep comparison about it, allow better tuning and
why.
Regards,
Marcio Evangelista

[Greg D. Moore \(Strider\)]

"mleal" <ma****************@ig.com.br> wrote in message
news:11*********************@i39g2000cwa.googlegro ups.com...

Does anyone have some more detailed information about how Oracle and MS
implement / allow Tuning on Oracle 10g and SQL Server 2005 and the
differences between them?

I really can't help there.

Which of them, In a deep comparison about it, allow better tuning and
why.
"Both and neither". This is a religious question. Both sides will argue
that their system is better, can tune better, etc. If you go by TPC
benchmarks, I think right now SQL Server is "beating" Oracle. But that
could also just mean Oracle hasn't come up with a new test bed yet. (and if
they are "winning" now, it'll only be a matter of time before Microsoft
responds :-)
In any event, generally both can be highly tuned and optimized by people who
know the systems well enough.



Regards,
Marcio Evangelista

[Tony Rogerson]

My only comment would be that the tuning tools such as Database Engine
Tuning Advisor and SQL Profiler come as part of the product set (and price)
whereas with Oracle you need to spend a lot of money on the tuning advisor
tools seperately.

In terms of server tuning a lot is done for you by SQL Server, you don't
need to tweak many things, in fact I rarely ever need to use sp_configure to
change anything except fixing memory size.

Tony.

--
Tony Rogerson
SQL Server MVP
http://sqlserverfaq.com - free video tutorials
"mleal" <ma****************@ig.com.br> wrote in message
news:11*********************@i39g2000cwa.googlegro ups.com...

Does anyone have some more detailed information about how Oracle and MS
implement / allow Tuning on Oracle 10g and SQL Server 2005 and the
differences between them?

Which of them, In a deep comparison about it, allow better tuning and
why.
Regards,
Marcio Evangelista

[DA Morgan]

mleal wrote:

Does anyone have some more detailed information about how Oracle and MS
implement / allow Tuning on Oracle 10g and SQL Server 2005 and the
differences between them?

Which of them, In a deep comparison about it, allow better tuning and
why.
Regards,
Marcio Evangelista

The tuning on the two systems is vastly different from multiple
standpoints. Speak with respect to Oracle most tuning done these
days is done using built-in tools that take advantage of Oracle's
wait interface, AWR (Automated Workload Repository) and ASH (Active
Session History).

Included in the Oracle kernel is an instrumented capability to see
and evaluate what is happening at both the database, operating
system, and hardware levels. Statistics are collected at predetermined
intervals (often enough to be useful, not so often as to burden the
system) and can be viewed through SQL queries (used by the dinosaurs)
through OEM, DBConsole, and the Grid Control.

When I look to tune queries in Oracle I use EXPLAIN PLAN AUTOTRACE,
and 10046 and 10053 traces. In 9i I use StatsPack. In 10g I use AWR,
ASH, and the Grid.

If you want to get an idea of the granularity of information
instrumented in Oracle go to www.psoug.org. Click on Morgan's Library,
then click on DBMS_SERVER_ALERT. The tables at the top of the page
show most of the metrics collected.

HTH

Daniel Morgan
www.psoug.org