Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2010
    Posts
    1

    Unanswered: How to get requests/sec in informix 9.4

    Hi,

    I want to get infromation about how many sql commands(include select, insert, delete, update) executed per second in Informix 9.4.

    I know I can use onlog to estimate insert+delete+update commands per second, but how to get select commands per second?

    Thanks advanced.

  2. #2
    Join Date
    Jul 2010
    Posts
    7
    You can look at i/o ops per secone in onstat -g iov. I realize that this is not your optimal answer however there are also benchmarking schemas and apps that you can download for free. See Advanced Data Tools web site for starters.

    Those are designed for use in performance tuning efforts. There may also be benchmark results that IBM would share with you although 9.4 is going to be hard to get anything out of them.

    Hope this helps,
    dan

Posting Permissions

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