SQL Server Locks Up Windows 2000 Server

O/S = Windows 2000 Server, SP4 5.00.2195
SQL = SQL Server Standard 9.0.1399

SQL Server logs the following error in the application event log twice in 5
minutes.

SQL Server has encountered 1 occurrence(s) of I/O requests taking longer
than 15 seconds to complete on file & #91;C:\SQLData\PackL
ines_Data.mdf] in
database [PackLines] (10).  The OS file handle is 0x00000858.  The offse
t of
the latest long I/O is: 0x000000048c0000

After this occurs...
Server TCP provider has stopped listening on port [ 1433 ] due to a fail
ure.
Error: 0x2747, state: 2. The server will automatically attempt to reestablis
h
listening.

at this point multiple USERENV errors a are logged every couple of minutes
and the windows serverand SQL Server no longer respond to any requests, DNS,
DHCP, SQL etc are all unresponsive and the desktop is locked up. The machine
had to be foceably rebooted.

If anyone know why this occurs then let me know. I am not find of getting
phone calls in the middle the night because of this.

Sounds like a disk or I/O subsystem is on it's way out.

http://support.microsoft.com/?kbid=897284
http://support.microsoft.com/defaul...kb;en-us;826433

--
Andrew J. Kelly  SQL MVP


"Lee" <Lee@discussions.microsoft.com> wrote in message
news:6A486730-60D2-4C1A-913F- C4BE7B0B98E9@microso
ft.com...
> O/S = Windows 2000 Server, SP4 5.00.2195
> SQL = SQL Server Standard 9.0.1399
>
> SQL Server logs the following error in the application event log twice in
> 5
> minutes.
>
> SQL Server has encountered 1 occurrence(s) of I/O requests taking longer
> than 15 seconds to complete on file & #91;C:\SQLData\PackL
ines_Data.mdf] in
> database [PackLines] (10).  The OS file handle is 0x00000858.  The off
set
> of
> the latest long I/O is: 0x000000048c0000
>
> After this occurs...
> Server TCP provider has stopped listening on port [ 1433 ] due to a
> failure.
> Error: 0x2747, state: 2. The server will automatically attempt to
> reestablish
> listening.
>
> at this point multiple USERENV errors a are logged every couple of minutes
> and the windows serverand SQL Server no longer respond to any requests,
> DNS,
> DHCP, SQL etc are all unresponsive and the desktop is locked up. The
> machine
> had to be foceably rebooted.
>
> If anyone know why this occurs then let me know. I am not find of getting
> phone calls in the middle the night because of this.
>

Check your system event log for disk subsystem failures.  If there aren't
any, then your IO system is not failing, it is just inadequate.  You may
also have a bad spot on the disk, causing an IO failure.  Run DBCC CHECKDB
across your PackLines database to see if it has some structural problem.  If
there is no hardware failure, you will likely need a better disk system.

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP



"Lee" <Lee@discussions.microsoft.com> wrote in message
news:6A486730-60D2-4C1A-913F- C4BE7B0B98E9@microso
ft.com...
> O/S = Windows 2000 Server, SP4 5.00.2195
> SQL = SQL Server Standard 9.0.1399
>
> SQL Server logs the following error in the application event log twice in
> 5
> minutes.
>
> SQL Server has encountered 1 occurrence(s) of I/O requests taking longer
> than 15 seconds to complete on file & #91;C:\SQLData\PackL
ines_Data.mdf] in
> database [PackLines] (10).  The OS file handle is 0x00000858.  The off
set
> of
> the latest long I/O is: 0x000000048c0000
>
> After this occurs...
> Server TCP provider has stopped listening on port [ 1433 ] due to a
> failure.
> Error: 0x2747, state: 2. The server will automatically attempt to
> reestablish
> listening.
>
> at this point multiple USERENV errors a are logged every couple of minutes
> and the windows serverand SQL Server no longer respond to any requests,
> DNS,
> DHCP, SQL etc are all unresponsive and the desktop is locked up. The
> machine
> had to be foceably rebooted.
>
> If anyone know why this occurs then let me know. I am not find of getting
> phone calls in the middle the night because of this.
>