all groups > sql server connect > may 2007 >
You're in the

sql server connect

group:

SQL Server 2000 NETWORKIO issues


SQL Server 2000 NETWORKIO issues Kurt Heunis
5/20/2007 11:24:01 PM
sql server connect:
We have a .NET web service running on one of our servers connecting all our
application users to a SQL Server 2000 database with service pack 4. Every
now and then we experince a NETWORKIO wait type which then causes all our
application users to receive a "Object reference not set to an instance of an
object" error. The only way to resolve this issue is to kill the process ID.
Re: SQL Server 2000 NETWORKIO issues Andrew J. Kelly
5/21/2007 12:00:00 AM
Most Network IO waits are caused by the client (who ever is actually talking
to SQL Server and requesting the rows) not being able to handle the rows
returned fast enough. In this case it sounds like the web service gets hung
in the middle of processing the rows being returned. If you don't have a
pool of web services then all the other requests to the service are
affected.

--
Andrew J. Kelly SQL MVP

[quoted text, click to view]

Re: SQL Server 2000 NETWORKIO issues Kurt Heunis
5/27/2007 11:21:02 PM
Hi Andrew,

Thanks for your response. Do you perhaps have a URL that I can research to
help me change my web service?

Kurt

[quoted text, click to view]
Re: SQL Server 2000 NETWORKIO issues Andrew J. Kelly
5/28/2007 10:54:09 AM
[quoted text, click to view]
the web service in. Basically you need to narrow down where the issue
actually is. You might want to try debugging the web service to see where
the slow down is occurring.

--
Andrew J. Kelly SQL MVP

[quoted text, click to view]

AddThis Social Bookmark Button