Sqlserver-dba.com

Subscribe

SQLServer-DBA.com Links

Subscribe to newsletter

Dba_db2_button

Powered by TypePad
SQL Server – DBCC SQLPERF(netstats) and network activity

28 November,2012 by Jack Vamvas

A useful undocumented SQL Server command is DBCC sqlperf (netstats). It allows the DBA to monitor and report usage of network activity of the SQL Server Instance.

Reporing on network usage is useful in different situations, such as analysing communication between SQL Server and the the network

 The command are :

 

--issue the commnand to view the details
DBCC SQLPERF('netstats')

--clear existing statistics to start a new count
DBCC SQLPERF ('netstats', CLEAR);

 The output is :

Statistic |          Value

Network Reads  2.0427E+07

Network Writes  3.20437E+07

Network Bytes Read      -1.322977E+09

Network Bytes Written   -2.034788E+08

Command Queue Length            0

Max Command Queue Length     0

Worker Threads 0

Max Worker Threads      0

Network Threads            0

Max Network Threads     0

Read More

SQL Server – netstat monitoring and tuning performance - SQL ...

 

SQL Server - How to find Open Transactions

SQL Server – Current queries executing on SQL Server

SQL Server – network packet size - SQL Server DBA

Speed and Duplex settings - SQL Server DBA


Author: Jack Vamvas (http://www.sqlserver-dba.com)

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

Enjoy this post? Enter your email address for updates on new posts:

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