begin stack dump error no sql server 2012

Question

Tenho um micro com Windows Server 2008 R2 enterprise com o SQL Server 2012. Este vem apresentando falha. No Event Viewer aparece esta mensagem: The SQL Server (MSSQLSERVER) service terminated unexpectedly. It has done this 8 time(s).

No log do SQL, no momento da falha, aparece uma mensagem begin stack dump.

Como consigo corrigir esta falha?

Em anexo, prints do event viewer e da versão do SQL Server, além dos Logs extraídos do ERRORLOG.txt Falha_eventViewer_03_12_2025_P51.png Versão do SQL Server.pngSQLDump0032.txt

Answer 1

Stack dumps like this one are often due to bugs in SQL Server. The way to get them resolved is to open a support case with Microsoft. But since you are on a very old an unsupported version that route is not really open to you. Maybe you should consider upgrading to a more modern version - chances are that bug that causes the stack dump has been fixed.

Stack dumps can also be due to external components that runs in SQL Server's memory space. This can be:

1. Extended stored procedures.
2. OLE objects invoked from sp_OAxxxxx-
3. Unsafe CLR modules.
4. Linked servers using third-party drivers that runs with "Allow in-process".

If such components has bugs they can scribble SQL Server's own memory which leads to random crashes.

Another possible source for such dumps are hardware errors, particularly faulty memory sticks.