dbaspot
Tags Register FAQ Calendar Search Today's Posts Mark Forums Read

Can virtual IPs cause performance problems - hp-hpux

This is a discussion on Can virtual IPs cause performance problems - hp-hpux ; We have a sybase 12.5 server on HPUX 11.0. it uses an application server. To prepare serviceguard I configured virtual IP addreses on both servers. Sybase interfaces file looks like this : DWH query tcp ether DWH 3010 ... myserver ...


Home > Database Forum > Operating Systems > hp-hpux > Can virtual IPs cause performance problems

Reply

 

LinkBack Thread Tools Display Modes
  #1  
Old 05-12-2005, 10:27 AM
Database Bot
 
Join Date: Sep 2009
Posts: 1,236,254
Database Administrator is on a distinguished road
Default Can virtual IPs cause performance problems


We have a sybase 12.5 server on HPUX 11.0. it uses an application
server. To
prepare serviceguard I configured virtual IP addreses on both servers.
Sybase interfaces file looks like this :
DWH
query tcp ether DWH 3010
...
myserver
master tcp ether myserver 3010
query tcp ether myserver 3010
master tcp ether DWH 3010

so myserver is primary IP and DHW is virtual IP.

Everything worked fine but after a while datase admin complained that
sybase
performance degraded. I had to de-condigure my vips, till we but new
LAN
cards for new IPs.
DNS entries are correct. nslookup works fine.
anybody experience this performance problem with virtual IPs? I have
never
had this problem with oracle databases.
I attach netstat -s and lanadmin -g of both servers :
on database servers.
# netstat -s
tcp:
138088897 packets sent
135139408 data packets (3907631241 bytes)
1825 data packets (2492610 bytes) retransmitted
2977392 ack-only packets (361925 delayed)
61 URG only packets
45907 window probe packets
28011 window update packets
74355 control packets
71948252 packets received
66337804 acks (for 3907667095 bytes)
99246 duplicate acks
0 acks for unsent data
8357042 packets (214257075 bytes) received in-sequence
0 completely duplicate packets (0 bytes)
0 packets with some dup, data (0 bytes duped)
122 out of order packets (70717 bytes)
0 packets (0 bytes) of data after window
12407 window probes
5470929 window update packets
92 packets received after close
0 segments discarded for bad checksum
0 bad TCP segments dropped due to state change
11050 connection requests
25273 connection accepts
36323 connections established (including accepts)
36633 connections closed (including 367 drops)
327 embryonic connections dropped
66298631 segments updated rtt (of 66298631 attempts)
246 retransmit timeouts
0 connections dropped by rexmit timeout
45907 persist timeouts
1910 keepalive timeouts
1843 keepalive probes sent
1 connection dropped by keepalive
0 connect requests dropped due to full queue
507 connect requests dropped due to no listener
udp:
0 incomplete headers
0 bad checksums
0 socket overflows
ip:
87236145 total packets received
0 bad IP headers
741 fragments received
0 fragments dropped (dup or out of space)
0 fragments dropped after timeout
0 packets forwarded
0 packets not forwardable
icmp:
20809 calls to generate an ICMP error message
0 ICMP messages dropped
Output histogram:
echo reply: 11044
destination unreachable: 9765
source quench: 0
routing redirect: 0
echo: 0
time exceeded: 0
parameter problem: 0
time stamp: 0
time stamp reply: 0
address mask request: 0
address mask reply: 0
0 bad ICMP messages
Input histogram:
echo reply: 3077
destination unreachable: 0
source quench: 0
routing redirect: 0
echo: 11044
time exceeded: 0
parameter problem: 0
time stamp request: 0
time stamp reply: 0
address mask request: 0
address mask reply: 0
11044 responses sent
igmp:
0 messages received
0 messages received with too few bytes
0 messages received with bad checksum
0 membership queries received
0 membership queries received with incorrect fields(s)
0 membership reports received
0 membership reports received with incorrect field(s)
0 membership reports received for groups to which this host
belongs
0 membership reports sent

# lanadmin -g 4

LAN INTERFACE STATUS DISPLAY
Tue , May 10,2005 14:09:14

PPA Number = 4
Description = lan4 Hewlett-Packard 10/100 TX
Full-Duplex
TT = 1500
Type (value) = ethernet-csmacd(6)
MTU Size = 1500
Speed = 100000000
Station Address = 0x306e0c96ed
Administration Status (value) = up(1)
Operation Status (value) = up(1)
Last Change = 737
Inbound Octets = 3266853009
Inbound Unicast Packets = 25171763
Inbound Non-Unicast Packets = 59586
Inbound Discards = 873
Inbound Errors = 0
Inbound Unknown Protocols = 41
Outbound Octets = 638732480
Outbound Unicast Packets = 83823248
Outbound Non-Unicast Packets = 873
Outbound Discards = 0
Outbound Errors = 0
Outbound Queue Length = 0
Specific = 655367

Ethernet-like Statistics Group

Index = 2
Alignment Errors = 0
FCS Errors = 0
Single Collision Frames = 0
Multiple Collision Frames = 0
Deferred Transmissions = 0
Late Collisions = 0
Excessive Collisions = 0
Internal MAC Transmit Errors = 0
Carrier Sense Errors = 0
Frames Too Long = 0
Internal MAC Receive Errors = 0


on the application server:

# netstat -s
tcp:
1365392057 packets sent
1111871017 data packets (488677620 bytes)
1232481 data packets (1408118999 bytes) retransmitted
255238798 ack-only packets (23621037 delayed)
335 URG only packets
435383 window probe packets
1718278 window update packets
4596372 control packets
1327690014 packets received
798462985 acks (for 486050377 bytes)
6791278 duplicate acks
0 acks for unsent data
974345077 packets (2442737847 bytes) received
in-sequence
832 completely duplicate packets (1124940 bytes)
24817 packets with some dup, data (17453820 bytes
duped)
817201 out of order packets (304738130 bytes)
21615 packets (125604980 bytes) of data after window
913299 window probes
519854114 window update packets
10339 packets received after close
116 segments discarded for bad checksum
0 bad TCP segments dropped due to state change
1706919 connection requests
585591 connection accepts
2292510 connections established (including accepts)
2327178 connections closed (including 34815 drops)
2829 embryonic connections dropped
794999874 segments updated rtt (of 794999874 attempts)
174397 retransmit timeouts
481 connections dropped by rexmit timeout
435383 persist timeouts
18418 keepalive timeouts
18418 keepalive probes sent
284 connections dropped by keepalive
0 connect requests dropped due to full queue
34013 connect requests dropped due to no listener
udp:
0 incomplete headers
0 bad checksums
0 socket overflows
ip:
1464891703 total packets received
0 bad IP headers
3559281 fragments received
0 fragments dropped (dup or out of space)
1010 fragments dropped after timeout
0 packets forwarded
0 packets not forwardable
icmp:
598646 calls to generate an ICMP error message
2 ICMP messages dropped
Output histogram:
echo reply: 323486
destination unreachable: 274893
source quench: 0
routing redirect: 0
echo: 0
time exceeded: 265
parameter problem: 0
time stamp: 0
time stamp reply: 0
address mask request: 0
address mask reply: 0
0 bad ICMP messages
Input histogram:
echo reply: 88565
destination unreachable: 424
source quench: 0
routing redirect: 0
echo: 323486
time exceeded: 8
parameter problem: 0
time stamp request: 0
time stamp reply: 0
address mask request: 0
address mask reply: 0
323486 responses sent
igmp:
0 messages received
0 messages received with too few bytes
0 messages received with bad checksum
0 membership queries received
0 membership queries received with incorrect fields(s)
0 membership reports received
0 membership reports received with incorrect field(s)
0 membership reports received for groups to which this host
belongs
0 membership reports sent

# lanadmin -g 1

LAN INTERFACE STATUS DISPLAY
Tue , May 10,2005 14:10:07

PPA Number = 1
Description = lan1 Hewlett-Packard 10/100 TX
Full-Duplex
TT = 1500
Type (value) = ethernet-csmacd(6)
MTU Size = 1500
Speed = 100000000
Station Address = 0x306e213788
Administration Status (value) = up(1)
Operation Status (value) = up(1)
Last Change = 838039072
Inbound Octets = 914689969
Inbound Unicast Packets = 1402569588
Inbound Non-Unicast Packets = 3211507
Inbound Discards = 55580
Inbound Errors = 0
Inbound Unknown Protocols = 55
Outbound Octets = 2326901696
Outbound Unicast Packets = 1436478104
Outbound Non-Unicast Packets = 55580
Outbound Discards = 0
Outbound Errors = 0
Outbound Queue Length = 0
Specific = 655367

Ethernet-like Statistics Group

Index = 2
Alignment Errors = 0
FCS Errors = 0
Single Collision Frames = 0
Multiple Collision Frames = 0
Deferred Transmissions = 0
Late Collisions = 0
Excessive Collisions = 0
Internal MAC Transmit Errors = 0
Carrier Sense Errors = 0
Frames Too Long = 0
Internal MAC Receive Errors = 0

Reply With Quote
  #2  
Old 05-12-2005, 01:08 PM
Database Bot
 
Join Date: Sep 2009
Posts: 1,236,254
Database Administrator is on a distinguished road
Default Re: Can virtual IPs cause performance problems

I have 3 pairs of servers supported by ServiceGuard. I only use the
virtual IP address in the interface files. I use a standard set of SQL
to take a response time sampling every hour. These are recorded and
reported on a weekly basis (max, min, avg). Over the past year there
has not been any significant changes. My OS is 11.11 with the ASE at
11.9.2.

Reply With Quote
Reply

Thread Tools
Display Modes



All times are GMT -4. The time now is 09:03 PM.