Post reply

Stack dump occured unable to understand and find the cause

  • August 1, 2012 at 3:47 am

    #278771

    Hi All,

    I overserved some messeges in sql error log stating

    Using 'dbghelp.dll' version '4.0.5'

    Exception Address = 00000000009B2204 Module(sqlservr+0000000000142204)

    * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION

    * Access Violation occurred writing address 0000000000000020

    ***Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQL2008PS\MSSQL\LOG\SQLDump0007.txt

    I have attached the stack dump details which occurred on one of the production server.

    Please help to understand dump and guide me how serious is this and what is the cause for this.

    Thanks in advance

  • August 1, 2012 at 3:52 am

    #1520158

    Patch your SQL instance to the highest service pack available (SP2), consider setting a sensible max server memory and if the dump reoccurs call Customer support and log a case. They have tools to read stack dumps.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • August 1, 2012 at 4:02 am

    #1520162

    Thanks Gail for your quick reply. I was expecting the expert comment on this.

    Can you put some light why it has happend (If you have any idea about it).

    Thanks for the reply.

    Vinod

  • August 1, 2012 at 7:40 am

    #1520268

    vinod.saraswat (8/1/2012)

    Can you put some light why it has happend (If you have any idea about it).

    No (other than the theory on what an access violation is, which you can find with google)

    To determine the cause I'd need the .mdmp file, a debugger, the SQL public symbols files and a day or two, even that probably wouldn't give me more than a general idea. Call CSS and log a case if you want to investigate this. They have access to source code and tools to read stack dumps that aren't public.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • August 1, 2012 at 8:17 am

    #1520301

    Thanks Gail for this valuable information.

    Really appreciate your efforts.

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

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