|
Home > Archive > MS SQL Server > July 2005 > UMS Context appears to be non-yielding on Scheduler
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 |
UMS Context appears to be non-yielding on Scheduler
|
|
| massimo70 2005-06-13, 1:23 pm |
| Hi all,
Since a couple of days on our production server the following error:
2005-06-12 23:28:49.65 server Error: 17883, Severity: 1, State: 0
2005-06-12 23:28:49.65 server Process 57:0 (658) UMS Context
0x061D0048 appears to be non-yielding on Scheduler 3.
Some specs:
Intel Xeon 2CPU, 3.8GB 2.5GHz, HD 220GB
OS: Win 2K SP3
SQL Server 2000: Standard Edition SP4
AS 2000 SP4
Backups and complex queries are running and never ending...
SQL Server is stalled, low or no-responsive!!
1 weeks ago SP4 installed...
All info found on this topic did at the moment not help to solve this
issue (i am aware about some missing fixes in SP4).
This morning MS Support contacted. Waiting for a call...
I just wanted to share my frustration and any help would be of course
very appreciated.
Regards, Massimo
--
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbforumz.com/Server-UMS-...pict231844.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=803002
Posted Via mcse.ms Premium Usenet Newsgroup Services
----------------------------------------------------------
** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
----------------------------------------------------------
http://www.mcse.ms
| |
| phcahill 2005-07-18, 8:23 pm |
| "massimo70" wrote:
> Hi all,
>
> Since a couple of days on our production server the following
> error:
>
> 2005-06-12 23:28:49.65 server Error: 17883, Severity: 1,
> State: 0
> 2005-06-12 23:28:49.65 server Process 57:0 (658) UMS
> Context 0x061D0048 appears to be non-yielding on Scheduler 3.
>
> Some specs:
> Intel Xeon 2CPU, 3.8GB 2.5GHz, HD 220GB
> OS: Win 2K SP3
> SQL Server 2000: Standard Edition SP4
> AS 2000 SP4
>
> Backups and complex queries are running and never ending...
> SQL Server is stalled, low or no-responsive!!
>
> 1 weeks ago SP4 installed...
> All info found on this topic did at the moment not help to
> solve this issue (i am aware about some missing fixes in SP4).
> This morning MS Support contacted. Waiting for a call...
> I just wanted to share my frustration and any help would be of
> course very appreciated.
>
> Regards, Massimo
Any luck getting an answer? Dying here too.
| |
| massimo70 2005-07-22, 8:23 pm |
| "phcahill" wrote:
> Any luck getting an answer? Dying here too.
No feedback from PSS after sending memdumps and logs files.
MS wanted to have a copy of prod db but customer did not allow us to
do it. We have fixed the problem downgrading to SP3a. No everything
works fine.
Cheers, Massimo
| |
| phcahill 2005-07-22, 8:23 pm |
| "massimo70" wrote:
> No feedback from PSS after sending memdumps and logs files.
> MS wanted to have a copy of prod db but customer did not allow
> us to do it. We have fixed the problem downgrading to SP3a. No
> everything works fine.
> Cheers, Massimo
We installed sp4 to try to help analyze some data corruption problems
we were having. We had also turned off write caching on our
controllers. I saw this happen directly after an auto grow.
We have moved to a new server and so far no corruption and no hangs of
this type. So maybe it’s caused by corruption checkdb() or slow disks
on a large autogrow.
Paul
|
|
|
|
|