RE: Database in Recovery mode from last 7 days.

SSC Journeyman

Points: 86

February 12, 2013 at 1:11 am

Hello Sir,

FYI, Below SQL error log.

2013-02-12 13:26:51.05 Server Process 18:0:0 (0x1598) Worker 0x00000000043B21C0 appears to be non-yielding on Scheduler 3. Thread creation time: 13004279824516. Approx Thread CPU Used: kernel 187 ms, user 12448 ms. Process Utilization 0%. System Idle 98%. Interval: 849570342 ms.

2013-02-12 13:27:51.14 Server Process 18:0:0 (0x1598) Worker 0x00000000043B21C0 appears to be non-yielding on Scheduler 3. Thread creation time: 13004279824516. Approx Thread CPU Used: kernel 187 ms, user 12448 ms. Process Utilization 0%. System Idle 98%. Interval: 849630433 ms.

2013-02-12 13:28:51.23 Server Process 18:0:0 (0x1598) Worker 0x00000000043B21C0 appears to be non-yielding on Scheduler 3. Thread creation time: 13004279824516. Approx Thread CPU Used: kernel 187 ms, user 12448 ms. Process Utilization 0%. System Idle 98%. Interval: 849690524 ms.

2013-02-12 13:29:51.32 Server Process 18:0:0 (0x1598) Worker 0x00000000043B21C0 appears to be non-yielding on Scheduler 3. Thread creation time: 13004279824516. Approx Thread CPU Used: kernel 187 ms, user 12448 ms. Process Utilization 0%. System Idle 98%. Interval: 849750615 ms.

2013-02-12 13:30:51.41 Server Process 18:0:0 (0x1598) Worker 0x00000000043B21C0 appears to be non-yielding on Scheduler 3. Thread creation time: 13004279824516. Approx Thread CPU Used: kernel 187 ms, user 12448 ms. Process Utilization 0%. System Idle 98%. Interval: 849810706 ms.

2013-02-12 13:31:51.50 Server Process 18:0:0 (0x1598) Worker 0x00000000043B21C0 appears to be non-yielding on Scheduler 3. Thread creation time: 13004279824516. Approx Thread CPU Used: kernel 187 ms, user 12448 ms. Process Utilization 0%. System Idle 98%. Interval: 849870796 ms.

2013-02-12 13:32:51.59 Server Process 18:0:0 (0x1598) Worker 0x00000000043B21C0 appears to be non-yielding on Scheduler 3. Thread creation time: 13004279824516. Approx Thread CPU Used: kernel 187 ms, user 12448 ms. Process Utilization 0%. System Idle 98%. Interval: 849930887 ms.

2013-02-12 13:33:51.68 Server Process 18:0:0 (0x1598) Worker 0x00000000043B21C0 appears to be non-yielding on Scheduler 3. Thread creation time: 13004279824516. Approx Thread CPU Used: kernel 187 ms, user 12448 ms. Process Utilization 0%. System Idle 98%. Interval: 849990978 ms.

2013-02-12 13:34:51.77 Server Process 18:0:0 (0x1598) Worker 0x00000000043B21C0 appears to be non-yielding on Scheduler 3. Thread creation time: 13004279824516. Approx Thread CPU Used: kernel 187 ms, user 12448 ms. Process Utilization 0%. System Idle 98%. Interval: 850051069 ms.

2013-02-12 13:35:51.86 Server Process 18:0:0 (0x1598) Worker 0x00000000043B21C0 appears to be non-yielding on Scheduler 3. Thread creation time: 13004279824516. Approx Thread CPU Used: kernel 187 ms, user 12448 ms. Process Utilization 0%. System Idle 98%. Interval: 850111160 ms.

2013-02-12 13:36:51.95 Server Process 18:0:0 (0x1598) Worker 0x00000000043B21C0 appears to be non-yielding on Scheduler 3. Thread creation time: 13004279824516. Approx Thread CPU Used: kernel 187 ms, user 12448 ms. Process Utilization 0%. System Idle 98%. Interval: 850171251 ms.

2013-02-12 13:37:52.05 Server Process 18:0:0 (0x1598) Worker 0x00000000043B21C0 appears to be non-yielding on Scheduler 3. Thread creation time: 13004279824516. Approx Thread CPU Used: kernel 187 ms, user 12448 ms. Process Utilization 0%. System Idle 98%. Interval: 850231341 ms.

2013-02-12 13:38:52.14 Server Process 18:0:0 (0x1598) Worker 0x00000000043B21C0 appears to be non-yielding on Scheduler 3. Thread creation time: 13004279824516. Approx Thread CPU Used: kernel 187 ms, user 12448 ms. Process Utilization 0%. System Idle 98%. Interval: 850291432 ms.

Please help me out.