SQL Server generating sporadic Memory Dumps
6
votes
2
answers
695
views
We're running a 2014 SQL Server. For the past couple of years, the server generates memory dumps with no rhyme or reason, every 2-7 days, locking up most processes, and forcing us to restart the SQL service to get it going.
Here's snippet of the error file:
Exception Address = 00007FFAD7FCBAA2 Module(combase+000000000003BAA2)
Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
Access Violation occurred reading address 00000000D8063158
Input Buffer 74 bytes -
Anything else we should explore?
Or is our ONLY option to have Microsoft analyze the
.MDMP
file(s) ?
Points to mention:
- We have it patched to the latest Service Package, with the latest Cumulative & GDR updates. Hasn't made a difference
Microsoft SQL Server 2014 (SP3-CU4-GDR) (KB5014164) - 12.0.6439.10 (X64)
- There's no specific SQL statements/stored procedures that correlate to when these memory dumps occur.
- The SQL database files run on a seperate Hard drive than the OS. It's a 1TB drive with 250GB free at any given time.
- The Machine is a Windows Server 2012 R2, Virtual Machine
- CHKDSK
does not find any errors on the OS & Data drives.
- DBCC checks go through without issues.
- OPENQUERY
& OPENROWSET
functions are used quite frequently, using the latest ACE
& ODBC
drivers.
- If I query sys.dm_server_memory_dumps, here's the record count by date:
creation_time QTY
2022-09-13 1
2022-09-09 38
2022-09-07 11
2022-09-06 21
2022-09-04 1
2022-08-25 2
2022-08-24 11
2022-08-23 7
2022-08-22 1
2022-08-21 1
2022-08-17 9
2022-08-09 7
2022-07-29 1
2022-07-27 1
2022-07-22 1
Asked by Depth of Field
(233 rep)
Sep 13, 2022, 03:47 PM
Last activity: Nov 12, 2023, 07:59 PM
Last activity: Nov 12, 2023, 07:59 PM