Slooooooooowwwww app, I am about to be hung! (2900XL) 3

[JJDiver]

Hello,

The sales guys are complaining about query speed, on MS Access. Database is running on dedicated server, programer tells me no changes in past week to query's.

I am seeing network utilization on the server at 40-55% when running a query. Query's taking 3-4 minutes instead of 60-90 seconds.

Sales guys complained a few days ago about a different slowdown, but still query related.

I did add a switch last night, spreading users across additonal switches, and gave the servers, printers and links to other switches a switch of there own.

Because of previous slowness I checked all switch ports and ensured they were fixed full and 100.

Diskeeper runs each night, but I did find significant fragmentation two hours ago, and ran a defrag again. Just anaylsed the disk partition, and do not see significant fragmentation at this time.

I would really appreciate any suggestions or ideas on the situation. It feels like the network is seeing a huge increase in traffic, all aimed at the database server.

Thanks, thanks, thanks, thanks, thanks, so much in advance for any hints, ideas, suggestions or solutions.

Jeff

Below is what I see on the server core switch. 0/4 is a link from another switch, and 0/22 is the database server.



Honeycrisp
--------------------------------------------------------------------------------

VLAN1 is up, line protocol is up
Hardware is CPU Interface, address is 00b0.6476.6340 (bia 00b0.6476.6340)
Internet address is 172.26.110.13/16
MTU 1500 bytes, BW 10000 Kbit, DLY 1000 usec,
reliability 255/255, txload 1/255, rxload 1/255
Encapsulation ARPA, loopback not set
ARP type: ARPA, ARP Timeout 04:00:00
Last input 00:00:00, output 00:00:00, output hang never
Last clearing of "show interface" counters never
Queueing strategy: fifo
Output queue 0/40, 0 drops; input queue 0/75, 0 drops
5 minute input rate 2000 bits/sec, 3 packets/sec
5 minute output rate 0 bits/sec, 0 packets/sec
196516 packets input, 18329231 bytes, 0 no buffer
Received 158058 broadcasts, 0 runts, 0 giants, 0 throttles
0 input errors, 0 CRC, 0 frame, 0 overrun, 0 ignored
0 input packets with dribble condition detected
67969 packets output, 34391353 bytes, 0 underruns
0 output errors, 0 collisions, 0 interface resets
0 babbles, 0 late collision, 0 deferred
0 lost carrier, 0 no carrier
0 output buffer failures, 0 output buffers swapped out
FastEthernet0/1 is up, line protocol is up
Hardware is Fast Ethernet, address is 00b0.6476.6341 (bia 00b0.6476.6341)
Description: Link to Golden
MTU 1500 bytes, BW 100000 Kbit, DLY 100 usec,
reliability 255/255, txload 11/255, rxload 1/255
Encapsulation ARPA, loopback not set
Keepalive not set
Full-duplex, 100Mb/s, 100BaseTX/FX
ARP type: ARPA, ARP Timeout 04:00:00
Last input 00:00:43, output 00:00:01, output hang never
Last clearing of "show interface" counters never
Queueing strategy: fifo
Output queue 0/40, 0 drops; input queue 0/75, 0 drops
5 minute input rate 141000 bits/sec, 210 packets/sec
5 minute output rate 4376000 bits/sec, 359 packets/sec
3784021 packets input, 1475663457 bytes
Received 5131 broadcasts, 0 runts, 0 giants, 0 throttles
70 input errors, 70 CRC, 0 frame, 85 overrun, 85 ignored
0 watchdog, 1487 multicast
0 input packets with dribble condition detected
5031811 packets output, 1087529469 bytes, 0 underruns
12 output errors, 3 collisions, 3 interface resets
0 babbles, 12 late collision, 2 deferred
0 lost carrier, 0 no carrier
0 output buffer failures, 0 output buffers swapped out
FastEthernet0/2 is up, line protocol is up
Hardware is Fast Ethernet, address is 00b0.6476.6342 (bia 00b0.6476.6342)
Description: Link to NovaSpy
MTU 1500 bytes, BW 100000 Kbit, DLY 100 usec,
reliability 255/255, txload 34/255, rxload 1/255
Encapsulation ARPA, loopback not set
Keepalive not set
Full-duplex, 100Mb/s, 100BaseTX/FX
ARP type: ARPA, ARP Timeout 04:00:00
Last input 00:00:44, output 00:00:01, output hang never
Last clearing of "show interface" counters never
Queueing strategy: fifo
Output queue 0/40, 0 drops; input queue 0/75, 0 drops
5 minute input rate 718000 bits/sec, 796 packets/sec
5 minute output rate 13357000 bits/sec, 1192 packets/sec
11576004 packets input, 2054299749 bytes
Received 7191 broadcasts, 0 runts, 0 giants, 0 throttles
10 input errors, 5 CRC, 5 frame, 0 overrun, 0 ignored
0 watchdog, 1834 multicast
0 input packets with dribble condition detected
16691969 packets output, 3273670525 bytes, 0 underruns
0 output errors, 0 collisions, 3 interface resets
0 babbles, 0 late collision, 0 deferred
0 lost carrier, 0 no carrier
0 output buffer failures, 0 output buffers swapped out
FastEthernet0/3 is up, line protocol is up
Hardware is Fast Ethernet, address is 00b0.6476.6343 (bia 00b0.6476.6343)
Description: Link to Liberty
MTU 1500 bytes, BW 100000 Kbit, DLY 100 usec,
reliability 255/255, txload 5/255, rxload 1/255
Encapsulation ARPA, loopback not set
Keepalive not set
Full-duplex, 100Mb/s, 100BaseTX/FX
ARP type: ARPA, ARP Timeout 04:00:00
Last input 00:00:42, output 00:00:01, output hang never
Last clearing of "show interface" counters never
Queueing strategy: fifo
Output queue 0/40, 0 drops; input queue 0/75, 0 drops
5 minute input rate 116000 bits/sec, 115 packets/sec
5 minute output rate 2049000 bits/sec, 193 packets/sec
4276882 packets input, 773401816 bytes
Received 4144 broadcasts, 0 runts, 0 giants, 0 throttles
0 input errors, 0 CRC, 0 frame, 0 overrun, 0 ignored
0 watchdog, 1333 multicast
0 input packets with dribble condition detected
5340678 packets output, 3808266052 bytes, 0 underruns
0 output errors, 0 collisions, 3 interface resets
0 babbles, 0 late collision, 0 deferred
0 lost carrier, 0 no carrier
0 output buffer failures, 0 output buffers swapped out
FastEthernet0/4 is up, line protocol is up
Hardware is Fast Ethernet, address is 00b0.6476.6344 (bia 00b0.6476.6344)
Description: Link to BWHSE Switch
MTU 1500 bytes, BW 100000 Kbit, DLY 100 usec,
reliability 255/255, txload 23/255, rxload 1/255
Encapsulation ARPA, loopback not set
Keepalive not set
Full-duplex, 100Mb/s, 100BaseTX/FX
ARP type: ARPA, ARP Timeout 04:00:00
Last input 00:00:01, output 00:00:54, output hang never
Last clearing of "show interface" counters never
Queueing strategy: fifo
Output queue 0/40, 0 drops; input queue 0/75, 0 drops
5 minute input rate 497000 bits/sec, 493 packets/sec
5 minute output rate 9199000 bits/sec, 848 packets/sec
76784440 packets input, 2194326397 bytes
Received 170018 broadcasts, 0 runts, 0 giants, 0 throttles
0 input errors, 0 CRC, 0 frame, 0 overrun, 0 ignored
0 watchdog, 40675 multicast
0 input packets with dribble condition detected
164635489 packets output, 2526291127 bytes, 0 underruns
11 output errors, 7 collisions, 3 interface resets
0 babbles, 11 late collision, 25 deferred
0 lost carrier, 0 no carrier
0 output buffer failures, 0 output buffers swapped out
FastEthernet0/5 is down, line protocol is down
Hardware is Fast Ethernet, address is 00b0.6476.6345 (bia 00b0.6476.6345)
MTU 1500 bytes, BW 100000 Kbit, DLY 100 usec,
reliability 255/255, txload 1/255, rxload 1/255
Encapsulation ARPA, loopback not set
Keepalive not set
Auto-duplex , Auto Speed , 100BaseTX/FX
ARP type: ARPA, ARP Timeout 04:00:00
Last input never, output 17:16:06, output hang never
Last clearing of "show interface" counters never
Queueing strategy: fifo
Output queue 0/40, 0 drops; input queue 0/75, 0 drops
5 minute input rate 0 bits/sec, 0 packets/sec
5 minute output rate 0 bits/sec, 0 packets/sec
1 packets input, 64 bytes
Received 0 broadcasts, 0 runts, 0 giants, 0 throttles
0 input errors, 0 CRC, 0 frame, 0 overrun, 0 ignored
0 watchdog, 0 multicast
0 input packets with dribble condition detected
3 packets output, 876 bytes, 0 underruns
0 output errors, 0 collisions, 1 interface resets
0 babbles, 0 late collision, 0 deferred
0 lost carrier, 0 no carrier
0 output buffer failures, 0 output buffers swapped out
FastEthernet0/6 is down, line protocol is down
Hardware is Fast Ethernet, address is 00b0.6476.6346 (bia 00b0.6476.6346)
MTU 1500 bytes, BW 100000 Kbit, DLY 100 usec,
reliability 255/255, txload 1/255, rxload 1/255
Encapsulation ARPA, loopback not set
Keepalive not set
Auto-duplex , Auto Speed , 100BaseTX/FX
ARP type: ARPA, ARP Timeout 04:00:00
Last input never, output 17:16:06, output hang never
Last clearing of "show interface" counters never
Queueing strategy: fifo
Output queue 0/40, 0 drops; input queue 0/75, 0 drops
5 minute input rate 0 bits/sec, 0 packets/sec
5 minute output rate 0 bits/sec, 0 packets/sec
1 packets input, 64 bytes
Received 0 broadcasts, 0 runts, 0 giants, 0 throttles
0 input errors, 0 CRC, 0 frame, 0 overrun, 0 ignored
0 watchdog, 0 multicast
0 input packets with dribble condition detected
3 packets output, 876 bytes, 0 underruns
0 output errors, 0 collisions, 1 interface resets
0 babbles, 0 late collision, 0 deferred
0 lost carrier, 0 no carrier
0 output buffer failures, 0 output buffers swapped out
FastEthernet0/7 is down, line protocol is down
Hardware is Fast Ethernet, address is 00b0.6476.6347 (bia 00b0.6476.6347)
MTU 1500 bytes, BW 100000 Kbit, DLY 100 usec,
reliability 255/255, txload 1/255, rxload 1/255
Encapsulation ARPA, loopback not set
Keepalive not set
Auto-duplex , Auto Speed , 100BaseTX/FX
ARP type: ARPA, ARP Timeout 04:00:00
Last input never, output 00:35:23, output hang never
Last clearing of "show interface" counters never
Queueing strategy: fifo
Output queue 0/40, 0 drops; input queue 0/75, 0 drops
5 minute input rate 0 bits/sec, 0 packets/sec
5 minute output rate 0 bits/sec, 0 packets/sec
1308322 packets input, 120182017 bytes
Received 37 broadcasts, 0 runts, 0 giants, 0 throttles
0 input errors, 0 CRC, 0 frame, 0 overrun, 0 ignored
0 watchdog, 2 multicast
0 input packets with dribble condition detected
1987751 packets output, 2851083096 bytes, 0 underruns
0 output errors, 0 collisions, 1 interface resets
0 babbles, 0 late collision, 0 deferred
0 lost carrier, 0 no carrier
0 output buffer failures, 0 output buffers swapped out
FastEthernet0/8 is up, line protocol is up
Hardware is Fast Ethernet, address is 00b0.6476.6348 (bia 00b0.6476.6348)
MTU 1500 bytes, BW 10000 Kbit, DLY 1000 usec,
reliability 255/255, txload 1/255, rxload 1/255
Encapsulation ARPA, loopback not set
Keepalive not set
Auto-duplex (Half), Auto Speed (10), 100BaseTX/FX
ARP type: ARPA, ARP Timeout 04:00:00
Last input never, output 00:00:00, output hang never
Last clearing of "show interface" counters never
Queueing strategy: fifo
Output queue 0/40, 0 drops; input queue 0/75, 0 drops
5 minute input rate 0 bits/sec, 0 packets/sec
5 minute output rate 2000 bits/sec, 3 packets/sec
1232 packets input, 138360 bytes
Received 0 broadcasts, 0 runts, 0 giants, 0 throttles
0 input errors, 0 CRC, 0 frame, 0 overrun, 0 ignored
0 watchdog, 0 multicast
0 input packets with dribble condition detected
158160 packets output, 16899049 bytes, 0 underruns
0 output errors, 2 collisions, 1 interface resets
0 babbles, 0 late collision, 0 deferred
0 lost carrier, 0 no carrier
0 output buffer failures, 0 output buffers swapped out
FastEthernet0/9 is up, line protocol is up
Hardware is Fast Ethernet, address is 00b0.6476.6349 (bia 00b0.6476.6349)
MTU 1500 bytes, BW 100000 Kbit, DLY 100 usec,
reliability 255/255, txload 1/255, rxload 1/255
Encapsulation ARPA, loopback not set
Keepalive not set
Auto-duplex (Full), Auto Speed (100), 100BaseTX/FX
ARP type: ARPA, ARP Timeout 04:00:00
Last input never, output 00:00:00, output hang never
Last clearing of "show interface" counters never
Queueing strategy: fifo
Output queue 0/40, 0 drops; input queue 0/75, 0 drops
5 minute input rate 0 bits/sec, 0 packets/sec
5 minute output rate 2000 bits/sec, 3 packets/sec
6987 packets input, 597641 bytes
Received 1 broadcasts, 0 runts, 0 giants, 0 throttles
0 input errors, 0 CRC, 0 frame, 0 overrun, 0 ignored
0 watchdog, 0 multicast
0 input packets with dribble condition detected
170334 packets output, 30493182 bytes, 0 underruns
0 output errors, 0 collisions, 1 interface resets
0 babbles, 0 late collision, 0 deferred
0 lost carrier, 0 no carrier
0 output buffer failures, 0 output buffers swapped out
FastEthernet0/10 is up, line protocol is up
Hardware is Fast Ethernet, address is 00b0.6476.634a (bia 00b0.6476.634a)
MTU 1500 bytes, BW 100000 Kbit, DLY 100 usec,
reliability 255/255, txload 1/255, rxload 1/255
Encapsulation ARPA, loopback not set
Keepalive not set
Auto-duplex (Half), Auto Speed (100), 100BaseTX/FX
ARP type: ARPA, ARP Timeout 04:00:00
Last input never, output 00:00:00, output hang never
Last clearing of "show interface" counters never
Queueing strategy: fifo
Output queue 0/40, 0 drops; input queue 0/75, 0 drops
5 minute input rate 0 bits/sec, 0 packets/sec
5 minute output rate 2000 bits/sec, 3 packets/sec
260 packets input, 62828 bytes
Received 0 broadcasts, 0 runts, 0 giants, 0 throttles
0 input errors, 0 CRC, 0 frame, 0 overrun, 0 ignored
0 watchdog, 0 multicast
0 input packets with dribble condition detected
158857 packets output, 15758426 bytes, 0 underruns
0 output errors, 0 collisions, 1 interface resets
0 babbles, 0 late collision, 8 deferred
0 lost carrier, 0 no carrier
0 output buffer failures, 0 output buffers swapped out
FastEthernet0/11 is up, line protocol is up
Hardware is Fast Ethernet, address is 00b0.6476.634b (bia 00b0.6476.634b)
MTU 1500 bytes, BW 100000 Kbit, DLY 100 usec,
reliability 255/255, txload 1/255, rxload 1/255
Encapsulation ARPA, loopback not set
Keepalive not set
Auto-duplex (Full), Auto Speed (100), 100BaseTX/FX
ARP type: ARPA, ARP Timeout 04:00:00
Last input never, output 00:00:00, output hang never
Last clearing of "show interface" counters never
Queueing strategy: fifo
Output queue 0/40, 0 drops; input queue 0/75, 0 drops
5 minute input rate 0 bits/sec, 0 packets/sec
5 minute output rate 1000 bits/sec, 2 packets/sec
2350 packets input, 221732 bytes
Received 46 broadcasts, 0 runts, 0 giants, 0 throttles
0 input errors, 0 CRC, 0 frame, 0 overrun, 0 ignored
0 watchdog, 39 multicast
0 input packets with dribble condition detected
177411 packets output, 44159409 bytes, 0 underruns
0 output errors, 0 collisions, 1 interface resets
0 babbles, 0 late collision, 0 deferred
0 lost carrier, 0 no carrier
0 output buffer failures, 0 output buffers swapped out
FastEthernet0/12 is up, line protocol is up
Hardware is Fast Ethernet, address is 00b0.6476.634c (bia 00b0.6476.634c)
MTU 1500 bytes, BW 100000 Kbit, DLY 100 usec,
reliability 255/255, txload 1/255, rxload 1/255
Encapsulation ARPA, loopback not set
Keepalive not set
Auto-duplex (Full), Auto Speed (100), 100BaseTX/FX
ARP type: ARPA, ARP Timeout 04:00:00
Last input never, output 00:00:00, output hang never
Last clearing of "show interface" counters never
Queueing strategy: fifo
Output queue 0/40, 0 drops; input queue 0/75, 0 drops
5 minute input rate 0 bits/sec, 0 packets/sec
5 minute output rate 1000 bits/sec, 2 packets/sec
1374 packets input, 182250 bytes
Received 155 broadcasts, 0 runts, 0 giants, 0 throttles
0 input errors, 0 CRC, 0 frame, 0 overrun, 0 ignored
0 watchdog, 86 multicast
0 input packets with dribble condition detected
205967 packets output, 26773107 bytes, 0 underruns
0 output errors, 0 collisions, 1 interface resets
0 babbles, 0 late collision, 0 deferred
0 lost carrier, 0 no carrier
0 output buffer failures, 0 output buffers swapped out
FastEthernet0/13 is up, line protocol is up
Hardware is Fast Ethernet, address is 00b0.6476.634d (bia 00b0.6476.634d)
MTU 1500 bytes, BW 100000 Kbit, DLY 100 usec,
reliability 255/255, txload 1/255, rxload 1/255
Encapsulation ARPA, loopback not set
Keepalive not set
Auto-duplex (Full), Auto Speed (100), 100BaseTX/FX
ARP type: ARPA, ARP Timeout 04:00:00
Last input never, output 00:00:00, output hang never
Last clearing of "show interface" counters never
Queueing strategy: fifo
Output queue 0/40, 0 drops; input queue 0/75, 0 drops
5 minute input rate 0 bits/sec, 0 packets/sec
5 minute output rate 1000 bits/sec, 2 packets/sec
2859 packets input, 247049 bytes
Received 25 broadcasts, 0 runts, 0 giants, 0 throttles
0 input errors, 0 CRC, 0 frame, 0 overrun, 0 ignored
0 watchdog, 22 multicast
0 input packets with dribble condition detected
176925 packets output, 43843856 bytes, 0 underruns
0 output errors, 0 collisions, 1 interface resets
0 babbles, 0 late collision, 0 deferred
0 lost carrier, 0 no carrier
0 output buffer failures, 0 output buffers swapped out
FastEthernet0/14 is up, line protocol is up
Hardware is Fast Ethernet, address is 00b0.6476.634e (bia 00b0.6476.634e)
MTU 1500 bytes, BW 100000 Kbit, DLY 100 usec,
reliability 255/255, txload 1/255, rxload 1/255
Encapsulation ARPA, loopback not set
Keepalive not set
Auto-duplex (Full), Auto Speed (100), 100BaseTX/FX
ARP type: ARPA, ARP Timeout 04:00:00
Last input never, output 00:00:00, output hang never
Last clearing of "show interface" counters never
Queueing strategy: fifo
Output queue 0/40, 0 drops; input queue 0/75, 0 drops
5 minute input rate 0 bits/sec, 0 packets/sec
5 minute output rate 1000 bits/sec, 2 packets/sec
558 packets input, 102574 bytes
Received 35 broadcasts, 0 runts, 0 giants, 0 throttles
0 input errors, 0 CRC, 0 frame, 0 overrun, 0 ignored
0 watchdog, 28 multicast
0 input packets with dribble condition detected
158158 packets output, 16234378 bytes, 0 underruns
0 output errors, 0 collisions, 1 interface resets
0 babbles, 0 late collision, 0 deferred
0 lost carrier, 0 no carrier
0 output buffer failures, 0 output buffers swapped out
FastEthernet0/15 is up, line protocol is up
Hardware is Fast Ethernet, address is 00b0.6476.634f (bia 00b0.6476.634f)
MTU 1500 bytes, BW 10000 Kbit, DLY 1000 usec,
reliability 255/255, txload 1/255, rxload 1/255
Encapsulation ARPA, loopback not set
Keepalive not set
Auto-duplex (Half), Auto Speed (10), 100BaseTX/FX
ARP type: ARPA, ARP Timeout 04:00:00
Last input never, output 00:00:00, output hang never
Last clearing of "show interface" counters never
Queueing strategy: fifo
Output queue 0/40, 0 drops; input queue 0/75, 0 drops
5 minute input rate 0 bits/sec, 0 packets/sec
5 minute output rate 1000 bits/sec, 2 packets/sec
10520 packets input, 816821 bytes
Received 0 broadcasts, 0 runts, 0 giants, 0 throttles
0 input errors, 0 CRC, 0 frame, 0 overrun, 0 ignored
0 watchdog, 0 multicast
0 input packets with dribble condition detected
176480 packets output, 42342457 bytes, 0 underruns
0 output errors, 15 collisions, 1 interface resets
0 babbles, 0 late collision, 8 deferred
0 lost carrier, 0 no carrier
0 output buffer failures, 0 output buffers swapped out
FastEthernet0/16 is up, line protocol is up
Hardware is Fast Ethernet, address is 00b0.6476.6350 (bia 00b0.6476.6350)
MTU 1500 bytes, BW 10000 Kbit, DLY 1000 usec,
reliability 255/255, txload 1/255, rxload 1/255
Encapsulation ARPA, loopback not set
Keepalive not set
Auto-duplex (Half), Auto Speed (10), 100BaseTX/FX
ARP type: ARPA, ARP Timeout 04:00:00
Last input never, output 00:00:00, output hang never
Last clearing of "show interface" counters never
Queueing strategy: fifo
Output queue 0/40, 0 drops; input queue 0/75, 0 drops
5 minute input rate 0 bits/sec, 0 packets/sec
5 minute output rate 1000 bits/sec, 2 packets/sec
177 packets input, 11328 bytes
Received 176 broadcasts, 0 runts, 0 giants, 0 throttles
0 input errors, 0 CRC, 0 frame, 0 overrun, 0 ignored
0 watchdog, 0 multicast
0 input packets with dribble condition detected
158257 packets output, 15699596 bytes, 0 underruns
0 output errors, 0 collisions, 1 interface resets
0 babbles, 0 late collision, 0 deferred
0 lost carrier, 0 no carrier
0 output buffer failures, 0 output buffers swapped out
FastEthernet0/17 is up, line protocol is up
Hardware is Fast Ethernet, address is 00b0.6476.6351 (bia 00b0.6476.6351)
MTU 1500 bytes, BW 100000 Kbit, DLY 100 usec,
reliability 255/255, txload 1/255, rxload 1/255
Encapsulation ARPA, loopback not set
Keepalive not set
Full-duplex, 100Mb/s, 100BaseTX/FX
ARP type: ARPA, ARP Timeout 04:00:00
Last input never, output 00:00:00, output hang never
Last clearing of "show interface" counters never
Queueing strategy: fifo
Output queue 0/40, 0 drops; input queue 0/75, 0 drops
5 minute input rate 0 bits/sec, 0 packets/sec
5 minute output rate 3000 bits/sec, 3 packets/sec
27156 packets input, 10189686 bytes
Received 598 broadcasts, 0 runts, 0 giants, 0 throttles
0 input errors, 0 CRC, 0 frame, 0 overrun, 0 ignored
0 watchdog, 0 multicast
0 input packets with dribble condition detected
233598 packets output, 29789900 bytes, 0 underruns
0 output errors, 0 collisions, 3 interface resets
0 babbles, 0 late collision, 0 deferred
0 lost carrier, 0 no carrier
0 output buffer failures, 0 output buffers swapped out
FastEthernet0/18 is up, line protocol is up
Hardware is Fast Ethernet, address is 00b0.6476.6352 (bia 00b0.6476.6352)
Description: R2D2
MTU 1500 bytes, BW 100000 Kbit, DLY 100 usec,
reliability 255/255, txload 1/255, rxload 1/255
Encapsulation ARPA, loopback not set
Keepalive not set
Full-duplex, 100Mb/s, 100BaseTX/FX
ARP type: ARPA, ARP Timeout 04:00:00
Last input never, output 00:00:00, output hang never
Last clearing of "show interface" counters never
Queueing strategy: fifo
Output queue 0/40, 0 drops; input queue 0/75, 0 drops
5 minute input rate 0 bits/sec, 0 packets/sec
5 minute output rate 5000 bits/sec, 4 packets/sec
3953046 packets input, 377864712 bytes
Received 800 broadcasts, 0 runts, 0 giants, 0 throttles
0 input errors, 0 CRC, 0 frame, 0 overrun, 0 ignored
0 watchdog, 0 multicast
0 input packets with dribble condition detected
6109484 packets output, 4048791259 bytes, 0 underruns
0 output errors, 0 collisions, 3 interface resets
0 babbles, 0 late collision, 0 deferred
0 lost carrier, 0 no carrier
0 output buffer failures, 0 output buffers swapped out
FastEthernet0/19 is up, line protocol is up
Hardware is Fast Ethernet, address is 00b0.6476.6353 (bia 00b0.6476.6353)
MTU 1500 bytes, BW 100000 Kbit, DLY 100 usec,
reliability 255/255, txload 1/255, rxload 1/255
Encapsulation ARPA, loopback not set
Keepalive not set
Full-duplex, 100Mb/s, 100BaseTX/FX
ARP type: ARPA, ARP Timeout 04:00:00
Last input never, output 00:00:01, output hang never
Last clearing of "show interface" counters never
Queueing strategy: fifo
Output queue 0/40, 0 drops; input queue 0/75, 0 drops
5 minute input rate 1000 bits/sec, 1 packets/sec
5 minute output rate 5000 bits/sec, 4 packets/sec
207310 packets input, 62942035 bytes
Received 5330 broadcasts, 0 runts, 0 giants, 0 throttles
0 input errors, 0 CRC, 0 frame, 0 overrun, 0 ignored
0 watchdog, 26 multicast
0 input packets with dribble condition detected
413859 packets output, 75744503 bytes, 0 underruns
0 output errors, 0 collisions, 3 interface resets
0 babbles, 0 late collision, 0 deferred
0 lost carrier, 0 no carrier
0 output buffer failures, 0 output buffers swapped out
FastEthernet0/20 is down, line protocol is down
Hardware is Fast Ethernet, address is 00b0.6476.6354 (bia 00b0.6476.6354)
Description: APC
MTU 1500 bytes, BW 100000 Kbit, DLY 100 usec,
reliability 255/255, txload 1/255, rxload 1/255
Encapsulation ARPA, loopback not set
Keepalive not set
Auto-duplex , Auto Speed , 100BaseTX/FX
ARP type: ARPA, ARP Timeout 04:00:00
Last input never, output 12:52:22, output hang never
Last clearing of "show interface" counters never
Queueing strategy: fifo
Output queue 0/40, 0 drops; input queue 0/75, 0 drops
5 minute input rate 0 bits/sec, 0 packets/sec
5 minute output rate 0 bits/sec, 0 packets/sec
7 packets input, 478 bytes
Received 2 broadcasts, 0 runts, 0 giants, 0 throttles
0 input errors, 0 CRC, 0 frame, 0 overrun, 0 ignored
0 watchdog, 0 multicast
0 input packets with dribble condition detected
2840 packets output, 308927 bytes, 0 underruns
0 output errors, 0 collisions, 1 interface resets
0 babbles, 0 late collision, 0 deferred
0 lost carrier, 0 no carrier
0 output buffer failures, 0 output buffers swapped out
FastEthernet0/21 is up, line protocol is up
Hardware is Fast Ethernet, address is 00b0.6476.6355 (bia 00b0.6476.6355)
Description: Jaba
MTU 1500 bytes, BW 100000 Kbit, DLY 100 usec,
reliability 255/255, txload 1/255, rxload 1/255
Encapsulation ARPA, loopback not set
Keepalive not set
Auto-duplex (Full), Auto Speed (100), 100BaseTX/FX
ARP type: ARPA, ARP Timeout 04:00:00
Last input never, output 00:00:01, output hang never
Last clearing of "show interface" counters never
Queueing strategy: fifo
Output queue 0/40, 0 drops; input queue 0/75, 0 drops
5 minute input rate 244000 bits/sec, 4 packets/sec
5 minute output rate 22000 bits/sec, 8 packets/sec
6156343 packets input, 812451211 bytes
Received 1317 broadcasts, 0 runts, 0 giants, 0 throttles
15 input errors, 0 CRC, 15 frame, 0 overrun, 0 ignored
0 watchdog, 0 multicast
0 input packets with dribble condition detected
5021374 packets output, 571728774 bytes, 0 underruns
0 output errors, 0 collisions, 1 interface resets
0 babbles, 0 late collision, 0 deferred
0 lost carrier, 0 no carrier
0 output buffer failures, 0 output buffers swapped out
FastEthernet0/22 is up, line protocol is up
Hardware is Fast Ethernet, address is 00b0.6476.6356 (bia 00b0.6476.6356)
Description: Ewok
MTU 1500 bytes, BW 100000 Kbit, DLY 100 usec,
reliability 255/255, txload 2/255, rxload 67/255
Encapsulation ARPA, loopback not set
Keepalive not set
Full-duplex, 100Mb/s, 100BaseTX/FX
ARP type: ARPA, ARP Timeout 04:00:00
Last input never, output 00:00:01, output hang never
Last clearing of "show interface" counters never
Queueing strategy: fifo
Output queue 0/40, 0 drops; input queue 0/75, 0 drops
5 minute input rate 26459000 bits/sec, 2316 packets/sec
5 minute output rate 1041000 bits/sec, 1445 packets/sec
39529914 packets input, 4088207843 bytes
Received 2641 broadcasts, 0 runts, 0 giants, 0 throttles
0 input errors, 0 CRC, 0 frame, 0 overrun, 0 ignored
0 watchdog, 0 multicast
0 input packets with dribble condition detected
24415459 packets output, 2595781579 bytes, 0 underruns
0 output errors, 0 collisions, 3 interface resets
0 babbles, 0 late collision, 0 deferred
0 lost carrier, 0 no carrier
0 output buffer failures, 0 output buffers swapped out
FastEthernet0/23 is up, line protocol is up
Hardware is Fast Ethernet, address is 00b0.6476.6357 (bia 00b0.6476.6357)
Description: Jedi
MTU 1500 bytes, BW 100000 Kbit, DLY 100 usec,
reliability 255/255, txload 1/255, rxload 6/255
Encapsulation ARPA, loopback not set
Keepalive not set
Full-duplex, 100Mb/s, 100BaseTX/FX
ARP type: ARPA, ARP Timeout 04:00:00
Last input never, output 00:00:01, output hang never
Last clearing of "show interface" counters never
Queueing strategy: fifo
Output queue 0/40, 0 drops; input queue 0/75, 0 drops
5 minute input rate 2387000 bits/sec, 291 packets/sec
5 minute output rate 396000 bits/sec, 215 packets/sec
151529057 packets input, 3141809164 bytes
Received 5657 broadcasts, 0 runts, 0 giants, 0 throttles
0 input errors, 0 CRC, 0 frame, 0 overrun, 0 ignored
0 watchdog, 0 multicast
0 input packets with dribble condition detected
70903747 packets output, 3024803821 bytes, 0 underruns
0 output errors, 0 collisions, 3 interface resets
0 babbles, 0 late collision, 0 deferred
0 lost carrier, 0 no carrier
0 output buffer failures, 0 output buffers swapped out
FastEthernet0/24 is up, line protocol is up
Hardware is Fast Ethernet, address is 00b0.6476.6358 (bia 00b0.6476.6358)
Description: Han
MTU 1500 bytes, BW 100000 Kbit, DLY 100 usec,
reliability 255/255, txload 1/255, rxload 1/255
Encapsulation ARPA, loopback not set
Keepalive not set
Full-duplex, 100Mb/s, 100BaseTX/FX
ARP type: ARPA, ARP Timeout 04:00:00
Last input never, output 00:00:01, output hang never
Last clearing of "show interface" counters never
Queueing strategy: fifo
Output queue 0/40, 0 drops; input queue 0/75, 0 drops
5 minute input rate 0 bits/sec, 0 packets/sec
5 minute output rate 1000 bits/sec, 2 packets/sec
144474 packets input, 160552111 bytes
Received 303 broadcasts, 0 runts, 0 giants, 0 throttles
0 input errors, 0 CRC, 0 frame, 0 overrun, 0 ignored
0 watchdog, 4 multicast
0 input packets with dribble condition detected
305226 packets output, 67244699 bytes, 0 underruns
0 output errors, 0 collisions, 3 interface resets
0 babbles, 0 late collision, 0 deferred
0 lost carrier, 0 no carrier
0 output buffer failures, 0 output buffers swapped out
FastEthernet1/1 is down, line protocol is down
Hardware is Fast Ethernet, address is 00b0.6476.635e (bia 00b0.6476.635e)
MTU 1500 bytes, BW 100000 Kbit, DLY 100 usec,
reliability 255/255, txload 1/255, rxload 1/255
Encapsulation ARPA, loopback not set
Keepalive not set
Full-duplex, 100Mb/s, 100BaseFX
ARP type: ARPA, ARP Timeout 04:00:00
Last input never, output 17:16:07, output hang never
Last clearing of "show interface" counters never
Queueing strategy: fifo
Output queue 0/40, 0 drops; input queue 0/75, 0 drops
5 minute input rate 0 bits/sec, 0 packets/sec
5 minute output rate 0 bits/sec, 0 packets/sec
1 packets input, 64 bytes
Received 0 broadcasts, 0 runts, 0 giants, 0 throttles
0 input errors, 0 CRC, 0 frame, 0 overrun, 0 ignored
0 watchdog, 0 multicast
0 input packets with dribble condition detected
3 packets output, 876 bytes, 0 underruns
0 output errors, 0 collisions, 1 interface resets
0 babbles, 0 late collision, 0 deferred
0 lost carrier, 0 no carrier
0 output buffer failures, 0 output buffers swapped out
FastEthernet1/2 is down, line protocol is down
Hardware is Fast Ethernet, address is 00b0.6476.635f (bia 00b0.6476.635f)
MTU 1500 bytes, BW 100000 Kbit, DLY 100 usec,
reliability 255/255, txload 1/255, rxload 1/255
Encapsulation ARPA, loopback not set
Keepalive not set
Full-duplex, 100Mb/s, 100BaseFX
ARP type: ARPA, ARP Timeout 04:00:00
Last input never, output 17:16:07, output hang never
Last clearing of "show interface" counters never
Queueing strategy: fifo
Output queue 0/40, 0 drops; input queue 0/75, 0 drops
5 minute input rate 0 bits/sec, 0 packets/sec
5 minute output rate 0 bits/sec, 0 packets/sec
1 packets input, 64 bytes
Received 0 broadcasts, 0 runts, 0 giants, 0 throttles
0 input errors, 0 CRC, 0 frame, 0 overrun, 0 ignored
0 watchdog, 0 multicast
0 input packets with dribble condition detected
3 packets output, 876 bytes, 0 underruns
0 output errors, 0 collisions, 1 interface resets
0 babbles, 0 late collision, 0 deferred
0 lost carrier, 0 no carrier
0 output buffer failures, 0 output buffers swapped out
--------------------------------------------------------------------------------


--------------------------------------------------------------------------------

##

 

[vipergg]

I don't see anything running very heavy on the switch which leaves the app . Even if the switch was even somewhat busy it wouldn't cause a 3 minute delay in response , sounds like a app issue to me . None of the interfaces are busy on the 2900 .

 

[ADB100]

You hard-coded all the interfaces to 100/Full - did you hard-code all the servers and workstations as well? If you didn't you will have loads of duplex mis-matches.

Andy

 

[burtsbees]

txload 2/255, rxload 67/255
on fa0/22, your database switchport. This is about .7% transmit load and 26% receive load. That's not much at all.

Burt

 

[JJDiver]

Vipergg, thanks for your eval. Programer promises me he didn't change the query, but... Will have futher chats with the programmer.

ADB100, I hard-coded the switches,and links to other switches, as well as the servers. Didn't hard-code the workstations. I don't see any duplex mis-matches, or other errors. Good point, something that's easy to do.

Thanks,

Jeff

 

[ADB100]

ADB100, I hard-coded the switches,and links to other switches, as well as the servers. Didn't hard-code the workstations. I don't see any duplex mis-matches, or other errors. Good point, something that's easy to do.

You won't see any errors on the switch if it's hard-coded to Full-Duplex as the collision detection circuitry is disabled in full-dupex mode, however on the workstations you are likely to be getting lots....... I wouldn't recommend hard-coding anything except inter-switch links or links to routers and to be honest even then I would probably just leave them at auto. I have seen that many issues with hard-coding NICs and switchports that simply disappear when you revert them back to auto. I have seen drivers that allow you to hard-code Full-Duplex but in reality it didn't work and the NIC always operated in Auto mode resulting in a duplex mis-match that is almost impossible to detect.
Duplex negotiation used to be a problem when Fast Ethernet first appeared but that was a LONG time ago now. Any NIC manufactured in the last 5 years should be left at auto IMO.

Andy

 

[JJDiver]

Burtsbees,

So everybody is agreeing it's not a load on the network, I don't see any errors indicating errors, other servers/apps are running fine...

Sometimes I see the server in question showing network utilization that's over 85% (spiky), and I wonder why.

I did notice a few people who after rebooting didn't have a link in time for scripts to run. Will have to enable portfast on the PC's. Can't imagine how that would affect speed.

Thanks for looking at my situation.

Jeff

 

[JJDiver]

ADB100,

Learn something new every day. I thought best pratice was to hard code the link between switches and servers. I had problems with auto-negotiation (duplex mismatch) between the 2900XL and a few servers. I hard-coded to elimante the problem, perhaps I created a monster instead.

I have hard coded many server NIC's previously, but hard coding the switch links is very recent. Sounds like you have given me some important items to check.

Thanks, thanks, thanks,

Jeff

 

[JJDiver]

ADB100,

Changed the problem switch and linked switch back to auto-config and the problem seems to have disappeared. Thanks! I will feel much better tomorrow after the sales dept. is quiet for a few hours!

It's hard to belive, I thought it was best to hard code and I seem to recall problems with auto-config in the past. And I still need to change a few other switches back to auto-config.

I really wish there was a how to do it, that had all the answers. Guess I am reaching for the stars, and if it was that easy, everybody would be experts.

Thanks for taking the time to voice your opinion, explain the situation and help me out!

Thanks,

Jeff

 

[jneiberger]

According to your original post, it's clear that you have a duplex mismatch on f0/1 and f0/4. Never hard set your speed and duplex. Make sure both ends of every link is set to AUTO. Manually configuring your speed and duplex has not been best practice for years but many people still do it mistakenly thinking that it is solving a problem or avoiding a problem when, in fact, it is causing problems.

 

[vipergg]

Between cisco devices these days "auto" works fine and for "most" cleints but there will still be the rare occasion where something does not want to cooperate. How to's on best practices is all available at cisco.com and most of it is free . They vast amounts of documention on the site . Great reading for when you can't sleep at night , it will put you to sleep in 15 minutes guaranteed .

 

[ADB100]

jneilberger & vipergg - we keep telling people but they don't want to listen.....

I managed to stop a reasonably big Nortel IP Telephony solution being thrown out a few weeks ago by fixing some duplex issues. The network/server guys were adamant that the ports had to be hard-coded because they have had issues in the past; I changed the ports the Call Servers & Voice Gateways were connected to back to auto and all the telephony issues mysteriously disappeared. - I subsequently got my ass kicked for making some changes but that's another (political) story....

It seems it's usually server people that have the idea that all server NIC's MUST be hard-coded or there will be problems. I don't know why though \

Andy

 

[burtsbees]

Not ALL server guys...I'm a server guy, and I don't hard code NICs...

Burt

 

[ADB100]

'Usually'.... )

Probably much less experienced server guys than you though, obviously.

Andy

 

[burtsbees]

Ha ha

Burt

 

[jneiberger]

The only devices I regularly saw issues with were Solaris servers a few years ago. They really didn't like to negotiate properly for some reason. And I'll still run across a device once in a while that behaves strangely. It just happened yesterday actually. However, I can honestly say that 99% or more of the devices I deal with have no problems negotiating properly.