Post reply

errors while runnning the weekly scheduled 'Updatestats' maintenance plan task job

  • November 12, 2009 at 10:33 am

    #217610

    Hi,

    We have SQL Server 2005 Developer edition 32 bit with SP3 and 4 GB RAM with Max memory set to 3GB. I'm getting the below errors in error log while runnning the weekly scheduled 'Updatestats' maintenance plan task job which is taking more than 1 hr.

    Please advice me what this messages refereing to?

    2009-11-07 10:21:40.16 Server Process 0:0:0 (0x714) Worker 0x009EC0E8 appears to be non-yielding on Scheduler 1. Thread creation time: 12901858554468. Approx Thread CPU Used: kernel 0 ms, user 0 ms. Process Utilization 0%. System Idle 98%. Interval: 75000 ms.

    2009-11-07 10:23:55.18 Server Process 79:0:0 (0x2fc) Worker 0x41F000E8 appears to be non-yielding on Scheduler 0. Thread creation time: 12901988576326. Approx Thread CPU Used: kernel 0 ms, user 0 ms. Process Utilization 0%. System Idle 97%. Interval: 75000 ms.

    2009-11-07 10:24:05.18 Server Process 71:0:0 (0xfd0) Worker 0x34F3E0E8 appears to be non-yielding on Scheduler 1. Thread creation time: 12902070629717. Approx Thread CPU Used: kernel 0 ms, user 0 ms. Process Utilization 0%. System Idle 96%. Interval: 75000 ms.

    2009-11-07 10:24:55.18 Server Process 79:0:0 (0x2fc) Worker 0x41F000E8 appears to be non-yielding on Scheduler 0. Thread creation time: 12901988576326. Approx Thread CPU Used: kernel 0 ms, user 0 ms. Process Utilization 0%. System Idle 97%. Interval: 135000 ms.

    2009-11-07 10:25:05.18 Server Process 71:0:0 (0xfd0) Worker 0x34F3E0E8 appears to be non-yielding on Scheduler 1. Thread creation time: 12902070629717. Approx Thread CPU Used: kernel 0 ms, user 0 ms. Process Utilization 0%. System Idle 97%. Interval: 135000 ms.

    2009-11-07 10:25:55.18 Server Process 79:0:0 (0x2fc) Worker 0x41F000E8 appears to be non-yielding on Scheduler 0. Thread creation time: 12901988576326. Approx Thread CPU Used: kernel 0 ms, user 0 ms. Process Utilization 0%. System Idle 97%. Interval: 195000 ms.

    2009-11-07 10:26:05.18 Server Process 71:0:0 (0xfd0) Worker 0x34F3E0E8 appears to be non-yielding on Scheduler 1. Thread creation time: 12902070629717. Approx Thread CPU Used: kernel 0 ms, user 0 ms. Process Utilization 0%. System Idle 97%. Interval: 195000 ms.

    2009-11-07 10:26:55.18 Server Process 79:0:0 (0x2fc) Worker 0x41F000E8 appears to be non-yielding on Scheduler 0. Thread creation time: 12901988576326. Approx Thread CPU Used: kernel 0 ms, user 0 ms. Process Utilization 0%. System Idle 97%. Interval: 255000 ms.

    2009-11-07 10:27:05.18 Server Process 71:0:0 (0xfd0) Worker 0x34F3E0E8 appears to be non-yielding on Scheduler 1. Thread creation time: 12902070629717. Approx Thread CPU Used: kernel 0 ms, user 0 ms. Process Utilization 0%. System Idle 97%. Interval: 255000 ms.

    2009-11-07 10:27:55.18 Server Process 79:0:0 (0x2fc) Worker 0x41F000E8 appears to be non-yielding on Scheduler 0. Thread creation time: 12901988576326. Approx Thread CPU Used: kernel 0 ms, user 0 ms. Process Utilization 0%. System Idle 97%. Interval: 315000 ms.

    2009-11-07 10:28:05.18 Server Process 71:0:0 (0xfd0) Worker 0x34F3E0E8 appears to be non-yielding on Scheduler 1. Thread creation time: 12902070629717. Approx Thread CPU Used: kernel 0 ms, user 0 ms. Process Utilization 0%. System Idle 97%. Interval: 315000 ms.

    2009-11-07 10:31:51.48 Server Process 62:0:0 (0xb14) Worker 0x1CD940E8 appears to be non-yielding on Scheduler 0. Thread creation time: 12901858575765. Approx Thread CPU Used: kernel 0 ms, user 0 ms. Process Utilization 0%. System Idle 98%. Interval: 75000 ms.

    2009-11-07 10:32:06.48 Server Process 64:0:0 (0xac8) Worker 0x722A40E8 appears to be non-yielding on Scheduler 1. Thread creation time: 12902068679717. Approx Thread CPU Used: kernel 0 ms, user 0 ms. Process Utilization 0%. System Idle 98%. Interval: 75000 ms.

    2009-11-07 2

    thanks

  • November 12, 2009 at 5:20 pm

    #1078654

    Looks like about the same problem you ran into the other day in this thread.

    Here is a blog about the same sort of issue.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 2 posts - 1 through 1 (of 1 total)

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