Hello everyone,

I notice a bunch of log_nnn.trc files on my C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\LOG folder. The file size keeps increasing. However,
I cannot find any instance of SQL Server Profiler is running. And nobody
ran profiler at all. I notice the same on other SQL Servers.

Anyone know how these traces initiated? How to disable them?

Thank you in advance!

Donald

If this is SQL Server 2005, there is a default "black box" trace that runs
in the background by default. Here are some blog posts about it (including
how to turn it off, and some of the consequences of doing so):

http://blogs.technet.com/vipulshah/a...rver-2005.aspx

http://www.sqljunkies.com/WebLog/mz1.../09/20962.aspx

http://sqlblog.com/blogs/tibor_karas...ult-trace.aspx





"Donald" <donaldi@gmail.com> wrote in message
news:OJjrJYCkIHA.4356@TK2MSFTNGP02.phx.gbl...
> Hello everyone,
>
> I notice a bunch of log_nnn.trc files on my C:\Program Files\Microsoft SQL
> Server\MSSQL.1\MSSQL\LOG folder. The file size keeps increasing.
> However, I cannot find any instance of SQL Server Profiler is running.
> And nobody ran profiler at all. I notice the same on other SQL Servers.
>
> Anyone know how these traces initiated? How to disable them?
>
> Thank you in advance!
>
> Donald
>

Just to add to Aaron 's answer, this default trace is a lightweight trace
and, to avoid name confusion, it is not the blackbox trace.

The blackbox trace is heavier than the default trace and needs to be enabled
manually by using @options set to 8 (TRACE_PRODUCE_BLACKBOX) on
sp_trace_create.

Hope this s,

Ben Nevarez




"Aaron Bertrand [SQL Server MVP]" wrote:

> If this is SQL Server 2005, there is a default "black box" trace that runs
> in the background by default. Here are some blog posts about it (including
> how to turn it off, and some of the consequences of doing so):
>
> http://blogs.technet.com/vipulshah/a...rver-2005.aspx
>
> http://www.sqljunkies.com/WebLog/mz1.../09/20962.aspx
>
> http://sqlblog.com/blogs/tibor_karas...ult-trace.aspx
>
>
>
>
>
> "Donald" <donaldi@gmail.com> wrote in message
> news:OJjrJYCkIHA.4356@TK2MSFTNGP02.phx.gbl...
> > Hello everyone,
> >
> > I notice a bunch of log_nnn.trc files on my C:\Program Files\Microsoft SQL
> > Server\MSSQL.1\MSSQL\LOG folder. The file size keeps increasing.
> > However, I cannot find any instance of SQL Server Profiler is running.
> > And nobody ran profiler at all. I notice the same on other SQL Servers.
> >
> > Anyone know how these traces initiated? How to disable them?
> >
> > Thank you in advance!
> >
> > Donald
> >
>
>
>

> Just to add to Aaron 's answer, this default trace is a lightweight trace
> and, to avoid name confusion, it is not the blackbox trace.

Yes, sorry about the confusion, bad choice of words on my part.

Thank you all.
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message
news:ujsEmSDkIHA.4536@TK2MSFTNGP06.phx.gbl...
>> Just to add to Aaron 's answer, this default trace is a lightweight trace
>> and, to avoid name confusion, it is not the blackbox trace.
>
> Yes, sorry about the confusion, bad choice of words on my part.
>
>

Also, to add to the other answers, keep in mind that Profiler is just one
way to run a trace. Not only do the default system trace and blackbox traces
NOT need profiler, you can create your own server side traces that do not
need Profiler. Profiler is just a GUI, the real tracing is done on the SQL
Server itself. For a production server, it is recommended that you don't
trace using Profiler, because the overhead is too high. You should always
use server-side traces for production systems.

--
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://DVD.kalendelaney.com


"Ben Nevarez" <bnevarez@no.spam.please.sunamerica.com> wrote in message
news:CB370269-08C2-4471-AD39-1BE7E305C00D@microsoft.com...
>
> Just to add to Aaron 's answer, this default trace is a lightweight trace
> and, to avoid name confusion, it is not the blackbox trace.
>
> The blackbox trace is heavier than the default trace and needs to be
> enabled
> manually by using @options set to 8 (TRACE_PRODUCE_BLACKBOX) on
> sp_trace_create.
>
> Hope this s,
>
> Ben Nevarez
>
>
>
>
> "Aaron Bertrand [SQL Server MVP]" wrote:
>
>> If this is SQL Server 2005, there is a default "black box" trace that
>> runs
>> in the background by default. Here are some blog posts about it
>> (including
>> how to turn it off, and some of the consequences of doing so):
>>
>> http://blogs.technet.com/vipulshah/a...rver-2005.aspx
>>
>> http://www.sqljunkies.com/WebLog/mz1.../09/20962.aspx
>>
>> http://sqlblog.com/blogs/tibor_karas...ult-trace.aspx
>>
>>
>>
>>
>>
>> "Donald" <donaldi@gmail.com> wrote in message
>> news:OJjrJYCkIHA.4356@TK2MSFTNGP02.phx.gbl...
>> > Hello everyone,
>> >
>> > I notice a bunch of log_nnn.trc files on my C:\Program Files\Microsoft
>> > SQL
>> > Server\MSSQL.1\MSSQL\LOG folder. The file size keeps increasing.
>> > However, I cannot find any instance of SQL Server Profiler is running.
>> > And nobody ran profiler at all. I notice the same on other SQL
>> > Servers.
>> >
>> > Anyone know how these traces initiated? How to disable them?
>> >
>> > Thank you in advance!
>> >
>> > Donald
>> >
>>
>>
>>