SqlDumpExceptionHandler: Process 12 generated fatal exception c000000d EXCEPTION_INVALID_CRT_PARAMET
服务器上面安装的数据库服务器是Microsoft SQL Server 2012 (SP1) - 11.0.3368.0 (Intel X86)的版本,最近一段时间经常因为内存使用率高(60%)会不断的生成dump文件(转储文件),类似于图一这种
打开SQLDump0020.txt文件里面的内容是这样的,还有部分没有粘贴出来
Current time is 18:14:01 05/09/19.
=====================================================================
BugCheck Dump
=====================================================================
This file is generated by Microsoft SQL Server
version 11.0.3128.0
upon detection of fatal unexpected error. Please return this file,
the query or program that produced the bugcheck, the database and
the error log, and any other pertinent information with a Service Request.
Computer type is Intel(R) Xeon(R) CPU E5-2670 0 @ 2.60GHz.
Bios Version is INTEL - 6040000
PhoenixBIOS 4.0 Release 6.0
8 Intel x86 level 6, 2 Mhz processor (s).
Windows NT 6.2 Build 9200 CSD .
Memory
MemoryLoad = 33%
Total Physical = 16383 MB
Available Physical = 10832 MB
Total Page File = 18815 MB
Available Page File = 13033 MB
Total Virtual = 4095 MB
Available Virtual = 1408 MB
***Stack Dump being sent to C:\Program Files (x86)\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\LOG\SQLDump0020
.txt
SqlDumpExceptionHandler: Process 12 generated fatal exception c000000d EXCEPTION_INVALID_CRT_PARAMETER. SQL Serve
r is terminating this process.
* *******************************************************************************
*
* BEGIN STACK DUMP:
* 05/09/19 18:14:01 spid 12
*
*
* Exception Address = 768B96C2 Module(KERNELBASE+000D96C2)
* Exception Code = c000000d EXCEPTION_INVALID_CRT_PARAMETER
*
主要是这个异常:EXCEPTION_INVALID_CRT_PARAMETER
百度之后就可以查到这个异常需要安装2833645这个补丁
但是因为这个补丁已经不在支持下载了
https://support.microsoft.com/en-us/help/2833645/cumulative-update-package-4-for-sql-server-2012-sp1
所以我们只能到微软更新目录中取搜索
https://www.catalog.update.microsoft.com/Search.aspx?q=2833645
然后根据自己的数据库服务器的版本下载安装,如果下载的版本不对,安装的时候会找不到数据库实例,所以务必注意
下载完成后没有强制重启服务器,但是为了保险起见,我还是重启了一下,安装至今已经一周多,没有再生成转储文件!