08 March,2012 by Tom Collins
To display network connections and various network interface statistics – netstat is a handy command – line based tool.
Why is it useful for the DBA ?
1) Execute netstat –an to view all active connections (TCP and UDP ports) on a server. The DBA has a quick overview of network activity.
Difference between TCP and UDP network protocols
2) Tuning networks requires good quality analysis applied to accurate statictics. High Utilisation and retransmissions are common causes of network related performance issues. nestat is basic in comparison to other sniffer tools – but can assist in the process.
3) netstat will display copious information. Most of it not specific enough for troubleshooting. Fortunately nestat has some parameters to narrow the information.
4) nestat –p TCP displays all the TCP connections
5) netstat –s displays useful statistics such as : failed connection attempts , segments retransmitted . Combined with interval , such as netstat –s 5 will redisplay every 5 seconds
In another post . I’ll outline some methods of troubleshooting network related performance issues
This is only a preview. Your comment has not yet been posted.
As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.
Having trouble reading this image? View an alternate.
Posted by: |