UNSOLVED

wi-tribe

updated

8 years ago

WT

wi-tribe

5 Posts

0

3562

May 29th, 2018 21:00

poor performance

Hello Every one

we are running oracle 10g RAC on HPUX 11iv3 connected with unity300 as storage. other systems are also connected with the same storage running windows 2012 and oracle linux, centos 7.

we are having performance issue at storage might be because when ever there is a load on oracle 10g RAC servers during billing days specially the other server like windows and linux connected on same unity300 storage all our application becoming slow and after some time become dead slow.

secondly whenever we trigger backup of oracle 10g, right after 3 - 4 hours all the applications become dead slow.

can any one help us how to troubleshoot this and from where to start?

we have flash2, SAS 10K and NL SAS in a single pool of 45 TB of usable space. from that pool we created 10 blocks of 500 GB each for our oradata presented to oracle 10g RAC. from same pool different sizes of space also given to linux and windows boxes.

  • wi-tribe

    5 Posts

    2710

    0

    Posted May 30th, 2018 01:00

    The SR already opened and below are the recommendation

    • 1-      Reducing read size IO from the application where back up is being done as it’ s the main factor aligned with high response time seen on LUNs side & triggering its peak values.
    • 2-      Since SAS drives are overloaded during backup time and Extreme performance tier is almost full , we need to add extra flash drives to the pool  and check if our main issue is enhanced , if not , we will need to reduce read size as explained previously.

  • AndreD Dell

    Moderator

    239 Posts

    2710

    2

    Posted May 30th, 2018 01:00

    wi-tribe, at first glance from what you are describing, it seems like the array may not have been sized/configured correctly for your environment's needs.

    Having said that, this is not the place for this kind of troubleshooting.

    Please open a Service Request for the perf team to take a look.

    We would require:

    - a very clear description of the issue

    - all the time stamps of when the issue was observed (including timezone of the observation so we can match to our logs)

    - Unity data collects (https://support.emc.com/kb/483583)

    - UPA files (Unity Perf Archives) covering the times in question (https://support.emc.com/kb/491175)

    Once we have all of this, we will help you narrow down the cause.

    Thanks

    Andre @ Dell EMC

  • AndreD Dell

    Moderator

    239 Posts

    2710

    0

    Posted May 30th, 2018 06:00

    Yes, so the issue seems fairly obvious. There is very little we can do if the drives are overloaded.

    My initial suspicion was correct where I said: "wi-tribe, at first glance from what you are describing, it seems like the array may not have been sized/configured correctly for your environment's needs."

    You need to reach out to you sales rep or implementation partner, or account manager to see if a new full environment assessment can be done, and then design the system based on your requirements.

  • SKT2

    2 Intern

    1340 Posts

    2710

    0

    Posted May 30th, 2018 07:00

    How will you manage to reduce the read IO size?  When the read is sequential especially during the backup the IO size is going to be higher.

  • Rainer_EMC

    6 Operator

    8645 Posts

    2710

    1

    Posted May 30th, 2018 07:00

    If its block you could also look at QoS

  • kelleg

    6 Operator

    4537 Posts

    2710

    0

    Posted May 30th, 2018 08:00

    wi-tribe - what is the SR number?

    glen

  • wi-tribe

    5 Posts

    2710

    0

    Posted May 30th, 2018 17:00

    Below are the SR number

    SR# 10276103

    SR# 91383920

    SR# 09999650

    SR# 11014415

    SR# 10199664

  • wi-tribe

    5 Posts

    2710

    0

    Posted May 30th, 2018 17:00

    to reduce the size i think we can lower the number of streams.