• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 265
  • Last Modified:

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 *
0
shyamkumar85
Asked:
shyamkumar85
1 Solution
 
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

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now