Re: high networkio in waitstats

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Hassan (fatima_ja_at_hotmail.com)
Date: 12/25/04 

Date: Sat, 25 Dec 2004 12:05:16 -0800

So what can we do in this case ? Is it something that we can control from
the SQL Server end or the client ? So are you saying that even if we had a
1Gbps NIC card, the problem still remains. Yes this server is a subscriber
and is receiving replicated transactions

"Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message
news:uwHRbap6EHA.2016@TK2MSFTNGP15.phx.gbl...
> I agree with Anthony on this. The client plays a large role is how
> efficiently the packets get processed. Especially with heavy replication.
I
> have seen very high network waits on systems where the subscribers or the
> distributor can not keep up with the requests.
>
> --
> Andrew J. Kelly SQL MVP
>
>
> "AnthonyThomas" <Anthony.Thomas@CommerceBank.com> wrote in message
> news:eSVDgdl6EHA.3708@TK2MSFTNGP14.phx.gbl...
> > Not to say that you are not maxed out on your NIC's throughput, but
> > measure
> > it with perf mon.
> >
> > Typically, the Network IO wait states are due to the client's ability to
> > process the packets, especially when there is a VERY large TDS stream.
> >
> > Take a look at the clients' CPU usage. If it is high, they are not
> > processing the results quick enough.
> >
> > Sincerely,
> >
> >
> > Anthony Thomas
> >
> >
> > --
> >
> > "Hassan" <fatima_ja@hotmail.com> wrote in message
> > news:uvvi1Aj6EHA.3944@TK2MSFTNGP12.phx.gbl...
> > My waitstats reveal a high percentage of networkIO. Currently my adapter
> > is
> > a 100Mbps. Do I need a 1Gbps adapter ? How can I find out why theres a
> > high
> > wait of networkIO and what can I do to resolve it ?
> >
> > Thanks
> >
> >
>
>

Relevant Pages

  • Re: Awful performance and millions of packets transferred
    ... I ran the same test on a separate network and found ... >that normally around 4000 packets were transferred for that perticular ... >The PC, switches, routers and the server were all checked for network ... The client was passing requests to the server and the ...
    (comp.databases.ms-access)
  • Re: troubles with wireless pentest
    ... I would try some good ol` fashion ARP poisioning with CAIN ...spoof ... > the network was encrypted but with wep and large traffic so i was able to ... > Using kismet I sniffed a whole lot of packets. ... > i tried a traceroute to my target client but it failed too with the same ...
    (Pen-Test)
  • RE: troubles with wireless pentest
    ... the network was encrypted but with wep and large traffic so i was able ... Using kismet I sniffed a whole lot of packets. ... i tried a traceroute to my target client but it failed too with the same ... HOW CAN I ROUTE PACKETS THROUGH TO OTHER CLIENTS OR BECOME A CLIENT ...
    (Pen-Test)
  • RE: MS SQL & Msg 11, Level 16, State 1
    ... General Network Errors are one of the most difficult to troubleshoot, ... Connectivity problems can occur if a firewall times out a connection before ... the client and SQL are done with it. ... Is there very heavy load on the SQL server when this happens? ...
    (microsoft.public.sqlserver.connect)
  • Re: Problem with NetScreen Remote 7.0.3 over DSL connection when accessing SQL....
    ... The trick to this one is making the SQL server think the remote client ... At present the SQL server see's the public NATTed address of your DSL. ... >From Dialup VPN ... > the network it will take about 5-10 minutes just for the login screen ...
    (comp.security.firewalls)