May 21, 2009 at 12:48 pm
What are the effects of this. Would there be any kind of timeout etc. on the application side due to this?
How do we know which process would be firing this DBCC traceon(3604)
apart from the spid.
M&M
May 21, 2009 at 12:56 pm
Here is a thread where HP Openview was executing the process. Are you using any monitoring software like this?
http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server/15481/DBCC-TRACEON-3604
May 21, 2009 at 1:29 pm
Usage: 3604 is to redirect the output onto the screen/file. default is to
direct the output of the dbcc's that come after 3604 is errorlog. and is
session based.
impact: depending on what dbcc your are planning to run will impact the
system.
if you use dbccdb, impact is minimal.
[font="Comic Sans MS"]+++BLADE+++[/font]:cool:
May 21, 2009 at 2:45 pm
Any idea, how to get the command which this dbcc traceon(3604) is running.
M&M
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply