|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
3604 question
On 2008, I am finding these in my Sql Logs (about 6000 of them) done in
about 30 seconds. This seems to happen 6 or 7 times a day. 05/22/2009 09:05:03,spid76,Unknown,DBCC TRACEOFF 3604<c/> server process ID (SPID) 76. This is an informational message only; no user action is required. 05/22/2009 09:05:03,spid76,Unknown,DBCC TRACEON 3604<c/> server process ID (SPID) 76. This is an informational message only; no user action is required. What would cause this? Thanks, Tom This is used to change the way subsequent DBCC commands direct their output.
What is doing it? Who knows. Some kind of monitoring software maybe. You'll have to run a trace I suppose. A On 5/22/09 12:47 PM, in article eW08G0v2JHA.***@TK2MSFTNGP06.phx.gbl, Show quoteHide quote "tshad" <t***@pdsa.com> wrote: > On 2008, I am finding these in my Sql Logs (about 6000 of them) done in > about 30 seconds. This seems to happen 6 or 7 times a day. > > 05/22/2009 09:05:03,spid76,Unknown,DBCC TRACEOFF 3604<c/> server process ID > (SPID) 76. This is an informational message only; no user action is > required. > 05/22/2009 09:05:03,spid76,Unknown,DBCC TRACEON 3604<c/> server process ID > (SPID) 76. This is an informational message only; no user action is > required. > > What would cause this? > > Thanks, > > Tom > > "Aaron Bertrand [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message Thanks,news:C63C67C1.19FD1%ten.xoc@dnartreb.noraa... > This is used to change the way subsequent DBCC commands direct their > output. > What is doing it? Who knows. Some kind of monitoring software maybe. > You'll have to run a trace I suppose. OK, Tom Show quoteHide quote > > A > > > > On 5/22/09 12:47 PM, in article eW08G0v2JHA.***@TK2MSFTNGP06.phx.gbl, > "tshad" <t***@pdsa.com> wrote: > >> On 2008, I am finding these in my Sql Logs (about 6000 of them) done in >> about 30 seconds. This seems to happen 6 or 7 times a day. >> >> 05/22/2009 09:05:03,spid76,Unknown,DBCC TRACEOFF 3604<c/> server process >> ID >> (SPID) 76. This is an informational message only; no user action is >> required. >> 05/22/2009 09:05:03,spid76,Unknown,DBCC TRACEON 3604<c/> server process >> ID >> (SPID) 76. This is an informational message only; no user action is >> required. >> >> What would cause this? >> >> Thanks, >> >> Tom >> >> >  
Other interesting topics
Collation advice going from 2000 to 2008
Compression Tool Copying an SQL database, to a memory stick, to transfer to a lapto sys.dm_exec_procedure_stats simple SQL event question SQL 2005 processe stuck in 'Starting' state after reboot sql server traffic shut down internet mdf size Count dates Composite Index Question |
|||||||||||||||||||||||
