July 21, 2009 at 1:10 pm
After installing SQL Server 2005 sp2 and security update to version 9.00.3077 we are seeing messages like these:
Resource Monitor (0x7fc) Worker 0x0358C0E8 appears to be non-yielding on Node 0. Memory freed: 46840 KB. Approx CPU Used: kernel 109 ms, user 140 ms, Interval: 65000.
Resource Monitor (0x7fc) Worker 0x0358C0E8 appears to be non-yielding on Node 0. Memory freed: 32560 KB. Approx CPU Used: kernel 109 ms, user 46 ms, Interval: 60002.
I only see articles addressing this error for a 64bit server. We are 32bit. Windows 2003 standard ed, R2.
Should we grant lock pages in memory, hard code min/max memory settings, install a later SQL Server 2005 update?
We greatly appreciate any help on the best way to solve this. Thanks very much.
February 25, 2010 at 11:11 am
same here, same config - Win2K3 R2, SQL Server 2005 Standard 32 bit
the version of SQL we are running is different: 9.00.4035
3,75 GB of memory on a box.
show those two messages in the log:
Date2/25/2010 7:35:54 AM
LogSQL Server (Archive #1 - 2/25/2010 7:36:00 AM)
SourceServer
Message
Resource Monitor (0x7ac) Worker 0x04E8E0E8 appears to be non-yielding on Node 0. Memory freed: 0 KB. Approx CPU Used: kernel 62 ms, user 140 ms, Interval: 78647157.
followed by :
Date2/25/2010 7:36:01 AM
LogSQL Server (Archive #1 - 2/25/2010 7:36:00 AM)
Sourcespid64
Message
Timeout occurred while waiting for latch: class 'SECURITY_OBJPERM_CACHE', id 04F1E174, type 2, Task 0x00B84898 : 0, waittime 3600, flags 0x1a, owning task 0x0084A7A8. Continuing to wait.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply