Sql Error

Posted on 2008-11-06
Last Modified: 2013-11-21
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 *
Question by:shyamkumar85
    1 Comment
    LVL 4

    Accepted Solution

    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


    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Join & Write a Comment

    Many admins will agree: WSUS is is a nice invention but using it on the client side when updating a newly installed computer is still time consuming as you have to do several reboots and furthermore, the procedure of installing updates, rebooting an…
    INTRODUCTION The purpose of this document is to demonstrate the Installation and configuration of the Data Protection Manager product. Note that this demonstration was prepared on the basis of Windows OS is 2008 R2 and DPM 2010. DATA PROTECTI…
    This video Micro Tutorial explains how to clone a hard drive using a commercial software product for Windows systems called Casper from Future Systems Solutions (FSS). Cloning makes an exact, complete copy of one hard disk drive (HDD) onto another d…
    In this video, we discuss why the need for additional vertical screen space has become more important in recent years, namely, due to the transition in the marketplace of 4x3 computer screens to 16x9 and 16x10 screens (so-called widescreen format). …

    732 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now