Scheduler is hung

I have a SQL 2000 with sp3 recently connected to the NetApps filer. For
the last two days the SQL Server keeps hanging. I can't even log on to
the machine, can't open enterprise manager. We have to bounce the
server. The errorlog indicates:
2004-03-01 17:07:20.38 server Error: 17883, Severity: 1, State: 0
2004-03-01 17:07:20.38 server The Scheduler 0 appears to be hung.
SPID 0, ECID 0, UMS Context 0x03469860.
2004-03-01 17:07:20.38 server Error: 17883, Severity: 1, State: 0
2004-03-01 17:07:20.38 server The Scheduler 1 appears to be hung.
SPID 59, ECID 0, UMS Context 0x0346BC48.
2004-03-01 17:08:20.39 server Error: 17883, Severity: 1, State: 0
2004
What does it mean by the scheduler? Is this where the Enterprise
manager runs all the scheduled jobs?
Have any ideas as to what's going on?
Thanks,
Raziq.
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!It could be:
FIX: The Checkpoint Process Can Delay SQL Server Database Activity and Does
Not Yield Scheduler Correctly Causing Error: 17883 to Occur
http://support.microsoft.com/defaul...6&Product=sql2k
Known bug. Call PSS to confirm and get the hotfix.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Raziq Shekha" <raziq_shekha@.anadarko.com> wrote in message
news:uluFM4GAEHA.2432@.TK2MSFTNGP11.phx.gbl...
> I have a SQL 2000 with sp3 recently connected to the NetApps filer. For
> the last two days the SQL Server keeps hanging. I can't even log on to
> the machine, can't open enterprise manager. We have to bounce the
> server. The errorlog indicates:
>
> 2004-03-01 17:07:20.38 server Error: 17883, Severity: 1, State: 0
> 2004-03-01 17:07:20.38 server The Scheduler 0 appears to be hung.
> SPID 0, ECID 0, UMS Context 0x03469860.
> 2004-03-01 17:07:20.38 server Error: 17883, Severity: 1, State: 0
> 2004-03-01 17:07:20.38 server The Scheduler 1 appears to be hung.
> SPID 59, ECID 0, UMS Context 0x0346BC48.
> 2004-03-01 17:08:20.39 server Error: 17883, Severity: 1, State: 0
> 2004
> What does it mean by the scheduler? Is this where the Enterprise
> manager runs all the scheduled jobs?
> Have any ideas as to what's going on?
> Thanks,
> Raziq.
>
> *** Sent via Developersdex http://www.examnotes.net ***
> Don't just participate in USENET...get rewarded for it!