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?
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.
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.