The filename is "audit trace". That makes me think that it is auditing everything that could potentially be important against your SQL Server. Some companies need this for SOX compliance. If you know this does not apply to your SQL Server environment, you can turn it off by issuing T-SQL commands.
To view all of the traces on your system, run this:
SELECT * FROM sys.traces
WHERE path LIKE N'%audittrace_%'
Find the trace that is called audittrace.trc:
--Stop the trace
EXEC sp_trace_setstatus @traceid =, @status = 0
--Delete the trace definition from the server
EXEC sp_trace_setstatus @traceid =, @status = 2
Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/
Sumber: http://social.msdn.microsoft.com/forums/en-US/sqltools/thread/2b5bac33-03a6-46c7-a83e-c36e09ae8a33/
To view all of the traces on your system, run this:
SELECT * FROM sys.traces
WHERE path LIKE N'%audittrace_%'
Find the trace that is called audittrace.trc:
--Stop the trace
EXEC sp_trace_setstatus @traceid =
--Delete the trace definition from the server
EXEC sp_trace_setstatus @traceid =
Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/
Sumber: http://social.msdn.microsoft.com/forums/en-US/sqltools/thread/2b5bac33-03a6-46c7-a83e-c36e09ae8a33/
Comments