Re: The Scheduler 2 appears to be hung
From: frankm (frankm_at_nospam.postalias)
Date: 01/07/05
- Next message: Richard Ding: "Re: Backing up SQL Server"
- Previous message: Dan Guzman: "Re: dt_verstampxxx"
- In reply to: Jeffrey Keung via SQLMonster.com: "The Scheduler 2 appears to be hung"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 7 Jan 2005 08:17:59 -0600
It's not the process that's hung - it's the Scheduler.
SQL Server has its own internal scheduler that takes over from the os
scheduler.
I believe that some of the 2000 scheduler concepts were first in 7.0....
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqldev/html/Sqldev_02252004.asp
Try this
http://support.microsoft.com/default.aspx?scid=kb;en-us;814693
Also check to see if any processes are running on the server like;
Virus Scan (on access and scheduled scans) and backups agents that may be
directly accessing the SQL Server files (mdf, ndf, ldf). SQL Server does not
like anything messing with it's files.
Also check the event log on the server to see if there are any delayed
read/writes or dropouts.
If scheduler 0 is hung then you will probably need to reboot (this is the
parent scheduler).
I see this a lot on 2000 32bit and more on 64 bit, most of the time it
clears itself.
About 1 out of 40 we have to restart SQL Server.
"Jeffrey Keung via SQLMonster.com" <forum@SQLMonster.com> wrote in message
news:56c015f2873c4548b8188ce17a0684db@SQLMonster.com...
> Hi all,
>
> Recently our SQL Server 7.0 (SP4) have got this error msg frequently.
> I'd no idea what's the problem but here is some foundings.
>
> 1) We onlty got this error msg but no dump file is generated:
> 2005-01-06 03:06:16.19 ods The Scheduler X appears to be hung. PSS
0x7D53D110, EC 0x7D53D2C0, UMS Context 0x04DC0018
> -- where X can be 0-3. If all Scheduler 0,1,2,3 error msg appear, the
whole machine is hung and all CPU is up to 100%, all resources is used up
and even u PING the server, it will be "request time out"
>
> 2) After checking the PSS number and compare all the value output by DBCC
PSS(uid,spid,0), we can find out which process is hung. However, when we
tried to kill it, it never success. the process is hung and cannot be
killed.
>
> 3) If we met this error, the system will be very slow and somtimes no
respond to all query. It means that sometimes we cannot find out which
process is hang.
>
> 4) We read all the KB and initially think that it is because of disk
contention. However, we'd changed the Disk Array connected to this server
but the same problem happened EVERYDAY.
>
> The system is in live run and it is assumed not to restart so often.
However, in these few months, it had been restarted 2-4 times EVERYDAY.
>
> Do anyone can do me a favour how to fix it ?
> Thank you very very much.
>
> Jeffrey
>
> --
> Message posted via http://www.sqlmonster.com
- Next message: Richard Ding: "Re: Backing up SQL Server"
- Previous message: Dan Guzman: "Re: dt_verstampxxx"
- In reply to: Jeffrey Keung via SQLMonster.com: "The Scheduler 2 appears to be hung"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
