SQL Server is Terminating Because of Fatal Exception 80000003 – How to Troubleshoot

In this article, we will be discussing about the error message “SQL Server is Terminating Because of Fatal Exception 80000003” and how to troubleshoot it.

In more detail, the error message to talk about is:

SQL Server is terminating due to fatal exception 80000003. This error can be caused by an unhandled Win32 or C ++ exception, or by an access violation encountered during exception handling. Check the SQL error log for related stack dumps or messages. This exception forces a shutdown of SQL Server. To recover from this error, restart the server (unless SQLAgent is configured to restart automatically).

 

What does this error mean?

This error means that the SQL Server process has been terminated. In the case of a failover cluster, most probably, the SQL Server service will be terminated and started again the Cluster Manager.

The “Fatal Exception 80000003” error, is typically caused by heap corruption.

However, since SQL Server does not allocate memory from its heap, that means that the root cause for the corruption is something else.

 

The role of third-party modules

Based on the above, there can be other entities that may cause heap corruption and thus get the “Fatal Exception 80000003” error.

Such entities can be for example linked servers that use third-party drivers, as well as any other DLLs that may be loaded in SQL Server.

 

How to troubleshoot the error

A useful query that can help you identify if you have installed any third party modules in SQL Server is the below:

SELECT * 
FROM sys.dm_os_loaded_modules 
WHERE company != 'Microsoft Corporation';
GO

Now, if the above query returns any records, you will need to go through one by one, and check whether you are using or not, the latest version of these drivers/modules.

Moreover, in the “description” column in the record set returned by the above query, an indication that might be related to the error, is to identify any third party modules that may be using Win32 classes (i.e. WMI, etc.) and further focus your troubleshooting to these modules.

Last but not least, you can consider opening a Microsoft Support ticket along with checking whether SQL Server generated a dump file or not (*.mdmp), when the service failed (Microsoft Support might ask for the dump file).

To find the location of the dump file:

  • You open SQL Server Configuration Manager
  • You open the properties of the SQL Server service (right click – properties)
  • You navigate to the “Advanced” tab and in there you can find the dump directory

 

SQL Server is Terminating Because of Fatal Exception 80000003 - How to Troubleshoot - Article on SQLNetHub

 

 


 

Strengthen your SQL Server Administration Skills – Enroll to our Online Course!

Check our online course on Udemy titled “Essential SQL Server Administration Tips
(special limited-time discount included in link).

Via the course, you will learn essential hands-on SQL Server Administration tips on SQL Server maintenance, security, performance, integration, error handling and more. Many live demonstrations and downloadable resources included!

Essential SQL Server Administration Tips - Online Course with Live Demonstrations and Hands-on Guides
(Lifetime Access/ Live Demos / Downloadable Resources and more!)

Enroll Now with Discount!

 


 

Learn essential SQL Server development tips – Enroll to our Online Course!

Check our online course titled “Essential SQL Server Development Tips for SQL Developers
(special limited-time discount included in link).

Sharpen your SQL Server database programming skills via a large set of tips on T-SQL and database development techniques. The course, among other, features over than 30 live demonstrations!

Essential SQL Server Development Tips for SQL Developers - Online Course
(Lifetime Access/ Live Demos / Downloadable Resources and more!)

Enroll Now with Discount!


 

Featured Online Courses:

 

Read Also:

 

Subscribe to our newsletter and stay up to date!

Subscribe to our YouTube channel (SQLNetHub TV)

Easily generate snippets with Snippets Generator!

Secure your databases using DBA Security Advisor!

Generate dynamic T-SQL scripts with Dynamic SQL Generator!

Check our latest software releases!

Check our eBooks!

 

Rate this article: 1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 5.00 out of 5)

Loading...

Reference: SQLNetHub.com (https://www.sqlnethub.com)

© SQLNetHub