Wednesday, March 28, 2012

NETWORK BOTTLENECK

How do I find out if I have a network bottlneck, what counters and what
rate?
ThanksYou could look at Network Interface: Bytes Total/Sec Against Network
Interface: Current Bandwidth for your active interface. Current bandwidth is
in bits so you will need to either divide that by 8 or multiply Bytes
Total/Sec by 8 for it to be comparable. Anything over about 55% is worth
looking into.. ..look at the Wait Stats in sql such as
NETWORKIO(2000)/NET_WAITFOR_PACKET(2005).. ..it's worth noting in *most*
cases the network is the last place to look for a bottleneck..
"msnews.microsoft.com" wrote:
> How do I find out if I have a network bottlneck, what counters and what
> rate?
> Thanks
>
>|||Hi
"msnews.microsoft.com" wrote:
> How do I find out if I have a network bottlneck, what counters and what
> rate?
> Thanks
>
You may want to look at http://www.sqldev.net/misc/sp_waitstats.htm
Johnsql

No comments:

Post a Comment