SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL Server access violation


SQL Server access violation

Author
Message
vkundar
vkundar
Old Hand
Old Hand (303 reputation)Old Hand (303 reputation)Old Hand (303 reputation)Old Hand (303 reputation)Old Hand (303 reputation)Old Hand (303 reputation)Old Hand (303 reputation)Old Hand (303 reputation)

Group: General Forum Members
Points: 303 Visits: 869
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
prettsons
prettsons
SSChasing Mays
SSChasing Mays (632 reputation)SSChasing Mays (632 reputation)SSChasing Mays (632 reputation)SSChasing Mays (632 reputation)SSChasing Mays (632 reputation)SSChasing Mays (632 reputation)SSChasing Mays (632 reputation)SSChasing Mays (632 reputation)

Group: General Forum Members
Points: 632 Visits: 1388
Please check this post: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=164488

SQL Database Recovery Expert :-)
e4d4
e4d4
SSC-Addicted
SSC-Addicted (471 reputation)SSC-Addicted (471 reputation)SSC-Addicted (471 reputation)SSC-Addicted (471 reputation)SSC-Addicted (471 reputation)SSC-Addicted (471 reputation)SSC-Addicted (471 reputation)SSC-Addicted (471 reputation)

Group: General Forum Members
Points: 471 Visits: 2399
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
vkundar
vkundar
Old Hand
Old Hand (303 reputation)Old Hand (303 reputation)Old Hand (303 reputation)Old Hand (303 reputation)Old Hand (303 reputation)Old Hand (303 reputation)Old Hand (303 reputation)Old Hand (303 reputation)

Group: General Forum Members
Points: 303 Visits: 869
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:BigGrinump
sqlservr!SQLDumperLibraryInvoke
sqlservr!CImageHelper:BigGrinoMiniDump
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
george sibbald
george sibbald
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10660 Visits: 13687
if this is giving you a serious issue frankly I would refer it to microsoft support, they are the experts on dump files.

---------------------------------------------------------------------
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search