non-yielding resource monitor

  • 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 post 1 (of 2 total)

You must be logged in to reply to this topic. Login to reply