You are here: Re: Tuning on Oracle 10g and SQL Server 2005 « MsSQL Server « IT news, forums, messages
Re: Tuning on Oracle 10g and SQL Server 2005

Posted by Tony Rogerson on 05/04/06 14:24

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" <marcio.evangelista@ig.com.br> wrote in message
news:1146686225.668586.86960@i39g2000cwa.googlegroups.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
>

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация