During the backup window when we have issues, 7pm - 2am, I would say high read ( but on our DB server, it would be reading from one hdisk/LUN and write to another hdisk/LUN ). During the day, however, much higher reads.
Looking at Cache performance for node2 and node3, Read Hit % is between 40% and 60% most of the time it looks like, occasional jumps to 80% 90%. Write Hit % during the day around 30%, then mostly falls off during the evening.
Lock blocks is zero.
And Page States, the Clean stat is around 630,000, while everything else is at 100,000 or less most of the time. I do see a bump in the other Page States during the overnight ( as Clean consequently drops ).
Port utilization is very, very high on the front-end. I asked support about it, thinking 4x4GB ports shouldn't be so heavily utilized, but I guess it's not a matter of "yes, you are pushing nearly 16GB of data through those ports", but more of a "yes, those ports are very busy".
And mostly balanced between them, so that tells me zoning should be balanced.
But overnight, they will be at or very near 100% for extended periods of time.
|