SQL 2005 Cluster Crash With: ***Unable to get thread context - no pss

  • Can anyone help with the below errors? Thx

    DUMPLOG:

    -----------

    Computer type is AT/AT COMPATIBLE.

    Bios Version is DELL - 1

    Phoenix ROM BIOS PLUS Version 1.10 A04

    Current time is 01:57:00 06/23/08.

    8 Intel x86 level 15, 3158 Mhz processor (s).

    Windows NT 5.2 Build 3790 CSD Service Pack 1.

    Memory

    MemoryLoad = 92%

    Total Physical = 16379 MB

    Available Physical = 1164 MB

    Total Page File = 17841 MB

    Available Page File = 9338 MB

    Total Virtual = 2047 MB

    Available Virtual = 100 MB

    ***Unable to get thread context - no pss

    * *******************************************************************************

    *

    * BEGIN STACK DUMP:

    * 06/23/08 01:57:05 spid 0

    *

    * Non-yielding Scheduler

    *

    * *******************************************************************************

    SQL LOG:

    ----------

    Date23/06/2008 01:57:05

    LogSQL Server (Archive #1 - 23/06/2008 02:04:00)

    SourceServer

    Message

    * BEGIN STACK DUMP:

    Date23/06/2008 01:57:05

    LogSQL Server (Archive #1 - 23/06/2008 02:04:00)

    SourceServer

    Message

    ***Unable to get thread context - no pss

    Date23/06/2008 01:56:57

    LogSQL Server (Archive #1 - 23/06/2008 02:04:00)

    SourceServer

    Message

    Using 'dbghelp.dll' version '4.0.5'

    SQL DBA
    Every day is a school day, and don't trust anyone who tells you any different.
    http://sqlblogness.blogspot.co.uk

  • is it giving frequent Dumps. as form your configuration it looks like Memory pressure.. read about Memory Leaks and Memory pressure on BOl or Google around for more info...I will see what i find..

  • Ok here is what i exactly figured out.. check this out:

    http://sql-server-performance.com/Community/forums/p/13952/80618.aspx

  • Thanks for your response. This is the first occassion that I have seen the dumps so I am not sure if this will be a continuing issue.

    I will keep my eye on it.

    Cheers

    SQL DBA
    Every day is a school day, and don't trust anyone who tells you any different.
    http://sqlblogness.blogspot.co.uk

Viewing 4 posts - 1 through 3 (of 3 total)

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