数据库数据太多数据库太大造成dump文件（内存转储文件）
数据库数据太多数据库太大造成dump文件（内存转储文件）
今晚我在SQL2012上测试了一下前天那个帖子的问题
我的环境：Windows7，SQL2012开发版 SP1
是个人电脑，我的电脑上没有程序用到SQL2012里的数据库
使用下面脚本
窗口一
1 --清空错误日志 EXEC [sys].[sp_cycle_errorlog] 2 --测试脚本 USE [pratice] GO 3 --建表 CREATE TABLE [SystemPara] 4 ( [RecordNo] [int] IDENTITY(1,1) NOT NULL, 5 [ParaValue] [varchar](50) NULL, 6 [Name] [varchar](50) NULL, 7 [Description] [varchar](50) NULL ) 8 GO 9 --测试 10 WHILE 1 = 1 11 BEGIN 12 INSERT INTO [dbo].[SystemPara] 13 SELECT '22' , '22' , '33' 14 15 UPDATE [dbo].[SystemPara] SET [ParaValue] = '989' 16 WHERE [RecordNo] = 23 17 END
窗口二
1 DBCC CHECKDB([pratice])
窗口三
1 EXEC [sys].[xp_readerrorlog]
在SQL2005上就没有问题，可以看到下面信息
2013-11-27 09:50:25.89 spid56 268 transactions rolled forward in database 'GPOSDB' (7). This is an informational message only. No user action is required.
2013-11-27 09:50:25.89 spid56 0 transactions rolled back in database 'GPOSDB' (7). This is an informational message only. No user action is required.
但是SQL2012就会显示
错误日志
1 LogDate ProcessInfo Text 2 ----------------------- ------------ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 3 2013-11-28 20:15:03.930 spid58 Microsoft SQL Server 2012 (SP1) - 11.0.3000.0 (Intel X86) 4 Oct 19 2012 13:43:21 5 Copyright (c) Microsoft Corporation 6 Developer Edition on Windows NT 6.1 <X86> (Build 7601: Service Pack 1) 7 2013-11-28 20:15:03.930 spid58 (c) Microsoft Corporation. 8 2013-11-28 20:15:03.930 spid58 All rights reserved. 9 2013-11-28 20:15:03.930 spid58 Server process ID is 1440. 10 2013-11-28 20:15:03.930 spid58 System Manufacturer: 'Hasee', System Model: 'QTH6'. 11 2013-11-28 20:15:03.930 spid58 Authentication mode is MIXED. 12 2013-11-28 20:15:03.930 spid58 Logging SQL Server messages in file 'D:\Program Files\Microsoft SQL Server\MSSQL11.SQL2012\MSSQL\Log\ERRORLOG'. 13 2013-11-28 20:15:03.930 spid58 The service account is 'NT Service\MSSQL$SQL2012'. This is an informational message; no user action is required. 14 2013-11-28 20:15:03.930 spid58 The error log has been reinitialized. See the previous log for older entries. 15 2013-11-28 20:15:16.490 spid59 DBCC TRACEON 3604, server process ID (SPID) 59. This is an informational message only; no user action is required. 16 2013-11-28 20:15:16.490 spid59 DBCC TRACEOFF 3604, server process ID (SPID) 59. This is an informational message only; no user action is required. 17 2013-11-28 20:15:26.920 spid61 122 transactions rolled forward in database 'pratice' (9:0). This is an informational message only. No user action is required. 18 2013-11-28 20:15:26.920 spid61 0 transactions rolled back in database 'pratice' (9:0). This is an informational message only. No user action is required. 19 2013-11-28 20:15:28.000 spid61 DBCC CHECKDB is performing an exhaustive search of 1 indexes for possible inconsistencies. This is an informational message only. No user action is required. 20 2013-11-28 20:15:28.020 spid61 Exhaustive search of 'sys.sysschobjs, nc3' (database ID 9) for inconsistencies completed. Processed 1 of 1 total searches. Elapsed time: 19 milliseconds. This is an informational message only. No user action is required. 21 2013-11-28 20:15:29.340 spid61 DBCC CHECKDB (pratice) executed by JOE\Administrator found 4 errors and repaired 0 errors. Elapsed time: 0 hours 0 minutes 2 seconds. 内部 数据库快照的拆分点 LSN 为 00000c0e:00001c28:0003，第一个 LSN 为 00000c0e:00001ba8:0001。 22 2013-11-28 20:15:29.370 spid61 Using 'dbghelp.dll' version '4.0.5' 23 2013-11-28 20:15:29.390 spid61 **Dump thread - spid = 0, EC = 0x1239FDC8 24 2013-11-28 20:15:29.390 spid61 ***Stack Dump being sent to D:\Program Files\Microsoft SQL Server\MSSQL11.SQL2012\MSSQL\LOG\SQLDump0003.txt 25 2013-11-28 20:15:29.390 spid61 * ******************************************************************************* 26 2013-11-28 20:15:29.390 spid61 * 27 2013-11-28 20:15:29.390 spid61 * BEGIN STACK DUMP: 28 2013-11-28 20:15:29.390 spid61 * 11/28/13 20:15:29 spid 61 29 2013-11-28 20:15:29.390 spid61 * 30 2013-11-28 20:15:29.390 spid61 * DBCC database corruption 31 2013-11-28 20:15:29.390 spid61 * 32 2013-11-28 20:15:29.390 spid61 * Input Buffer 68 bytes - 33 2013-11-28 20:15:29.390 spid61 * DBCC CHECKDB([pratice]) 34 2013-11-28 20:15:29.390 spid61 * 35 2013-11-28 20:15:29.390 spid61 * ******************************************************************************* 36 2013-11-28 20:15:29.390 spid61 * ------------------------------------------------------------------------------- 37 2013-11-28 20:15:29.390 spid61 * Short Stack Dump 38 2013-11-28 20:15:29.420 spid61 Stack Signature for the dump is 0x00000088 39 2013-11-28 20:15:30.140 spid61 External dump process return code 0x20000001. 40 External dump process returned no errors. 41 42 2013-11-28 20:16:09.270 spid59 DBCC TRACEON 3604, server process ID (SPID) 59. This is an informational message only; no user action is required. 43 2013-11-28 20:16:09.280 spid59 DBCC TRACEOFF 3604, server process ID (SPID) 59. This is an informational message only; no user action is required. 44 2013-11-28 20:20:15.890 spid57 Starting up database 'TESTDB'. 45 2013-11-28 20:22:03.290 spid60 DBCC TRACEON 3604, server process ID (SPID) 60. This is an informational message only; no user action is required. 46 2013-11-28 20:22:03.300 spid60 DBCC TRACEOFF 3604, server process ID (SPID) 60. This is an informational message only; no user action is required. 47 2013-11-28 20:28:57.100 spid61 DBCC TRACEON 3604, server process ID (SPID) 61. This is an informational message only; no user action is required. 48 2013-11-28 20:28:57.100 spid61 DBCC TRACEOFF 3604, server process ID (SPID) 61. This is an informational message only; no user action is required. 49 2013-11-28 20:29:27.870 spid62 148 transactions rolled forward in database 'pratice' (9:0). This is an informational message only. No user action is required. 50 2013-11-28 20:29:27.870 spid62 1 transactions rolled back in database 'pratice' (9:0). This is an informational message only. No user action is required. 51 2013-11-28 20:29:28.940 spid62 DBCC CHECKDB is performing an exhaustive search of 1 indexes for possible inconsistencies. This is an informational message only. No user action is required. 52 2013-11-28 20:29:28.960 spid62 Exhaustive search of 'sys.sysschobjs, nc3' (database ID 9) for inconsistencies completed. Processed 1 of 1 total searches. Elapsed time: 20 milliseconds. This is an informational message only. No user action is required. 53 2013-11-28 20:29:30.350 spid62 DBCC CHECKDB (pratice) executed by JOE\Administrator found 4 errors and repaired 0 errors. Elapsed time: 0 hours 0 minutes 2 seconds. 内部 数据库快照的拆分点 LSN 为 00000c0e:00004b41:0001，第一个 LSN 为 00000c0e:00004aa8:0001。 54 2013-11-28 20:29:30.410 spid62 Using 'dbghelp.dll' version '4.0.5' 55 2013-11-28 20:29:30.440 spid62 **Dump thread - spid = 0, EC = 0x143F3DC8 56 2013-11-28 20:29:30.440 spid62 ***Stack Dump being sent to D:\Program Files\Microsoft SQL Server\MSSQL11.SQL2012\MSSQL\LOG\SQLDump0004.txt 57 2013-11-28 20:29:30.440 spid62 * ******************************************************************************* 58 2013-11-28 20:29:30.440 spid62 * 59 2013-11-28 20:29:30.440 spid62 * BEGIN STACK DUMP: 60 2013-11-28 20:29:30.440 spid62 * 11/28/13 20:29:30 spid 62 61 2013-11-28 20:29:30.440 spid62 * 62 2013-11-28 20:29:30.440 spid62 * DBCC database corruption 63 2013-11-28 20:29:30.440 spid62 * 64 2013-11-28 20:29:30.440 spid62 * Input Buffer 68 bytes - 65 2013-11-28 20:29:30.440 spid62 * DBCC CHECKDB([pratice]) 66 2013-11-28 20:29:30.440 spid62 * 67 2013-11-28 20:29:30.440 spid62 * ******************************************************************************* 68 2013-11-28 20:29:30.440 spid62 * ------------------------------------------------------------------------------- 69 2013-11-28 20:29:30.440 spid62 * Short Stack Dump 70 2013-11-28 20:29:30.480 spid62 Stack Signature for the dump is 0x00000088 71 2013-11-28 20:29:31.300 spid62 External dump process return code 0x20000001. 72 External dump process returned no errors. 73 74 2013-11-28 20:29:33.430 spid62 112 transactions rolled forward in database 'pratice' (9:0). This is an informational message only. No user action is required. 75 2013-11-28 20:29:33.430 spid62 1 transactions rolled back in database 'pratice' (9:0). This is an informational message only. No user action is required. 76 2013-11-28 20:29:34.480 spid62 DBCC CHECKDB is performing an exhaustive search of 1 indexes for possible inconsistencies. This is an informational message only. No user action is required. 77 2013-11-28 20:29:34.500 spid62 Exhaustive search of 'sys.sysschobjs, nc3' (database ID 9) for inconsistencies completed. Processed 1 of 1 total searches. Elapsed time: 21 milliseconds. This is an informational message only. No user action is required. 78 2013-11-28 20:29:35.840 spid62 DBCC CHECKDB (pratice) executed by JOE\Administrator found 4 errors and repaired 0 errors. Elapsed time: 0 hours 0 minutes 2 seconds. 内部 数据库快照的拆分点 LSN 为 00000c0e:00005837:0001，第一个 LSN 为 00000c0e:000057c2:0002。 79 2013-11-28 20:29:35.870 spid62 Using 'dbghelp.dll' version '4.0.5' 80 2013-11-28 20:29:35.900 spid62 **Dump thread - spid = 0, EC = 0x143F3DC8 81 2013-11-28 20:29:35.900 spid62 ***Stack Dump being sent to D:\Program Files\Microsoft SQL Server\MSSQL11.SQL2012\MSSQL\LOG\SQLDump0005.txt 82 2013-11-28 20:29:35.900 spid62 * ******************************************************************************* 83 2013-11-28 20:29:35.900 spid62 * 84 2013-11-28 20:29:35.900 spid62 * BEGIN STACK DUMP: 85 2013-11-28 20:29:35.900 spid62 * 11/28/13 20:29:35 spid 62 86 2013-11-28 20:29:35.900 spid62 * 87 2013-11-28 20:29:35.900 spid62 * DBCC database corruption 88 2013-11-28 20:29:35.900 spid62 * 89 2013-11-28 20:29:35.900 spid62 * Input Buffer 68 bytes - 90 2013-11-28 20:29:35.900 spid62 * DBCC CHECKDB([pratice]) 91 2013-11-28 20:29:35.910 spid62 * 92 2013-11-28 20:29:35.910 spid62 * ******************************************************************************* 93 2013-11-28 20:29:35.910 spid62 * ------------------------------------------------------------------------------- 94 2013-11-28 20:29:35.910 spid62 * Short Stack Dump 95 2013-11-28 20:29:35.940 spid62 Stack Signature for the dump is 0x00000088 96 2013-11-28 20:29:36.680 spid62 External dump process return code 0x20000001. 97 External dump process returned no errors. 98 99 2013-11-28 20:32:31.730 spid61 DBCC TRACEON 3604, server process ID (SPID) 61. This is an informational message only; no user action is required. 100 2013-11-28 20:32:31.730 spid61 DBCC TRACEOFF 3604, server process ID (SPID) 61. This is an informational message only; no user action is required. 101 102 (89 行受影响)
dump文件
SQLDump0004.txt
1 Current time is 20:29:30 11/28/13. 2 ===================================================================== 3 BugCheck Dump 4 ===================================================================== 5 6 This file is generated by Microsoft SQL Server 7 version 11.0.3000.0 8 upon detection of fatal unexpected error. Please return this file, 9 the query or program that produced the bugcheck, the database and 10 the error log, and any other pertinent information with a Service Request. 11 12 13 Computer type is Intel(R) Core(TM) i3-2350M CPU @ 2.30GHz. 14 Bios Version is LENOVO - 1 15 4 Intel x86 level 6, 2 Mhz processor (s). 16 Windows NT 6.1 Build 7601 CSD Service Pack 1. 17 18 Memory 19 MemoryLoad = 93% 20 Total Physical = 3021 MB 21 Available Physical = 204 MB 22 Total Page File = 5520 MB 23 Available Page File = 2165 MB 24 Total Virtual = 2047 MB 25 Available Virtual = 1338 MB 26 27 28 DBCC RESULTS 29 -------------------- 30 <DbccResults> 31 <Dbcc ID="0" Error="8997" Severity="10" State="1">Service Broker 消息 9675，状态 1: 已分析的消息类型: 14。</Dbcc> 32 <Dbcc ID="1" Error="8997" Severity="10" State="1">Service Broker 消息 9676，状态 1: 已分析的服务约定: 6。</Dbcc> 33 <Dbcc ID="2" Error="8997" Severity="10" State="1">Service Broker 消息 9667，状态 1: 已分析的服务: 3。</Dbcc> 34 <Dbcc ID="3" Error="8997" Severity="10" State="1">Service Broker 消息 9668，状态 1: 已分析的服务队列: 3。</Dbcc> 35 <Dbcc ID="4" Error="8997" Severity="10" State="1">Service Broker 消息 9669，状态 1: 已分析的会话端点: 0。</Dbcc> 36 <Dbcc ID="5" Error="8997" Severity="10" State="1">Service Broker 消息 9674，状态 1: 已分析的会话组: 0。</Dbcc> 37 <Dbcc ID="6" Error="8997" Severity="10" State="1">Service Broker 消息 9670，状态 1: 已分析的远程服务绑定: 0。</Dbcc> 38 <Dbcc ID="7" Error="8997" Severity="10" State="1">Service Broker 消息 9605，状态 1: 已分析的会话优先级: 0。</Dbcc> 39 <Dbcc ID="8" Error="2593" Severity="10" State="1">对象 'sys.sysrscols' 的 15 页中有 1105 行。</Dbcc> 40 <Dbcc ID="9" Error="2593" Severity="10" State="1">对象 'sys.sysrowsets' 的 2 页中有 185 行。</Dbcc> 41 <Dbcc ID="10" Error="2593" Severity="10" State="1">对象 'sys.sysclones' 的 0 页中有 0 行。</Dbcc> 42 <Dbcc ID="11" Error="2593" Severity="10" State="1">对象 'sys.sysallocunits' 的 3 页中有 206 行。</Dbcc> 43 <Dbcc ID="12" Error="2593" Severity="10" State="1">对象 'sys.sysfiles1' 的 1 页中有 2 行。</Dbcc> 44 <Dbcc ID="13" Error="2593" Severity="10" State="1">对象 'sys.sysseobjvalues' 的 0 页中有 0 行。</Dbcc> 45 <Dbcc ID="14" Error="2593" Severity="10" State="1">对象 'sys.syspriorities' 的 0 页中有 0 行。</Dbcc> 46 <Dbcc ID="15" Error="2593" Severity="10" State="1">对象 'sys.sysdbfrag' 的 0 页中有 0 行。</Dbcc> 47 <Dbcc ID="16" Error="2593" Severity="10" State="1">对象 'sys.sysfgfrag' 的 0 页中有 0 行。</Dbcc> 48 <Dbcc ID="17" Error="2593" Severity="10" State="1">对象 'sys.sysdbfiles' 的 1 页中有 3 行。</Dbcc> 49 <Dbcc ID="18" Error="2593" Severity="10" State="1">对象 'sys.syspru' 的 0 页中有 0 行。</Dbcc> 50 <Dbcc ID="19" Error="2593" Severity="10" State="1">对象 'sys.sysbrickfiles' 的 0 页中有 0 行。</Dbcc> 51 <Dbcc ID="20" Error="2593" Severity="10" State="1">对象 'sys.sysphfg' 的 1 页中有 1 行。</Dbcc> 52 <Dbcc ID="21" Error="2593" Severity="10" State="1">对象 'sys.sysprufiles' 的 1 页中有 3 行。</Dbcc> 53 <Dbcc ID="22" Error="2593" Severity="10" State="1">对象 'sys.sysftinds' 的 1 页中有 1 行。</Dbcc> 54 <Dbcc ID="23" Error="2593" Severity="10" State="1">对象 'sys.sysowners' 的 1 页中有 14 行。</Dbcc> 55 <Dbcc ID="24" Error="2593" Severity="10" State="1">对象 'sys.sysdbreg' 的 0 页中有 0 行。</Dbcc> 56 <Dbcc ID="25" Error="2593" Severity="10" State="1">对象 'sys.sysprivs' 的 1 页中有 138 行。</Dbcc> 57 <Dbcc ID="26" Error="8951" Severity="16" State="1">表错误: 表 'sys.sysschobjs' (ID 34)。数据行在索引 'nc3' (ID 4)中没有匹配的索引行。与 58 以下数据行匹配的索引行的键可能丢失或无效:</Dbcc> 59 <Dbcc ID="27" Error="8955" Severity="16" State="1">数据行(1:13775:7)由(id = 615673241)标识，索引值为“pid = 0 and pclass = 1 60 and id = 615673241”。</Dbcc> 61 <Dbcc ID="28" Error="8951" Severity="16" State="1">表错误: 表 'sys.sysschobjs' (ID 34)。数据行在索引 'nc3' (ID 4)中没有匹配的索引行。与 62 以下数据行匹配的索引行的键可能丢失或无效:</Dbcc> 63 <Dbcc ID="29" Error="8955" Severity="16" State="1">数据行(1:13775:9)由(id = 631673298)标识，索引值为“pid = 0 and pclass = 1 64 and id = 631673298”。</Dbcc> 65 <Dbcc ID="30" Error="8952" Severity="16" State="1">表错误: 表 'sys.sysschobjs' (ID 34)。索引 'nc3' (ID 4)中的索引行与任何数据行都不匹配 66 。可能是以下行的多余或无效的键:</Dbcc> 67 <Dbcc ID="31" Error="8956" Severity="16" State="1">索引行(1:13861:70)的值为(pid = 0 and pclass = 1 and id = 165575628)， 68 指向由(id = 165575628)标识的数据行。</Dbcc> 69 <Dbcc ID="32" Error="8952" Severity="16" State="1">表错误: 表 'sys.sysschobjs' (ID 34)。索引 'nc3' (ID 4)中的索引行与任何数据行都不匹配 70 。可能是以下行的多余或无效的键:</Dbcc> 71 <Dbcc ID="33" Error="8956" Severity="16" State="1">索引行(1:13861:71)的值为(pid = 0 and pclass = 1 and id = 181575685)， 72 指向由(id = 181575685)标识的数据行。</Dbcc> 73 <Dbcc ID="34" Error="2593" Severity="10" State="1">对象 'sys.sysschobjs' 的 33 页中有 2282 行。</Dbcc> 74 <Dbcc ID="35" Error="8990" Severity="10" State="1">CHECKDB 在表 'sys.sysschobjs' (对象 ID 34)中发现 0 个分配错误和 4 个一致性错误。</ 75 Dbcc> 76 <Dbcc ID="36" Error="2593" Severity="10" State="1">对象 'sys.syscolpars' 的 19 页中有 996 行。</Dbcc> 77 <Dbcc ID="37" Error="2593" Severity="10" State="1">对象 'sys.sysxlgns' 的 0 页中有 0 行。</Dbcc> 78 <Dbcc ID="38" Error="2593" Severity="10" State="1">对象 'sys.sysxsrvs' 的 0 页中有 0 行。</Dbcc> 79 <Dbcc ID="39" Error="2593" Severity="10" State="1">对象 'sys.sysnsobjs' 的 1 页中有 1 行。</Dbcc> 80 <Dbcc ID="40" Error="2593" Severity="10" State="1">对象 'sys.sysusermsgs' 的 0 页中有 0 行。</Dbcc> 81 <Dbcc ID="41" Error="2593" Severity="10" State="1">对象 'sys.syscerts' 的 1 页中有 0 行。</Dbcc> 82 <Dbcc ID="42" Error="2593" Severity="10" State="1">对象 'sys.sysrmtlgns' 的 0 页中有 0 行。</Dbcc> 83 <Dbcc ID="43" Error="2593" Severity="10" State="1">对象 'sys.syslnklgns' 的 0 页中有 0 行。</Dbcc> 84 <Dbcc ID="44" Error="2593" Severity="10" State="1">对象 'sys.sysxprops' 的 1 页中有 2 行。</Dbcc> 85 <Dbcc ID="45" Error="2593" Severity="10" State="1">对象 'sys.sysscalartypes' 的 1 页中有 35 行。</Dbcc> 86 <Dbcc ID="46" Error="2593" Severity="10" State="1">对象 'sys.systypedsubobjs' 的 1 页中有 0 行。</Dbcc> 87 <Dbcc ID="47" Error="2593" Severity="10" State="1">对象 'sys.sysidxstats' 的 6 页中有 319 行。</Dbcc> 88 <Dbcc ID="48" Error="2593" Severity="10" State="1">对象 'sys.sysiscols' 的 3 页中有 497 行。</Dbcc> 89 <Dbcc ID="49" Error="2593" Severity="10" State="1">对象 'sys.sysendpts' 的 0 页中有 0 行。</Dbcc> 90 <Dbcc ID="50" Error="2593" Severity="10" State="1">对象 'sys.syswebmethods' 的 0 页中有 0 行。</Dbcc> 91 <Dbcc ID="51" Error="2593" Severity="10" State="1">对象 'sys.sysbinobjs' 的 1 页中有 23 行。</Dbcc> 92 <Dbcc ID="52" Error="2593" Severity="10" State="1">对象 'sys.sysaudacts' 的 0 页中有 0 行。</Dbcc> 93 <Dbcc ID="53" Error="2593" Severity="10" State="1">对象 'sys.sysobjvalues' 的 83 页中有 343 行。</Dbcc> 94 <Dbcc ID="54" Error="2593" Severity="10" State="1">对象 'sys.syscscolsegments' 的 0 页中有 0 行。</Dbcc> 95 <Dbcc ID="55" Error="2593" Severity="10" State="1">对象 'sys.syscsdictionaries' 的 0 页中有 0 行。</Dbcc> 96 <Dbcc ID="56" Error="2593" Severity="10" State="1">对象 'sys.sysclsobjs' 的 1 页中有 20 行。</Dbcc> 97 <Dbcc ID="57" Error="2593" Severity="10" State="1">对象 'sys.sysrowsetrefs' 的 0 页中有 0 行。</Dbcc> 98 <Dbcc ID="58" Error="2593" Severity="10" State="1">对象 'sys.sysremsvcbinds' 的 0 页中有 0 行。</Dbcc> 99 <Dbcc ID="59" Error="2593" Severity="10" State="1">对象 'sys.sysxmitqueue' 的 0 页中有 0 行。</Dbcc> 100 <Dbcc ID="60" Error="2593" Severity="10" State="1">对象 'sys.sysrts' 的 1 页中有 1 行。</Dbcc> 101 <Dbcc ID="61" Error="2593" Severity="10" State="1">对象 'sys.sysconvgroup' 的 0 页中有 0 行。</Dbcc> 102 <Dbcc ID="62" Error="2593" Severity="10" State="1">对象 'sys.sysdesend' 的 0 页中有 0 行。</Dbcc> 103 <Dbcc ID="63" Error="2593" Severity="10" State="1">对象 'sys.sysdercv' 的 0 页中有 0 行。</Dbcc> 104 <Dbcc ID="64" Error="2593" Severity="10" State="1">对象 'sys.syssingleobjrefs' 的 1 页中有 193 行。</Dbcc> 105 <Dbcc ID="65" Error="2593" Severity="10" State="1">对象 'sys.sysmultiobjrefs' 的 1 页中有 122 行。</Dbcc> 106 <Dbcc ID="66" Error="2593" Severity="10" State="1">对象 'sys.sysguidrefs' 的 1 页中有 1 行。</Dbcc> 107 <Dbcc ID="67" Error="2593" Severity="10" State="1">对象 'sys.sysfoqueues' 的 0 页中有 0 行。</Dbcc> 108 <Dbcc ID="68" Error="2593" Severity="10" State="1">对象 'sys.syschildinsts' 的 0 页中有 0 行。</Dbcc> 109 <Dbcc ID="69" Error="2593" Severity="10" State="1">对象 'sys.syscompfragments' 的 1 页中有 1 行。</Dbcc> 110 <Dbcc ID="70" Error="2593" Severity="10" State="1">对象 'sys.sysftsemanticsdb' 的 0 页中有 0 行。</Dbcc> 111 <Dbcc ID="71" Error="2593" Severity="10" State="1">对象 'sys.sysftstops' 的 0 页中有 0 行。</Dbcc> 112 <Dbcc ID="72" Error="2593" Severity="10" State="1">对象 'sys.sysftproperties' 的 0 页中有 0 行。</Dbcc> 113 <Dbcc ID="73" Error="2593" Severity="10" State="1">对象 'sys.sysxmitbody' 的 0 页中有 0 行。</Dbcc> 114 <Dbcc ID="74" Error="2593" Severity="10" State="1">对象 'sys.sysfos' 的 0 页中有 0 行。</Dbcc> 115 <Dbcc ID="75" Error="2593" Severity="10" State="1">对象 'sys.sysqnames' 的 1 页中有 100 行。</Dbcc> 116 <Dbcc ID="76" Error="2593" Severity="10" State="1">对象 'sys.sysxmlcomponent' 的 1 页中有 100 行。</Dbcc> 117 <Dbcc ID="77" Error="2593" Severity="10" State="1">对象 'sys.sysxmlfacet' 的 1 页中有 112 行。</Dbcc> 118 <Dbcc ID="78" Error="2593" Severity="10" State="1">对象 'sys.sysxmlplacement' 的 1 页中有 19 行。</Dbcc> 119 <Dbcc ID="79" Error="2593" Severity="10" State="1">对象 'sys.sysobjkeycrypts' 的 1 页中有 0 行。</Dbcc> 120 <Dbcc ID="80" Error="2593" Severity="10" State="1">对象 'sys.sysasymkeys' 的 1 页中有 0 行。</Dbcc> 121 <Dbcc ID="81" Error="2593" Severity="10" State="1">对象 'sys.syssqlguides' 的 0 页中有 0 行。</Dbcc> 122 <Dbcc ID="82" Error="2593" Severity="10" State="1">对象 'sys.sysbinsubobjs' 的 1 页中有 4 行。</Dbcc> 123 <Dbcc ID="83" Error="2593" Severity="10" State="1">对象 'sys.syssoftobjrefs' 的 1 页中有 13 行。</Dbcc> 124 <Dbcc ID="84" Error="2593" Severity="10" State="1">对象 'testpivot' 的 1 页中有 12 行。</Dbcc> 125 <Dbcc ID="85" Error="2593" Severity="10" State="1">对象 'Orders' 的 1477 页中有 121317 行。</Dbcc> 126 <Dbcc ID="86" Error="2593" Severity="10" State="1">对象 'Department' 的 28 页中有 3277 行。</Dbcc> 127 <Dbcc ID="87" Error="2593" Severity="10" State="1">对象 'UserInfo' 的 2 页中有 3 行。</Dbcc> 128 <Dbcc ID="88" Error="2593" Severity="10" State="1">对象 'Department9' 的 1 页中有 5 行。</Dbcc> 129 <Dbcc ID="89" Error="2593" Severity="10" State="1">对象 'SQLTRACESAMPLE' 的 0 页中有 0 行。</Dbcc> 130 <Dbcc ID="90" Error="2593" Severity="10" State="1">对象 'testcolumn' 的 3 页中有 500 行。</Dbcc> 131 <Dbcc ID="91" Error="2593" Severity="10" State="1">对象 'Users' 的 4 页中有 707 行。</Dbcc> 132 <Dbcc ID="92" Error="2593" Severity="10" State="1">对象 'encrypttb_demo' 的 1 页中有 2 行。</Dbcc> 133 <Dbcc ID="93" Error="2593" Severity="10" State="1">对象 'Department10' 的 107 页中有 9999 行。</Dbcc> 134 <Dbcc ID="94" Error="2593" Severity="10" State="1">对象 'Table1' 的 1 页中有 3 行。</Dbcc> 135 <Dbcc ID="95" Error="2593" Severity="10" State="1">对象 'PWDQuestion' 的 1 页中有 1 行。</Dbcc> 136 <Dbcc ID="96" Error="2593" Severity="10" State="1">对象 'Table2' 的 1 页中有 2 行。</Dbcc> 137 <Dbcc ID="97" Error="2593" Severity="10" State="1">对象 'fulltext_test' 的 1 页中有 10 行。</Dbcc> 138 <Dbcc ID="98" Error="2593" Severity="10" State="1">对象 'sys.filestream_tombstone_676197459' 的 0 页中有 0 行。</Dbcc> 139 <Dbcc ID="99" Error="2593" Severity="10" State="1">对象 'tabelcheckindent' 的 1 页中有 20 行。</Dbcc> 140 <Dbcc ID="100" Error="2593" Severity="10" State="1">对象 'SecretInfo' 的 1 页中有 1 行。</Dbcc> 141 <Dbcc ID="101" Error="2593" Severity="10" State="1">对象 'sys.syscommittab' 的 0 页中有 0 行。</Dbcc> 142 <Dbcc ID="102" Error="2593" Severity="10" State="1">对象 'sys.fulltext_index_docidmap_667149422' 的 1 页中有 10 行。</Dbc 143 c> 144 <Dbcc ID="103" Error="2593" Severity="10" State="1">对象 'TestInsert' 的 17 页中有 10000 行。</Dbcc> 145 <Dbcc ID="104" Error="2593" Severity="10" State="1">对象 'sys.fulltext_index_docidstatus_667149422' 的 0 页中有 0 行。</D 146 bcc> 147 <Dbcc ID="105" Error="2593" Severity="10" State="1">对象 'sys.fulltext_indexeddocid_667149422' 的 1 页中有 10 行。</Dbcc> 148 <Dbcc ID="106" Error="2593" Severity="10" State="1">对象 'sys.fulltext_docidfilter_667149422' 的 0 页中有 0 行。</Dbcc> 149 <Dbcc ID="107" Error="2593" Severity="10" State="1">对象 'sys.fulltext_avdl_667149422' 的 1 页中有 4 行。</Dbcc> 150 <Dbcc ID="108" Error="2593" Severity="10" State="1">对象 'pagediff' 的 1 页中有 8 行。</Dbcc> 151 <Dbcc ID="109" Error="2593" Severity="10" State="1">对象 'sys.filetable_updates_788197858' 的 0 页中有 0 行。</Dbcc> 152 <Dbcc ID="110" Error="2593" Severity="10" State="1">对象 'DP_OilCanOption' 的 1 页中有 20 行。</Dbcc> 153 <Dbcc ID="111" Error="2593" Severity="10" State="1">对象 'DBCCResult' 的 2 页中有 51 行。</Dbcc> 154 <Dbcc ID="112" Error="2593" Severity="10" State="1">对象 'sys.ifts_comp_fragment_667149422_5' 的 1 页中有 3 行。</Dbcc> 155 <Dbcc ID="113" Error="2593" Severity="10" State="1">对象 'LobTestTable' 的 6 页中有 1000 行。</Dbcc> 156 <Dbcc ID="114" Error="2593" Severity="10" State="1">对象 'LobIndexTestTable' 的 101 页中有 19997 行。</Dbcc> 157 <Dbcc ID="115" Error="2593" Severity="10" State="1">对象 'LobCIndexTestTable' 的 56 页中有 10000 行。</Dbcc> 158 <Dbcc ID="116" Error="2593" Severity="10" State="1">对象 'Department4' 的 951 页中有 99999 行。</Dbcc> 159 <Dbcc ID="117" Error="2593" Severity="10" State="1">对象 'Department5' 的 101 页中有 9999 行。</Dbcc> 160 <Dbcc ID="118" Error="2593" Severity="10" State="1">对象 'TESTkeylock' 的 1 页中有 4 行。</Dbcc> 161 <Dbcc ID="119" Error="2593" Severity="10" State="1">对象 'Department6' 的 1548 页中有 100008 行。</Dbcc> 162 <Dbcc ID="120" Error="2593" Severity="10" State="1">对象 'ChangeAttempt' 的 3 页中有 14 行。</Dbcc> 163 <Dbcc ID="121" Error="2593" Severity="10" State="1">对象 'Department2' 的 1071 页中有 99999 行。</Dbcc> 164 <Dbcc ID="122" Error="2593" Severity="10" State="1">对象 'tempPKNCL' 的 0 页中有 0 行。</Dbcc> 165 <Dbcc ID="123" Error="2593" Severity="10" State="1">对象 'ddl_log' 的 5 页中有 73 行。</Dbcc> 166 <Dbcc ID="124" Error="2593" Severity="10" State="1">对象 'SystemPara' 的 12 页中有 3269 行。</Dbcc> 167 <Dbcc ID="125" Error="2593" Severity="10" State="1">对象 'Department8' 的 1 页中有 99 行。</Dbcc> 168 <Dbcc ID="126" Error="2593" Severity="10" State="1">对象 'testIAM' 的 3 页中有 87 行。</Dbcc> 169 <Dbcc ID="127" Error="2593" Severity="10" State="1">对象 'heap22table' 的 3 页中有 3 行。</Dbcc> 170 <Dbcc ID="128" Error="2593" Severity="10" State="1">对象 'Department12' 的 103 页中有 9999 行。</Dbcc> 171 <Dbcc ID="129" Error="2593" Severity="10" State="1">对象 'clusteredtable' 的 3 页中有 3 行。</Dbcc> 172 <Dbcc ID="130" Error="2593" Severity="10" State="1">对象 'CompareNonclusteredScan' 的 8766 页中有 750022 行。</Dbcc> 173 <Dbcc ID="131" Error="2593" Severity="10" State="1">对象 'Department13' 的 7542 页中有 669488 行。</Dbcc> 174 <Dbcc ID="132" Error="2593" Severity="10" State="1">对象 'sys.queue_messages_1977058079' 的 0 页中有 0 行。</Dbcc> 175 <Dbcc ID="133" Error="2593" Severity="10" State="1">对象 'Department11' 的 10 页中有 999 行。</Dbcc> 176 <Dbcc ID="134" Error="2593" Severity="10" State="1">对象 'sys.queue_messages_2009058193' 的 0 页中有 0 行。</Dbcc> 177 <Dbcc ID="135" Error="2593" Severity="10" State="1">对象 'sys.queue_messages_2041058307' 的 0 页中有 0 行。</Dbcc> 178 <Dbcc ID="136" Error="2593" Severity="10" State="1">对象 'Demo_AExportHeader' 的 1 页中有 3 行。</Dbcc> 179 <Dbcc ID="137" Error="8989" Severity="10" State="1">CHECKDB 在数据库 'pratice' 中发现 0 个分配错误和 4 个一致性错误。</Dbcc> 180 <Dbcc ID="138" Error="8957" Severity="-1" State="1">由 JOE\Administrator 执行的 DBCC CHECKDB (pratice) 发现 4 个错误，已修复 0 181 个错误。占用时间: 0 小时 0 分钟 2 秒。内部 数据库快照的拆分点 LSN 为 00000c0e:00004b41:0001，第一个 LSN 为 00000c0e:00004aa8:0001。</Dbcc> 182 <Dbcc ID="139" Error="8958" Severity="10" State="1">对于由 DBCC CHECKDB (pratice)发现的错误，repair_rebuild 是最低的修复级别。</Dbc 183 c> 184 </DbccResults> 185 **Dump thread - spid = 0, EC = 0x143F3DC8 186 ***Stack Dump being sent to D:\Program Files\Microsoft SQL Server\MSSQL11.SQL2012\MSSQL\LOG\SQLDump0004.txt 187 * ******************************************************************************* 188 * 189 * BEGIN STACK DUMP: 190 * 11/28/13 20:29:30 spid 62 191 * 192 * DBCC database corruption 193 * 194 * Input Buffer 68 bytes - 195 * DBCC CHECKDB([pratice]) 196 * 197 * ******************************************************************************* 198 * ------------------------------------------------------------------------------- 199 * Short Stack Dump 200 201 CSession @0x143F2310 202 -------------------- 203 m_sessionId = 62 m_cRef = 14 m_rgcRefType[0] = 1 204 m_rgcRefType[1] = 1 m_rgcRefType[2] = 11 m_rgcRefType[3] = 1 205 m_rgcRefType[4] = 0 m_rgcRefType[5] = 0 m_pmo = 0x143F2028 206 m_pstackBhfPool = 0x14404618 m_dwLoginFlags = 0x83e0 m_fBackground = 0 207 m_eConnResetOption = 0 m_fUserProc = 1 m_fConnReset = 0 208 m_fIsConnReset = 0 m_fInLogin = 0 m_fAuditLoginSent = 1 209 m_fAuditLoginFailedSent = 0 m_fReplRelease = 0 m_fKill = 0 210 m_ulLoginStamp = 2551 m_eclClient = 6 m_protType = 6 211 m_hHttpToken = FFFFFFFF 212 213 m_pV7LoginRec 214 --------------------- 215 00000000: 8e010000 03000a73 00100000 00000006 881c0000 .......s............ 216 217 00000014: 00000000 e0830000 00000000 00000000 5e000300 ................^... 218 219 00000028: 00000000 00000000 64002b00 ba000b00 d0000000 ........d.+......... 220 221 0000003C: d0001c00 08010000 08010700 00127b63 7fc61601 ..............{c.... 222 223 00000050: 78008e01 00008e01 00000000 0000 x............. 224 225 226 227 CPhysicalConnection @0x143F2130 228 ------------------------------- 229 m_pPhyConn->m_pmo = 0x143F2028 m_pPhyConn->m_pNetConn = 0x143F28D0 m_pPhyConn->m_pConnList = 0x143F22F8 230 m_pPhyConn->m_pSess = 0x143F2368 m_pPhyConn->m_fTracked = -1 m_pPhyConn->m_cbPacketsize = 4096 231 m_pPhyConn->m_fMars = 0 m_pPhyConn->m_fKill = 0 232 233 CBatch @0x143F2C38 234 ------------------ 235 m_pSess = 0x143F2310 m_pConn = 0x143F2B98 m_cRef = 3 236 m_rgcRefType[0] = 1 m_rgcRefType[1] = 1 m_rgcRefType[2] = 1 237 m_rgcRefType[3] = 0 m_rgcRefType[4] = 0 m_pTask = 0x03D52CA8 238 239 240 EXCEPT (null) @0x09ED64C0 241 ------------------------- 242 exc_number = 0 exc_severity = 0 exc_func = 0x5FC63DA6 243 244 245 246 Task @0x03D52CA8 247 ---------------- 248 CPU Ticks used (ms) = 444 Task State = 2 249 WAITINFO_INTERNAL: WaitResource = 0x00000000 WAITINFO_INTERNAL: WaitType = 0x0 250 WAITINFO_INTERNAL: WaitSpinlock = 0x00000000 SchedulerId = 0x2 251 ThreadId = 0x12e0 m_state = 0 m_eAbortSev = 0 252 253 254 255 EC @0x143F3DC8 256 -------------- 257 spid = 0 ecid = 0 ec_stat = 0x0 258 ec_stat2 = 0x0 ec_atomic = 0x0 ecType = 0 259 __pSETLS = 0x143F2BD8 __pSEParams = 0x143F2EA8 260 261 SEInternalTLS @0x143F2BD8 262 ------------------------- 263 m_flags = 0 m_TLSstatus = 3 m_owningTask = 0x03D52CA8 264 m_activeHeapDatasetList = 0x143F2BD8 m_activeIndexDatasetList = 0x143F2BE0 265 m_pDbccContext = 0x08D21F18 m_pAllocFileLimit = 0x00000000 m_dekInstanceIndex = 0x-1 266 m_pImbiContext = 0x00000000 267 268 SEParams @0x143F2EA8 269 -------------------- 270 m_lockTimeout = -1 m_isoLevel = 4096 m_logDontReplicate = 0 271 m_neverReplicate = 0 m_XactWorkspace = 0x14418A98 m_execStats = 0x143CC6D0
Memory
MemoryLoad = 93%
Total Physical = 3021 MB
Available Physical = 204 MB
Total Page File = 5520 MB
Available Page File = 2165 MB
Total Virtual = 2047 MB
Available Virtual = 1338 MB
从上面的dump文件可以看出内存不够，当时查看任务管理器可以看出CPU占用率为93%
进而产生一个dump文件内存转储文件
办法：新建一个数据库，再测试
2014-6-7 更新
--清空错误日志 EXEC [sys].[sp_cycle_errorlog] --测试脚本 USE [pratice] GO --建表 CREATE TABLE [SystemPara] ( [RecordNo] [int] IDENTITY(1, 1) NOT NULL , [ParaValue] [varchar](50) NULL , [Name] [varchar](50) NULL , [Description] [varchar](50) NULL ) GO --测试 WHILE 1 = 1 BEGIN INSERT INTO [dbo].[SystemPara] SELECT '22' , '22' , '33' UPDATE [dbo].[SystemPara] SET [ParaValue] = '989' WHERE [RecordNo] = 23 END
DBCC CHECKDB([pratice])
EXEC [sys].[xp_readerrorlog]
LogDate ProcessInfo Text ----------------------- ------------ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 2014-06-07 22:19:07.080 spid56 Microsoft SQL Server 2012 (SP1) - 11.0.3000.0 (X64) Oct 19 2012 13:38:57 Copyright (c) Microsoft Corporation Developer Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) 2014-06-07 22:19:07.080 spid56 (c) Microsoft Corporation. 2014-06-07 22:19:07.080 spid56 All rights reserved. 2014-06-07 22:19:07.080 spid56 Server process ID is 1752. 2014-06-07 22:19:07.080 spid56 System Manufacturer: 'Hasee', System Model: 'QTH6'. 2014-06-07 22:19:07.080 spid56 Authentication mode is MIXED. 2014-06-07 22:19:07.080 spid56 Logging SQL Server messages in file 'D:\Program Files\Microsoft SQL Server\MSSQL11.SQL2012\MSSQL\Log\ERRORLOG'. 2014-06-07 22:19:07.080 spid56 The service account is 'WORKGROUP\JOE$'. This is an informational message; no user action is required. 2014-06-07 22:19:07.080 spid56 The error log has been reinitialized. See the previous log for older entries. 2014-06-07 22:19:15.150 spid57 DBCC TRACEON 3604, server process ID (SPID) 57. This is an informational message only; no user action is required. 2014-06-07 22:19:15.160 spid57 DBCC TRACEOFF 3604, server process ID (SPID) 57. This is an informational message only; no user action is required. 2014-06-07 22:20:19.270 spid58 42 transactions rolled forward in database 'pratice' (12:0). This is an informational message only. No user action is required. 2014-06-07 22:20:19.380 spid58 1 transactions rolled back in database 'pratice' (12:0). This is an informational message only. No user action is required. 2014-06-07 22:20:25.590 spid58 DBCC CHECKDB is performing an exhaustive search of 1 indexes for possible inconsistencies. This is an informational message only. No user action is required. 2014-06-07 22:20:25.620 spid58 Exhaustive search of 'sys.sysschobjs, nc3' (database ID 12) for inconsistencies completed. Processed 1 of 1 total searches. Elapsed time: 25 milliseconds. This is an informational message only. No user action is required. 2014-06-07 22:20:29.500 spid58 DBCC CHECKDB (pratice) executed by JOE\Administrator found 4 errors and repaired 0 errors. Elapsed time: 0 hours 0 minutes 10 seconds. 内部 数据库快照的拆分点 LSN 为 00000c07:00002845:0001，第一个 LSN 为 00000c07:00002814:0001。 2014-06-07 22:20:29.540 spid58 Using 'dbghelp.dll' version '4.0.5' 2014-06-07 22:20:29.570 spid58 **Dump thread - spid = 0, EC = 0x00000002EC772760 2014-06-07 22:20:29.580 spid58 ***Stack Dump being sent to D:\Program Files\Microsoft SQL Server\MSSQL11.SQL2012\MSSQL\LOG\SQLDump0004.txt 2014-06-07 22:20:29.580 spid58 * ******************************************************************************* 2014-06-07 22:20:29.580 spid58 * 2014-06-07 22:20:29.580 spid58 * BEGIN STACK DUMP: 2014-06-07 22:20:29.580 spid58 * 06/07/14 22:20:29 spid 58 2014-06-07 22:20:29.580 spid58 * 2014-06-07 22:20:29.580 spid58 * DBCC database corruption 2014-06-07 22:20:29.580 spid58 * 2014-06-07 22:20:29.580 spid58 * Input Buffer 68 bytes - 2014-06-07 22:20:29.580 spid58 * DBCC CHECKDB([pratice]) 2014-06-07 22:20:29.580 spid58 * 2014-06-07 22:20:29.580 spid58 * ******************************************************************************* 2014-06-07 22:20:29.580 spid58 * ------------------------------------------------------------------------------- 2014-06-07 22:20:29.580 spid58 * Short Stack Dump 2014-06-07 22:20:29.650 spid58 Stack Signature for the dump is 0x00000000000002E5 2014-06-07 22:20:30.290 spid58 External dump process return code 0x20000001. External dump process returned no errors.
产生的转储文件下载
https://files.cnblogs.com/lyhabc/%E4%BA%A7%E7%94%9F%E7%9A%84%E8%BD%AC%E5%82%A8%E6%96%87%E4%BB%B6.rar
http://www.kuaipan.cn/file/id_4401224786935910.htm
公有符号表下载
http://www.kuaipan.cn/file/id_4401224786935908.htm
http://www.kuaipan.cn/file/id_4401224786935909.htm
http://www.kuaipan.cn/file/id_4401224786935907.htm
Windbg下载 版本 6.7
http://www.kuaipan.cn/file/id_4401224786935906.htm
1、先下载符号表，然后安装
2、
3、
4、
5、
6、
7、
