Strange Profile tracefile 2

[johnny99]

I have a SQL server that is hosting our Altiris system.
On that server I found 5 .trc files that was all new.
I deleted them some days ago and today I again had 5 .trc files.

Since I can't see the profiler running on the server I hope someone can point me in the right direction to find our how/why I get these files, abd how to turn the trace off.

The trace is regarding the TempDB.

Thanks in advance

Johnny

 

[ptheriault]

Is this sql server 2005? By default sql 2k5 runs trace files.

- Paul

- If at first you don't succeed, find out if the loser gets anything.

 

[johnny99]

It is 2005. Sorry. Forgot that.

Doesn't that default trace slowdown the server?

And where can I kill that trace?

/johnny

 

[ptheriault]

I'm not sure how to kill it. I haven't seen any performance problems related to the trace files. Also, They are the first thing Microsoft asks for if you have to contact them for support.

- Paul

- If at first you don't succeed, find out if the loser gets anything.

 

[mrdenny]

You can't stop them from running.

Running a trace it self doesn't add any real load to the databases.

Running SQL Profiler on the otherhand does add load, as SQL Profiler isn't the most efficient piece of software which Microsoft has ever released. (Granted it's not as bad as say Windows ME, but it's up there.)

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com