Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server access violation Expand / Collapse
Author
Message
Posted Thursday, March 28, 2013 4:07 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, July 1, 2014 2:28 AM
Points: 100, Visits: 507
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
Post #1436362
Posted Thursday, March 28, 2013 4:40 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 5:10 AM
Points: 112, Visits: 1,207
Please check this post: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=164488

SQL Database Recovery Expert
Post #1436375
Posted Thursday, March 28, 2013 5:46 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, July 17, 2014 6:47 AM
Points: 223, Visits: 1,718
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
Post #1436409
Posted Thursday, March 28, 2013 11:22 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, July 1, 2014 2:28 AM
Points: 100, Visits: 507
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
Post #1436827
Posted Saturday, March 30, 2013 9:55 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 1:27 PM
Points: 5,974, Visits: 12,875
if this is giving you a serious issue frankly I would refer it to microsoft support, they are the experts on dump files.

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

Post #1437202
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse