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

Network Appliance VS EMC

Hi,
We are deciding whether or not to buy a FA270 NetApp filer. Do you guys have
experience using this filer in the past and how does it rate against DELL
EMC CX600? I would just like to have some non biased opinion about both of
the products.
Thanks,
ShivaHi
For general background information you may want to look at:
http://support.microsoft.com/default.aspx?scid=304261
and
http://www.perftuning.com/pdf/MSSqlSAN.pdf
The SAN should out perform the NAS, therefore if this is the main choice
criteria, then the SAN is the one to opt for.
Whatever option you choose you should carry out stress testing, possibly
using the SQLIOStress utilty
http://support.microsoft.com/default.aspx?scid=kb;en-us;231619
John
"Shiva" wrote:
> Hi,
> We are deciding whether or not to buy a FA270 NetApp filer. Do you guys have
> experience using this filer in the past and how does it rate against DELL
> EMC CX600? I would just like to have some non biased opinion about both of
> the products.
> Thanks,
> Shiva
>
>

Network Appliance VS EMC

Hi,
We are deciding whether or not to buy a FA270 NetApp filer. Do you guys have
experience using this filer in the past and how does it rate against DELL
EMC CX600? I would just like to have some non biased opinion about both of
the products.
Thanks,
ShivaHi
For general background information you may want to look at:
http://support.microsoft.com/default.aspx?scid=304261
and
http://www.perftuning.com/pdf/MSSqlSAN.pdf
The SAN should out perform the NAS, therefore if this is the main choice
criteria, then the SAN is the one to opt for.
Whatever option you choose you should carry out stress testing, possibly
using the SQLIOStress utilty
http://support.microsoft.com/defaul...kb;en-us;231619
John
"Shiva" wrote:

> Hi,
> We are deciding whether or not to buy a FA270 NetApp filer. Do you guys ha
ve
> experience using this filer in the past and how does it rate against DELL
> EMC CX600? I would just like to have some non biased opinion about both of
> the products.
> Thanks,
> Shiva
>
>