|
Home > Archive > MS SQL Server > December 2005 > SQL Server Locks Up Windows 2000 Server
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
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 offset 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.
| |
| Andrew J. Kelly 2005-12-29, 9:23 am |
| 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 offset
> 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.
>
| |
| Geoff N. Hiten 2005-12-29, 9:23 am |
| 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 offset
> 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.
>
|
|
|
|
|