The default traces rolls over through 5 files and is lightweight in terms of resource usage and hence need not be disabled. This trace logs DDL commands that are done on that instance of SQL server and is know as the default trace.
Here are my findings:Īfter SQL server (2005 and above) is installed, a trace is automatically created. Over time, as I administered more and more servers, I couldn’t help investigating into these trc files. If you were like me, you may not have bothered about them, initially. Have you ever looked into the SQL log directory (usually C:\Program Files\Microsoft SQL Server\MSSQL\LOG) and found a bunch of log_.trc files in them.
