Post reply

Dump file

  • May 15, 2009 at 11:20 am

    #134418

    Hi,

    We are using SQL Server 2005 devloper edition 32 bit with SP3 on Widows 2003 standard edition 32 bit with SP2. Memory 2GB

    Iam going through the error log, and I find the below dump file. What exactly this dump file error referring to?

    2009-04-19 08:09:22.84 Server Using 'dbghelp.dll' version '4.0.5'

    2009-04-19 08:09:22.92 Server **Dump thread - spid = 0, PSS = 0x00000000, EC = 0x00000000

    2009-04-19 08:09:22.92 Server ***Stack Dump being sent to D:\Program Files\Microsoft SQL Server\MSSQL\LOG\SQLDump0001.txt

    2009-04-19 08:09:22.92 Server * *******************************************************************************

    2009-04-19 08:09:22.92 Server *

    2009-04-19 08:09:22.92 Server * BEGIN STACK DUMP:

    2009-04-19 08:09:22.92 Server * 04/19/09 08:09:22 spid 0

    2009-04-19 08:09:22.92 Server *

    2009-04-19 08:09:22.92 Server * Non-yielding Resource Monitor

    2009-04-19 08:09:22.92 Server *

    2009-04-19 08:09:22.92 Server * *******************************************************************************

    2009-04-19 08:09:22.92 Server * -------------------------------------------------------------------------------

    2009-04-19 08:09:22.92 Server * Short Stack Dump

    2009-04-19 08:09:23.37 Server Stack Signature for the dump is 0x000002ED

    2009-04-19 08:09:36.00 Server External dump process return code 0x20000001.

    External dump process returned no errors.

    2009-04-19 08:09:36.01 Server Resource Monitor (0x9dc) Worker 0x03B0E0E8 appears to be non-yielding on Node 0. Memory freed: 2072 KB. Approx CPU Used: kernel 15 ms, user 0 ms, Interval: 60266.

  • May 15, 2009 at 12:07 pm

    #995568

    In short, SQL Server monitoring is sending out an alert about a process consuming a large amount of memory... check here: http://support.microsoft.com/default.aspx?scid=kb;en-us;959004&sd=rss&spid=2855

    Interesting enough the very act of sending out the alert is somehow considered a buggy behavior.

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply