General Networking/Lan/Wan/Slow application


We have a dual core server with 8 gb RAM.  On that server is a multi-user database program with a 4,591,616 kb database.  Each user accesses the server from a PC workstation through a 24-port Cisco switch.  
When a user updates or ads a record, how do I find out how much processing is done in the workstation RAM and how much is done in the server RAM.
The LAN is static IP.  If the issue is a bottleneck connection, how do we find it?

Hi Steve,

Thanks for your question.

I shall apply myself to the query regarding 'bottleneck
connection' as you'd be better advised regarding Server/User
machine RAM processing by a PC expert.

The Cisco switch can tell you a lot about the Workstation and
server network activity.

Here's how...

Checking on a specific port thus;

Example command and output:

CiscoSwitch#sh int fa0/1

FastEthernet0/1 is up, line protocol is up (connected)

 Hardware is Fast Ethernet, address is b8be.bfc4.ff81 (bia b8be.bfc4.ff81)

 Description: TRUNK TO AT&T ROUTER FA0/0

 MTU 1500 bytes, BW 100000 Kbit, DLY 100 usec,

    reliability 255/255, txload 4/255, rxload 1/255

 Encapsulation ARPA, loopback not set

 Keepalive set (10 sec)

 Full-duplex, 100Mb/s, media type is 10/100BaseTX

 input flow-control is off, output flow-control is unsupported

 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

 Input queue: 0/75/0/0 (size/max/drops/flushes); Total output drops: 0

 Queueing strategy: fifo

 Output queue: 0/0 (size/max)

 5 minute input rate 131000 bits/sec, 124 packets/sec

 5 minute output rate 1602000 bits/sec, 213 packets/sec

    1061017156 packets input, 135745243577 bytes, 0 no buffer

    Received 19694 broadcasts (17437 multicasts)

    0 runts, 0 giants, 0 throttles

    0 input errors, 0 CRC, 0 frame, 0 overrun, 0 ignored

    0 watchdog, 17437 multicast, 0 pause input

    0 input packets with dribble condition detected

    1835909260 packets output, 1670293894611 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 PAUSE output

    0 output buffer failures, 0 output buffers swapped out


What you're looking for is the txload and rxload.
This tells you the amount of load the interface is
under - transmit and receive. I would suggest the
workstations interfaces are low but the server could
be quite high. If it is then try the following -


CiscoSwitch#sh int f0/1 | inc drops|bits

Keep repeating this command and watch the output.

This command will show you how much traffic passing
and any packets being dropped as the server can't cope
so the switch dumps. This creates retransmits and there's
your bottleneck. This will cause some nasty delays.

If the load on the Server interface is not particularly high
then the issues will probably lie at the server end.
Possibly the server NIC or the processing loads
on the database. You can query the NIC thru the OS
to see what the NIC load is - but I'm not sure if it's
Unix or Windows etc.
I would ask you to contact an expert
on that subject as I don't think I can be as thorough as
a PC expert would be.

Best Regards

Scott McQueen.  

General Networking/Lan/Wan

All Answers

Answers by Expert:

Ask Experts


Scott McQueen


All Networking and Internetworking questions. Specialist in Cisco Systems equipment.


17 years experience in the Networking industry working for the likes of Siemens and Kingston Communications.

SilverBullet Training Ltd

Computer Shopper

Cisco Certified Trainer

Awards and Honors
IITT TAP certified technology trainer

Past/Present Clients
BMW, British Airways, Omnetica, Kingston Communications, PSINet, British Telecom, Siemens Network Systems Ltd.

©2017 All rights reserved.