Follow sqlserver-dba.com

Subscribe to RSS feed  Follow @jackvamvas - Twitter

*Use the Comments section for questions

SQLServer-DBA.com Links

Dba_db2_button

dba-ninja.com

SQL Server DBA Jobs

SQL Server – netstat monitoring and tuning performance

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 serverThe 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

See Also

Routing OSPF and Network Team


Author: Tom Collins (http://www.sqlserver-dba.com)


Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

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.

Working...

Post a comment on SQL Server – netstat monitoring and tuning performance


sqlserver-dba.com | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer