Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2002
    Location
    Bellevue,WA
    Posts
    20

    Unanswered: 2 informix serves but diff performance

    We have 2 informix servers with same configurations and exact replica of every setup and configuration.They server the same application and the requests are directed thro' the load director.The servers are p03 and p04

    I am observing the number of lockwaits on p03(66) are double the number of lockwaits on P04(30)
    even though p03 has less number of lock requests(19408965) compared to p04(22266795).

    There has been an overshoot of lockwaits on p03 from 14 to 66 during the weekend whereas as on p04 it is from 21 to 28.

    Why is this inconsisytency b/w the servers.At any time they have the same number of transactions and sql's.

    Thanks

  2. #2
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534

    Re: 2 informix serves but diff performance

    How do you keep the servers in sync?
    66 lockwait is not much.
    If the number of lockrequests is different between the servers, it means the server with the most lockreqs has the most work.
    Are u sure there is no difference in config?
    f.ex.
    row/page locking?
    rws

  3. #3
    Join Date
    Sep 2002
    Location
    Bellevue,WA
    Posts
    20
    The servers are exactly same in configuration and serve the same purpose.They talk to the same application and load disributed.Right now the lock waits are definately under control but was keen to know the reason why there was big difference in the number of lock waits b/w the servers.

    We just found out for some reason one box was getting most of the load comapred to the other.

  4. #4
    Join Date
    Feb 2002
    Posts
    2,232
    So much for load balancing. You should clear your stats periodically on both servers at the same time so that you can verify that the servers are being used relatively the same - so if load balancing is failing for some reason you can see it.

Posting Permissions

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