Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Monday, January 23, 2017 7:52 AM
Hello,
i have an issue as my SQL server database has unexpected behavior and stopped the services and logged a SQL Core Dump . i tried to open this core dump using windows debugging tool. i set the Symbol Path and tried to open the core dump but i got the following message:
Loading unloaded module list
................................................................
This dump file has an exception of interest stored in it.
The stored exception information can be accessed via .ecxr.
(79c.371c): Unknown exception - code 000042ac (first/second chance not available)
ntdll!NtWaitForSingleObject+0xa:
00007ff8`ee3506fa c3 ret
do you recommend another tool to read the SQL Dump or i have to use windows debugging tool but i missed a step.
Appreciate your support.
Regards
Monday, January 23, 2017 8:53 AM ✅Answered
Please read carefully, you need to use WinDbg exe to look deeper into
https://developer.microsoft.com/en-us/windows/hardware/windows-driver-kit
Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/
MS SQL optimization: MS SQL Development and Optimization
MS SQL Consulting: Large scale of database and data cleansing
Remote DBA Services: Improves MS SQL Database Performance
SQL Server Integration Services: Business Intelligence
Monday, January 23, 2017 7:51 AM
Hello,
i have an issue as my SQL server database has unexpected behavior and stopped the services and logged a SQL Core Dump . i tried to open this core dump using windows debugging tool. i set the Symbol Path and tried to open the core dump but i got the following message:
Loading unloaded module list
................................................................
This dump file has an exception of interest stored in it.
The stored exception information can be accessed via .ecxr.
(79c.371c): Unknown exception - code 000042ac (first/second chance not available)
ntdll!NtWaitForSingleObject+0xa:
00007ff8`ee3506fa c3 ret
do you recommend another tool to read the SQL Dump or i have to use windows debugging tool but i missed a step.
Appreciate your support.
Regards
Monday, January 23, 2017 8:01 AM | 1 vote
https://blogs.msdn.microsoft.com/sqlcat/2009/09/11/looking-deeper-into-sql-server-using-minidumps/
Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/
MS SQL optimization: MS SQL Development and Optimization
MS SQL Consulting: Large scale of database and data cleansing
Remote DBA Services: Improves MS SQL Database Performance
SQL Server Integration Services: Business Intelligence
Monday, January 23, 2017 8:44 AM
thanks for your support.
I'm not trying to create a dump file.
SQL server already shutdown SQL services and through SQL Dump file.
I need to open this Dump file and read its content to understand the error caused services to stop suddenly.
Thanks again for your support.
Monday, January 23, 2017 1:26 PM
These problems are almost always problems inside the SQL Server program. Before pursuing trying to decode the dump, you should make sure you are running the latest Service Pack and Cumulative Update. It is likely the problem is resolved by updating your SQL Server.