SQL Server access violation

  • Hi All,

    My sql server crashed and I see the following error in my error log. I browsed the net got to know to analyze the mdmp files but iam not sure how to do that .

    PLease help me to find the issue

    2013-03-26 09:16:26.58 Server *

    2013-03-26 09:16:26.58 Server * BEGIN STACK DUMP:

    2013-03-26 09:16:26.58 Server * 03/26/13 09:16:26 spid 13784

    2013-03-26 09:16:26.58 Server *

    2013-03-26 09:16:26.58 Server * ex_handle_except encountered exception C0000005 - Server terminating

    2013-03-26 09:16:26.58 Server

    Waiting for your input.

    Thanks you

    Cheers,

    Got an idea..share it !!

    DBA_Vishal

  • This was removed by the editor as SPAM

  • Check this http://mssqlwiki.com/2012/10/16/sql-server-exception_access_violation-and-sql-server-assertion/ there is a basic knowledge how to debug a dump file

  • Thanks for helping to understand ho to debug the mdmp file. The KC 1000 output gives me the following result.

    0:000> kc 1000

    Call Site

    kernel32!RaiseException

    sqlservr!CDmpDump::Dump

    sqlservr!SQLDumperLibraryInvoke

    sqlservr!CImageHelper::DoMiniDump

    sqlservr!stackTrace

    sqlservr!stackTraceCallBack

    sqlservr!ex_handle_except

    kernel32!UnhandledExceptionFilter

    ntdll!RtlUserThreadStart

    ntdll!_C_specific_handler

    ntdll!RtlpExecuteHandlerForException

    ntdll!RtlDispatchException

    ntdll!KiUserExceptionDispatcher

    msxml6!Base::freeRentalObjects

    msxml6!Base::StackExitNormal

    msxml6!ModelInit::~ModelInit

    msxml6!SAXReader::parse

    MSO

    0x0

    0x0

    0x0

    ntdll!RtlAllocateHeap

    any pointers? Not able to read or understand it.

    Thanks.

    Cheers,

    Got an idea..share it !!

    DBA_Vishal

  • if this is giving you a serious issue frankly I would refer it to microsoft support, they are the experts on dump files.

    ---------------------------------------------------------------------

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

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