Oxiel,

Without going into some performance and hardware specifics, are you
aware that migrating your Oracle application to MSSQL could end up in
bad performance.
The optimizer, locking etc are handled in different ways in MSSQL then
Oracle. I have been called in a few sights which converted from MSSQL to
Oracle 1 to 1 and had many
performance problems. I have helped organisation migrating from Oracle
to MSSQL and they experienced similar problems.

Now a cheaper license might look attractive at face value, but with one
of my clients it took almost 2 months to fix the performance problems
and also to re-write packages.

As someone else stated, you also need to take in consideration that you
will have to re-train your dba's. If your managers believe that moving
to MSSQL is going to be a big cost saver
then they are going to face a few interesting surprises. If you
calculate the true cost and not just the license cost over a 5 year
period, you will find that the difference is not that big.
Now you could have the luck that you have simple applications, which
basically only use tables and a few indexes and maybe a few views. In
those cases your migration will
be fairly straight forward.

As an alternative you might consider downscaling your Oracle license. A
lot of organisations have Enterprise Edition licensing and use non of
the features. In that case you could
possibly scale back to Standard Edition or even Standard Edition One.
However you need to make that decision carefully and look at the future
where you would like to be.
My experience with the MSSQL Server licence in Australia is that there
is not much difference in price if you get the Enterprise Edition or
Standard Edition. Make sure you compare
apples with apples.

Good luck,
Raymond


Oxiel Enrique Contreras Vargas wrote:

>Hello friends.
>
>That's it, a friend's boss has received the "great proposal" from MS to switch
>from Oracle 8i/Tru64 to MSSQL/W2K, at "really low prices and without
>precedent performance", so now testings are been done, in order to migrate to
>10g/Linux or MSSQL/W2K over itanium, which ever perfoms better.
>
>We're trying to convice people to stay at the 10g/linux side.
>
>I've searched tips to tune 10g over sles9 for itanium, but couldn't find
>something clear, so this is the best place to ask for help.
>
>This is the server where all the tests are being done:
>
>HP rx4640 with Itanium2 processors
>4Gb of RAM
>One internal SCSI Disk (80GB)
>
>Oracle 10gR2 with patch applied.
>Kernel updated for SLES9 - 2.6.-7.257-default
>
>Swap 8 GB
>
>Root partition, opt partition and oradata partition were created on the only
>disk with ext3.
>
>The data partition for oracle has ext3 with writeback option mounted as
>previos messages from this list were advicing.
>
>Default kernel settings from /etc/sysconfig/oracle are been used,
>and /etc/security/limits.conf values for oracle user according to Oracle's
>installation guide.
>
>What else can i do in order to squeeze speed to oracle/sles9 ??
>
>Thanks in advance.
>
>Oxiel
>Chiacchiera con i tuoi amici in tempo reale!
> http://it.yahoo.com/mail_it/foot/*http://it.messenger.yahoo.com
>
>
>

--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting