SQL Server的error log里有大量的"DBCC TRACEON 3604, server process ID (SPID) 91"记录

extend 2009-08-20 04:02:58
如题，SQL Server2000的ERRORLOG中有大量的这类事件（因为不会贴图，直接Copy/Paste）：
2009-08-20 04:04:05.62 spid91 DBCC TRACEON 3604, server process ID (SPID) 91.
2009-08-20 04:05:07.48 spid92 DBCC TRACEON 3604, server process ID (SPID) 92.
2009-08-20 04:06:08.25 spid91 DBCC TRACEON 3604, server process ID (SPID) 91.
2009-08-20 04:07:08.12 spid91 DBCC TRACEON 3604, server process ID (SPID) 91.
2009-08-20 04:08:05.25 spid91 DBCC TRACEON 3604, server process ID (SPID) 91.
2009-08-20 04:09:05.73 spid91 DBCC TRACEON 3604, server process ID (SPID) 91.
2009-08-20 04:10:08.15 spid92 DBCC TRACEON 3604, server process ID (SPID) 92.
2009-08-20 04:11:06.23 spid91 DBCC TRACEON 3604, server process ID (SPID) 91.
2009-08-20 04:12:06.70 spid91 DBCC TRACEON 3604, server process ID (SPID) 91.
2009-08-20 04:13:07.04 spid91 DBCC TRACEON 3604, server process ID (SPID) 91.
2009-08-20 04:14:07.59 spid91 DBCC TRACEON 3604, server process ID (SPID) 91.
2009-08-20 04:15:08.00 spid93 DBCC TRACEON 3604, server process ID (SPID) 93.
2009-08-20 04:16:06.86 spid91 DBCC TRACEON 3604, server process ID (SPID) 91.
2009-08-20 04:17:07.26 spid91 DBCC TRACEON 3604, server process ID (SPID) 91.
2009-08-20 04:18:08.22 spid91 DBCC TRACEON 3604, server process ID (SPID) 91.
2009-08-20 04:19:05.06 spid91 DBCC TRACEON 3604, server process ID (SPID) 91.
2009-08-20 04:20:10.31 spid92 DBCC TRACEON 3604, server process ID (SPID) 92.
2009-08-20 04:21:08.01 spid91 DBCC TRACEON 3604, server process ID (SPID) 91.
2009-08-20 04:22:07.87 spid91 DBCC TRACEON 3604, server process ID (SPID) 91.
2009-08-20 04:23:07.92 spid91 DBCC TRACEON 3604, server process ID (SPID) 91.
2009-08-20 04:24:08.28 spid91 DBCC TRACEON 3604, server process ID (SPID) 91.
2009-08-20 04:25:10.76 spid92 DBCC TRACEON 3604, server process ID (SPID) 92.
2009-08-20 04:26:07.39 spid91 DBCC TRACEON 3604, server process ID (SPID) 91.
2009-08-20 04:27:07.89 spid91 DBCC TRACEON 3604, server process ID (SPID) 91.
2009-08-20 04:28:08.11 spid91 DBCC TRACEON 3604, server process ID (SPID) 91.
2009-08-20 04:29:08.48 spid91 DBCC TRACEON 3604, server process ID (SPID) 91.
2009-08-20 04:30:09.00 spid93 DBCC TRACEON 3604, server process ID (SPID) 93.
2009-08-20 04:31:07.73 spid91 DBCC TRACEON 3604, server process ID (SPID) 91.
2009-08-20 04:32:08.01 spid91 DBCC TRACEON 3604, server process ID (SPID) 91.
2009-08-20 04:33:05.64 spid91 DBCC TRACEON 3604, server process ID (SPID) 91.
2009-08-20 15:28:34.98 spid89 DBCC TRACEON 3604, server process ID (SPID) 89.
2009-08-20 15:28:58.12 spid89 DBCC TRACEON 3604, server process ID (SPID) 89.
2009-08-20 15:30:14.57 spid89 DBCC TRACEON 3604, server process ID (SPID) 89.
2009-08-20 15:31:33.68 spid89 DBCC TRACEON 3604, server process ID (SPID) 89.
2009-08-20 15:34:06.37 spid98 DBCC TRACEON 3604, server process ID (SPID) 98.
2009-08-20 15:35:07.34 spid99 DBCC TRACEON 3604, server process ID (SPID) 99.
2009-08-20 15:36:08.54 spid97 DBCC TRACEON 3604, server process ID (SPID) 97.
2009-08-20 15:37:04.37 spid93 DBCC TRACEON 3604, server process ID (SPID) 93.
2009-08-20 15:38:05.82 spid92 DBCC TRACEON 3604, server process ID (SPID) 92.
2009-08-20 15:39:05.81 spid92 DBCC TRACEON 3604, server process ID (SPID) 92.
2009-08-20 15:40:05.48 spid93 DBCC TRACEON 3604, server process ID (SPID) 93.

这是怎么回事？
...全文
1179 4 打赏 收藏 转发到动态 举报
写回复
用AI写文章
4 条回复
切换为时间正序
请发表友善的回复…
发表回复
SQL77 2009-08-20
  • 打赏
  • 举报
 回复
按一楼的,关闭就好了
SQL77 2009-08-20
  • 打赏
  • 举报
 回复
DBCC TRACEON
打开（启用）指定的跟踪标记
你这是启用了跟踪
--小F-- 2009-08-20
  • 打赏
  • 举报
 回复
估计有三个原因

一是LOG 空间满了，尤其是TRANSACTION LOG
二是有异常入侵现象
三是MASTER库的LOG空间和TEMP空间不够,增加TEMP空间即可
csdyyr 2009-08-20
  • 打赏
  • 举报
 回复 
--跟踪打开了，要关闭

DBCC TRACEOFF 3604
微软内部资料-SQL性能优化3
An intent lock indicates that SQL Server wants to acquire a shared (S) lock or exclusive (X) lock on some of the resources lower down in the hierarchy. For example, a shared intent lock placed at the ...
SQL SERVER DBCC命令解释
SQL SERVER DBCC命令解释--1 dbcc trraceon DBCC TRACEOFF--对于数据库死锁，通常可以通过TRACE FLAG 1204、1205、1206，检查ERRORLOG里面的输出，和分析SQLTRACE的执行上下文判断死锁问题的来由。--TRACEON函数的第...
Sybase性能调试 - dbcc trace
Showplan显示SQL最终的执行过程，用了什么index，什么合并算法等。 dbcc traceon(302) 可以帮我们找出为什么optimizer。dbcc traceon的输出非常详细，比showplan详细的多。...dbcc traceon(3604, 302) >>>...
SQLSERVER errorlog讲解
很多时候诊断SQLSERVER...里抓出来的，跟大家的机器环境会有所不同，但是SQLSERVER启动部分的日志大家都是一样的 特别的说一下：2013-02-12 17:53:29.29 spid29s 这些spid指的是SQLSERVER内部的进程，因为SQLSE...
SQL SERVER DBCC命令解释（转）
DBCC（database consistenecy checker，简称dbcc） 是一个实用命令集，用来检查数据库的逻辑一致性及物理一致性。 数据库控制台命令语句可分为以下类别： 维护： 对数据库、索引或文件组进行维护的...
疑难问题

22,298

社区成员

121,733

社区内容

发帖
与我相关
我的任务
社区描述
MS-SQL Server 疑难问题
社区管理员
  • 疑难问题社区
  • 尘觉
加入社区
  • 近7日
  • 近30日
  • 至今

加载中

查看更多榜单
社区公告
暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章