MS SQL Server - SQL Server hangs when Server reboots

Author

SQL Server hangs when Server reboots

2006-02-04, 7:23 am

Hi All,

I am having this strange behaviour on couple of our database servers. Our
system crashed and it got rebooted, but SQLServer hangs forever and its
status of service is always "Starting". After seeing this we try to reboot
the system, but same thing happens again and again.

Only way I could workaround that is

1. make all the three services SQLServer, SQLAgent and DTC to Manual mode
and again reboot the system.
2. After it is rebooted I manually started the SQLServer serice, then it
started just fine and
3. start SQLAgent and DTC services.

The reason I came up with this workaround is because the last line in the
SQL Server log when the SQLServer service is hanging is

2006-02-03 13:42:23.09 server Attempting to initialize Distributed
Transaction Coordinator.

Additional info: SQLServer and SQLAgent services are started with a specific
Windows account, where as DTC is started with "LocalSystem". DTC service
has started just fine, but SQLServer was hanging.

Did anyone happen to see this kind of behaviour? Any help is greatly
appreciated.

Thanks,
VM

Jack Vamvas

2006-02-04, 11:23 am

What service pack are you running?
Also could you post the few lines preceding the last line yo've posted.

--
Jack Vamvas
____________________
____________________
____________________
______
Receive free SQL tips - register at www.ciquery.com/sqlserver.htm
SQL Server Performance Audit - check www.ciquery.com/sqlserver_audit.htm
New article by Jack Vamvas - SQL and Markov Chains -
www.ciquery.com/articles/art_04.asp
"VM" <VM@discussions.microsoft.com> wrote in message
news:D9C79E35-DB99-46EB-B476- 05666DA5B904@microso
ft.com...
> Hi All,
>
> I am having this strange behaviour on couple of our database servers. Our
> system crashed and it got rebooted, but SQLServer hangs forever and its
> status of service is always "Starting". After seeing this we try to
reboot
> the system, but same thing happens again and again.
>
> Only way I could workaround that is
>
> 1. make all the three services SQLServer, SQLAgent and DTC to Manual mode
> and again reboot the system.
> 2. After it is rebooted I manually started the SQLServer serice, then it
> started just fine and
> 3. start SQLAgent and DTC services.
>
> The reason I came up with this workaround is because the last line in the
> SQL Server log when the SQLServer service is hanging is
>
> 2006-02-03 13:42:23.09 server Attempting to initialize Distributed
> Transaction Coordinator.
>
> Additional info: SQLServer and SQLAgent services are started with a
specific
> Windows account, where as DTC is started with "LocalSystem". DTC
service
> has started just fine, but SQLServer was hanging.
>
> Did anyone happen to see this kind of behaviour? Any help is greatly
> appreciated.
>
> Thanks,
> VM

Sonvn-ICB

2006-02-06, 3:23 am

HI. I have same problem and I had solved it. You check Print Splooer Service
type is start automatic.
"Jack Vamvas" < DELETE_BEFORE_REPLY_
jack@ciquery.com> wrote in message
news:ds2j0o$jpu$1@nw
rdmz03.dmz.ncs.ea.ibs-infra.bt.com...
> What service pack are you running?
> Also could you post the few lines preceding the last line yo've posted.
>
>
> --
> Jack Vamvas
> ____________________
____________________
____________________
______
> Receive free SQL tips - register at www.ciquery.com/sqlserver.htm
> SQL Server Performance Audit - check www.ciquery.com/sqlserver_audit.htm
> New article by Jack Vamvas - SQL and Markov Chains -
> www.ciquery.com/articles/art_04.asp
> "VM" <VM@discussions.microsoft.com> wrote in message
> news:D9C79E35-DB99-46EB-B476- 05666DA5B904@microso
ft.com...
> reboot
> specific
> service
>
>

2006-02-06, 8:23 pm

Hi Jack,

I am running on SQL Server 2000 with Service pack 3a. Here is the log

2006-02-03 13:42:22.43 server Microsoft SQL Server 2000 - 8.00.760
(Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)

2006-02-03 13:42:22.43 server Copyright (C) 1988-2002 Microsoft
Corporation.
2006-02-03 13:42:22.43 server All rights reserved.
2006-02-03 13:42:22.43 server Server Process ID is 816.
2006-02-03 13:42:22.45 server Logging SQL Server messages in file
'D:\Microsoft SQL Server\MSSQL\log\ERR
ORLOG'.
2006-02-03 13:42:22.56 server SQL Server is starting at priority class
'normal'(1 CPU detected).
2006-02-03 13:42:23.01 server SQL Server configured for thread mode
processing.
2006-02-03 13:42:23.03 server Using dynamic lock allocation. [2500] Lock
Blocks, [5000] Lock Owner Blocks.
2006-02-03 13:42:23.09 server Attempting to initialize Distributed
Transaction Coordinator.

Thanks a lot,
VM

"Jack Vamvas" wrote:

> What service pack are you running?
> Also could you post the few lines preceding the last line yo've posted.
>
>
> --
> Jack Vamvas
> ____________________
____________________
____________________
______
> Receive free SQL tips - register at www.ciquery.com/sqlserver.htm
> SQL Server Performance Audit - check www.ciquery.com/sqlserver_audit.htm
> New article by Jack Vamvas - SQL and Markov Chains -
> www.ciquery.com/articles/art_04.asp
> "VM" <VM@discussions.microsoft.com> wrote in message
> news:D9C79E35-DB99-46EB-B476- 05666DA5B904@microso
ft.com...
> reboot
> specific
> service
>
>
>

2006-02-06, 8:23 pm

Hi,

Thanks for the reply. When I checked in both the systems Print spooler
service is disabled. I will check with system administrator about it and
test it.

Thanks a lot,
VM

"Sonvn-ICB" wrote:

> HI. I have same problem and I had solved it. You check Print Splooer Service
> type is start automatic.
> "Jack Vamvas" < DELETE_BEFORE_REPLY_
jack@ciquery.com> wrote in message
> news:ds2j0o$jpu$1@nw
rdmz03.dmz.ncs.ea.ibs-infra.bt.com...
>
>
>

Sponsored Links