Avatar of bhunger
bhunger
Flag for United States of America asked on

Dissapointing Performance after Migrating from dell R810 to R730 with Oracle Enterprise

We are upgrading an Oracle Enterprise server from a Dell R810 with 4 attached MD1200's (sas2 w/6g bus) to a Dell R730 with three attached MD1420's (sas3 w/12g bus).  R810 has four cores with 4 cpu threads and the R730 has two physical cores (2.6 GHz) with 8 way cpu's (3.2 GHz).  Drives on both systems are 15k.  Ram in each is 256gb (of course, the ram in the r730 is faster).

Problem is that we're only seeing 10-15% performance lift in the new server.  We expected much more. Lastly, the drives in both machines are SED.

Any ideas on getting better Oracle performance?

Thanks--
* Oracle12cDellOracle Database* DELL HARDWARE

Avatar of undefined
Last Comment
andyalder

8/22/2022 - Mon
CompProbSolv

Nothing specific about Oracle, but when there are performance issues I look at Resource Monitor to see what is being maxed out.  This assumes you are running Windows.  Other OSs should have something similar.

If you do simple file transfers how does that speed compare to what you had in the old server?
bhunger

ASKER
It's a Solaris 11 box.  The cpu shows low contention.  Normaly, disk i/o has been the biggest performance variable in our systems, so I thought the faster sas 3 / 12g speed would be really noticeable. Can't move to ssd's due to encryption requirements and super high costs.
andyalder

You have fewer physical disks before but it actually runs a bit faster? I'd be very happy with that.
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
bhunger

ASKER
Andy, the old MD1200's have 12 x 3.5" drives and the new MD1420 have 24 x 2.5" drives.  So, I've attached a toal of 48 drives to the old system and 72 drives to the new system.
arnold

did you follow the tunning of the system kernel, as well as

How big are the DBs?

Are the MDs on the new chained over the same BUS or you have multi-path/<ulti-channel?

how many external Perc H8xx do you have in the R730 versus.

two processor dual core with hyperthreading enabled.

your CPU breakdown is unclear " R810 has four cores with 4 cpu threads and the R730 has two physical cores (2.6 GHz) with 8 way cpu's (3.2 GHz)"
in whcih memory configuration did you setup the new server, optimal,. mirrored? multi-channel?


look at iostat, vmstat, to see where the bottleneck is.

consider the demand on data is going through a perc8xx which handles both RAID of the

are you using both controlling modules to connect/chain the external enclosures.

does the new setup matches replicates the old one? topology./arrangement?
ASKER CERTIFIED SOLUTION
schwertner

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
andyalder

Sorry I was wrong about the number of disks so it must be some tuning issue, however if you are using Dell PERCs you can still use a few SED SSDs as read cache using CacheCade.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.