Sql Error

Please note Issues on SQL server. Details below.

There was a stackdump on server . We had not had one of these for many weeks since upgrading to SQL 2005 SP2 CU7.

2008-09-03 22:02:04.44 Server **Dump thread - spid = 0, PSS = 0x0000000000000000, EC = 0x0000000000000000
2008-09-03 22:02:07.77 Server ***Stack Dump being sent to D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\SQLDump0016.txt
2008-09-03 22:02:07.77 Server * 2008-09-03 22:02:07.77 Server *
2008-09-03 22:02:07.77 Server * BEGIN STACK DUMP:
2008-09-03 22:02:07.77 Server * 09/03/08 22:02:07 spid 0
2008-09-03 22:02:07.77 Server *
2008-09-03 22:02:07.77 Server * Non-yielding Resource Monitor
2008-09-03 22:02:09.38 Server *
2008-09-03 22:02:09.41 Server *
shyamkumar85Asked:
Who is Participating?
 
damalanoCommented:
This message is most often generated when reading a page from disk is extremely slow.  You should examine your errolog for other errors or signs of I/O issues.


Also look at this one http://blogs.msdn.com/psssql/archive/2008/03/28/how-it-works-non-yielding-resource-monitor.aspx


0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.