Home Forums SQL Server 2012 SQL 2012 - General SQL Server has encountered 1 occurrence of I/O Requests taking longer than 15 seconds RE: SQL Server has encountered 1 occurrence of I/O Requests taking longer than 15 seconds

  • tony28 (3/27/2014)


    Thank you, good job, very helpful and thanks for experience. I know that this option is in SQL server, but i wouldn't remember in that time

    So Service state is both on ... so now i understand ...

    and what do you think that it can be cause?

    and I found one log yet, i couldnt open before, i dont like metro on servers..

    2014-03-21 18:08:39 - ? [131] SQLSERVERAGENT service stopping due to a stop request from a user, process, or the OS...

    2014-03-21 18:08:41 - ! [240] 1 engine thread(s) failed to stop after 2 seconds of waiting

    2014-03-21 18:08:41 - ! [311] Thread 'JobManager - CmdExec step' (ID 5240) is still running

    2014-03-21 18:08:41 - ! [311] Thread 'JobInvocationEngine' (ID 5340) is still running

    2014-03-21 18:08:41 - ! [311] Thread 'JobManager - CmdExec step' (ID 5712) is still running

    2014-03-21 18:08:41 - ! [311] Thread 'JobManager - TSQL step' (ID 6716) is still running

    2014-03-21 18:08:41 - ! [311] Thread 'JobManager - TSQL step' (ID 9092) is still running

    2014-03-21 18:08:41 - ! [311] Thread 'JobManager - TSQL step' (ID 9844) is still running

    2014-03-21 18:08:41 - ! [311] Thread 'JobManager - TSQL step' (ID 10668) is still running

    2014-03-21 18:08:41 - ? [000] Configuration option 'Agent XPs' changed from 1 to 0. Run the RECONFIGURE statement to install. [SQLSTATE 01000] (Message 15457)

    2014-03-21 18:08:41 - + [098] SQLServerAgent terminated (forcefully)

    You are welcome, Tony. You need to look for the log entries that have occured before 2014-03-21 18:08:39.

    To find the reason for SQL Server failure, try to check the cluster log for errors. Check this for the cluster log ..

    http://www.sqlserver-expert.com/2012/05/how-to-generate-clusterlog-for-windows.html

    --

    SQLBuddy