Now, we have more performance alert point than previously, we just had performance alert based on the load average and active sessions. I were wondering that we will receive too much performance alert and it may bother our lifes. But it doesn't happen, because no alert reported by mistake, it really help us find out new problems on database or application layers.
The oldest performance alert, came from Nagios based on the load average.
WARNING - load average: 9.03, 5.70, 4.36
With the older version of oramon, new performance alert added with active sessions.
High Active Session on xxxxxx,
05/21-10:41:01 Load 2.73, Act: 45, Enq: 0
In the current version of oramon, more performance data is reported in alert message.
High Load on xxxxxx, 2009.05.21 10:41:01
Load 2.73, CPU:7/29/19 Swap: 1, Act: 45, Enq: 29, PQ: 0
We got some enqueue wait sessions alert, which help us get to know the problems exists in out database and application, so we can get it resolved before it really degrade our availability.
Comments (2)
Im actually looking for related pages. I'm Glad I your site. Thanks
Posted by kasdfkn | December 14, 2009 11:54 PM
This article is SO bookmarked
Posted by lez | December 15, 2009 12:10 AM