| Andrew J. Kelly 2006-03-05, 8:24 pm |
| It was said that it may not be processing the results fast enough. If the
machine the client is on is CPU or memory bound or the app fetches one row
at a time and does processing in between it can show up as network waits.
One things you can try is to manually execute the same statement that the
app is trying to issue but from Query Analyzer on the SQL Server itself. If
there is a large difference in the time to complete it is usually either
network or client related.
--
Andrew J. Kelly SQL MVP
"Hassan" <Hassan@hotmail.com> wrote in message
news:OBkBFL1PGHA.4452@TK2MSFTNGP10.phx.gbl...
> Its mentioned that when one sees a high waittime for the networkIO
> waittype, that the application is not processing the results fast enough.
>
> Why would that be ? How can I confirm ? And how can I improve so that the
> app processes fast enough.
>
> Thanks
>
>
>
|