If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Informix > 2 informix serves but diff performance

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 10-01-02, 17:55
b_ravindra_74 b_ravindra_74 is offline
Registered User
 
Join Date: Sep 2002
Location: Bellevue,WA
Posts: 20
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
Reply With Quote
  #2 (permalink)  
Old 10-02-02, 05:42
Roelwe Roelwe is offline
Registered User
 
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
Reply With Quote
  #3 (permalink)  
Old 10-02-02, 18:56
b_ravindra_74 b_ravindra_74 is offline
Registered User
 
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.
Reply With Quote
  #4 (permalink)  
Old 10-02-02, 22:25
rnealejr rnealejr is offline
Registered User
 
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.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On