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.
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.
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)
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.
wi-tribe
5 Posts
2710
0
Posted May 30th, 2018 01:00
The SR already opened and below are the recommendation