Results 1 to 3 of 3

Thread: IDS Performance

  1. #1
    Join Date
    Feb 2004
    Location
    Tunisia
    Posts
    17

    Question Unanswered: IDS Performance

    Hi all ,

    i have used a script from www.oninit.com that analyze
    many parameters of IDS, i need yout help for optimization
    of some paramters (Read cache, PHYSBUFF, LOGBUFF, buffers allocated to index data..)

    Here is the output of the script :

    Read cache is below minimum target of 90% at 0.00%.
    Write cache is satisfactory [91.51%].
    2 deadlock(s) detected.
    0 lock timeout(s) detected.
    LRU Contention is excellent [.46%].
    0 of the last 60 checkpoint(s) were longer than 2 seconds.
    PHYSBUFF can be decreased [0.00%].
    LOGBUFF can be decreased [16.56%].
    Logical logs are OK [94% free].
    No foreground writes detected.
    Shared memory segment count OK.
    4 AIO/KAIO VPs have less than 1 I/O per wakeup.
    Read Ahead buffer usage is excellent [99.72%].
    Buffer wait ratio is good [12.70%].
    Lock wait ratio is excellent [0.00%].
    Buffers allocated to index data is dangerously high [89.44%].
    Buffers allocated to "other uses" is acceptable [0.18%].

    Thanks in advance,

  2. #2
    Join Date
    Apr 2004
    Location
    Brussels
    Posts
    57
    Hi,
    That script seems to be very nice.
    I'd like test it.
    I know oninit.com but i didn't know the script.
    Which is the URL ? (Thanks)
    Maybe you have to look at "http://www.oninit.com/database/" at the onstat references, they explain at each onstat command how to tune.
    Per exemple onstat -p handles about read cache and write chache, ...
    And good stuff at :http://www.informix.kiev.ua/articles...or/monitor.htm


    Bye,
    Yves & Willy

  3. #3
    Join Date
    Feb 2004
    Location
    Tunisia
    Posts
    17

    Arrow

    Hi,

    Go to http://www.oninit.com/scripts/index.html
    (Health check script)
    Have fun

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •