SQLServer-DBA.com Links

Subscribe to newsletter

Dba_db2_button

Powered by TypePad
SQL Server – netstat monitoring and tuning performance

08 March,2012 by Jack Vamvas

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.

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: Jack Vamvas (http://www.sqlserver-dba.com)

******** *******

Subscribe to SQLServer-DBA.com

Latest posts delivered to you daily

Delivered by FeedBurner

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


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