Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
-
Monitor DB Health.
Any idea about my buffer wait problem? Thanks!- jpt54
- Post #7
- Forum: Informix solutions
-
Monitor DB Health.
Ouch, i need more help. I have raised the buffers value to 50000 (was 5000) and the BR ratio is still very high: ------------------------------------------------------------------- Informix Dynamic Server Version 7.31.UC5 -- On-Line (Prim) -- Up 4 days 01:39:09 -- 176128 Kbytes Profile...- jpt54
- Post #6
- Forum: Informix solutions
-
Monitor DB Health.
Thanks for your ansmers. I will try to increase the Buffer value. The "Healthcheck" script is great but i would be really pleased if an informix specialist can give me a ranking of the more usefull ratio to check: -The ones that you HAVE TO check! (that's what i called "Key...- jpt54
- Post #4
- Forum: Informix solutions
-
Monitor DB Health.
Hi, I'm trying to build a script which retrieve "health" key ratio from my Informix 7.3 DB. Here is the info i retrieve, most of them from onstat -p output: ReadCache_pct_used WriteCache_pct_used BufferWait_pct (=BUFWAITS/(PAGEREADS+BUFWRITS)) LockWaitpct (=(LockWaits/Lockrequest)...- jpt54
- Thread
- Replies: 8
- Forum: Informix solutions
