Friday, March 30, 2012

Network I/O error in SQL 2000 ?

SQL 2000 with SP4 what causes a network I/O error which kept the data from
reaching the workstations?Hi
It is unlikely that this is a specific SP4 issue. You don't say whether this
is an intermitent or constant problem or exacly which error number and
message you are getting. You also don't say if this is happening on all
workstations and or the server.
So things to try: check the protocols that being used on server and client,
check for firewalls/virus checkers stopping the port/pipe, make sure that yo
u
can ping/telnet the server, check the name is resolved correctly, check
timeouts...
John
"DGreg" wrote:

> SQL 2000 with SP4 what causes a network I/O error which kept the data from
> reaching the workstations?
>|||John
The error is related to the wait time and wait request on sql2000.
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> It is unlikely that this is a specific SP4 issue. You don't say whether th
is
> is an intermitent or constant problem or exacly which error number and
> message you are getting. You also don't say if this is happening on all
> workstations and or the server.
> So things to try: check the protocols that being used on server and client
,
> check for firewalls/virus checkers stopping the port/pipe, make sure that
you
> can ping/telnet the server, check the name is resolved correctly, check
> timeouts...
> John
> "DGreg" wrote:
>|||Hi
Are you refering to DBCC SQLPERF? Changes were made regarding some of the
reporting such as latch waits but I don't know of anything that changed with
network I/O
John
"DGreg" wrote:
[vbcol=seagreen]
> John
> The error is related to the wait time and wait request on sql2000.
> "John Bell" wrote:
>

No comments:

Post a Comment