Getting Started with Adobe After Effects - Part 6: Motion Blur


Upload Image Close it
Select File

Learn about SQL Server DBA, SQL Server database performance,SQL Server optimisation,database tuning,t-sql,ssis
Browse by Tags · View All
DBA Scripts 51
performance 37
SQL Server 29
Object Management 24
#SQLServer 24
Backup and Restore 20
Security Management 20
Powershell 17
Indexes 14
DBA 14

Archive · View All
June 2011 38
January 2011 33
May 2011 32
August 2011 27
July 2011 26
January 2012 24
February 2011 19
April 2011 19
March 2011 17
March 2012 17

Jack Vamvas's Blog

SQL Server – netstat monitoring and tuning performance

Mar 8 2012 12:00AM 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

Republished with author's permission. See the original post here.


Republished from SQL Server DBA [65 clicks].  Read the original version here [32134 clicks].

Jack Vamvas
5 · 26% · 8528
0
Liked
 
0
Lifesaver
 
0
Refreshed
 
0
Learned
 
0
Incorrect



Submit

Your Comment


Sign Up or Login to post a comment.

    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]