HI Experts,

One of our PRD SQL service is getting restarted unexpectedly but SQL Agent is up and running during the same time SQL agent jobs are also running.

___________________________________________________________________________

Source: MSSQLServer  ,Event ID: 19019:

The MSSQLSERVER service terminated unexpectedly.

Application Error:

Source : Application error : EventID : 1000

We have couple of jobs that pull data from Linked server from external sources DB2 and Oracle.

We have recently upgraded to SQL 2012 (inplace), seems after that we are facing issues and its sofrequently.

SQL dumps are also generated for some SP's which uses linked server , SQLdump log stating Execption_access_violation.

today we found some more information before SQL gettign restarted for COMP Plus, please find the below error message.

__________________________________________________________________

Source : Complus EventID : 4786

________________________________________________________

Could you please assist us on this and guide me on how fix this issue.

Adding to this, Version of SQL is :

Microsoft SQL Server 2012 - 11.0.5058.0 (X64)   May 14 2014 18:34:29   Copyright (c) Microsoft Corporation  Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

HI Experts,

Could you please help me to fix this..or share any idea on how to investigate further..

is there any way to find whether Oracle client or IBM Iseries client coniguration or settings caused issue.

It would seem that this is an Application Crash (SQL Server is crashing).

Is there anything in the SQL Server Logs that could help explain what is happening?

>We have couple of jobs that pull data from Linked server from external sources DB2 and Oracle.

It's likely a failure in a 3rd party in-proc OleDB provider that you are using.  Exactly which OleDB providers are you using?

David

I concur with David its the Linked server provider which is causing the issue can you post output of

select * from sys.dm_os_loaded_modules

>We have couple of jobs that pull data from Linked server from external sources DB2 and Oracle.

It's likely a failure in a 3rd party in-proc OleDB provider that you are using.  Exactly which OleDB providers are you using?

SQL dumps are also generated for some SP's which uses linked server , SQLdump log stating Execption_access_violation.

Seems more of an application issue. Was there any issues with the TEMPDB?

Can you please share the event viewer details if any.

Thanks for the reply Pradyothana,

We had an IO issue on TempDB earlier , but we had moved to SSD"s so i believe it should not be an issue now.

Thanks for the Reply Balmukund,

I will share you SQL Dump . need to check and get approval for this..

Good to see your quick response for queries as always really appreciate it

Hi Experts,

I am so sorry for not replying for your valuable response, i was out of station ...

Today issue has reproduced again with below error.

Thanks for your Inputs David & Tony,

We have not upgraded DB2 or Oracle drivers to suit SQL 2012.

Do we have different drivers for DB2 and Oracle for SQL 2012 comptability.

Sure i will definelty check on this, this is not reproducing in lower environments, but in PRD we have more data so it may be reproducing ..i will di in this way..again thanks for your suggestions.

HI Balmukund,

I have shared the SQL Dump files.

Please let me know if you need any information.

1)      Update the MSVBVM60.dll to latest version. I checked our server and we have a version of 6.0.97.82 of the msvbvm60.dll  and they suggest to update it like below from a licensed version of the Vista machine. In my XP pro machine I have the version 6.0.98.2. 

2)      Modify the stored procedure to run the dll in its own process 
http://msdn2.microsoft.com/en-us/library/aa238863(SQL.80).aspx

Refer 

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/ea05a4e1-dfea-4293-ac45-85a9ea949832/sql-server-2008-is-terminating-because-of-fatal-exception-c0000005?forum=sqldatabaseengine