Getting SSMS error while open it

Question

Hi,

I am getting below error on SQL Server log file. Its a continuos error

2014-04-25 09:24:20.22 Server      Process 0:0:0 (0x3b00) Worker 0x00000000106361A0 appears to be non-yielding on Scheduler 4. Thread creation time: 13042907079739. Approx Thread CPU Used: kernel 2251156 ms, user 86034 ms. Process Utilization 2%. System Idle 96%. Interval: 2359260 ms.

SQL Server version : 2008 RTM

Thanks 

Deepak Goyal

Answer 1

Hi,

I am getting below error on SQL Server log file. Its a continuos error

2014-04-25 09:24:20.22 Server      Process 0:0:0 (0x3b00) Worker 0x00000000106361A0 appears to be non-yielding on Scheduler 4. Thread creation time: 13042907079739. Approx Thread CPU Used: kernel 2251156 ms, user 86034 ms. Process Utilization 2%. System Idle 96%. Interval: 2359260 ms.

SQL Server version : 2008 RTM

Thanks 

Deepak Goyal

Apply SQL Server 2008 SP3 .You are running unsupported version of SQL server 2008.SP3 will surely fix the issue

Download SQL Server 2008 SP3

---

Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers

Answer 2

But suddenly we got this error after getting some below Disk IO error.

“The operating system returned error 1392(The file or directory is corrupted and unreadable.) to SQL Server during a write at offset 0x000000aff6e000 in file .....

Any other thoughts?

Answer 3

But suddenly we got this error after getting some Disk IO error.

“The operating system returned error 1392(The file or directory is corrupted and unreadable.) to SQL Server during a write at offset 0x000000aff6e000 in file .....

Hello,

Well this surely means some issue with Storage .YOur underlying storage on which your data and log files reside is corrupted.Please contact your storage administrator to get this corrected.

---

Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers

Answer 4

As per the error it seems like disk/file is corrupted. Better to contact with your system admin if disk is corrupted the change with new one or if file is corrupted then try to recover with the help of system admin.