Run Queue
936749Jun 8 2012 — edited Jun 8 2012Hi,
I have a system with 31 databases running and when running vmstat 5 5 I get the following:
procs memory page faults cpu
r b w avm free re at pi po fr de sr in sy cs us sy id
43 12 0 9384607 9197758 0 0 24 11 0 0 414 49939 704738 29358 52 17 31
43 12 0 9384607 9186170 0 0 1 3 0 0 0 40638 1085122 38446 85 14 1
50 8 0 9467427 9172458 0 0 1 4 0 0 0 44732 1237572 46874 82 15 3
50 8 0 9467427 9220610 0 0 0 4 0 0 0 39450 1204662 51553 82 15 3
45 12 0 9446969 9197194 0 0 0 4 0 0 0 44293 1004155 40134 81 17 3
If the formating above is ok you could see that run queue is 43 - 50 on these 5 samples. This is on a 16 CPU(grid control info) HP-UX Itanium server.
If I look in Grid control I get the following info:
Real Time Statistics
Current Value 1.64
Average Value 2.0
High Value 2.73
Low Value 1.64
Warning Threshold 10
Critical Threshold 20
Occurrences Before Alert 6
Corrective Action None
Why the big difference?
Also I've tried to run vmstat several times and it always show 25+ in Run Queue
I think we have problems with CPU resources(and then again performence in databases) and trying to document it.
Regards
933746