If the ‘ value in use’ column is 1 it means that the default trace is enabled. The default trace is an instance level configuration and its settings can be found by using: SELECT * FROM sys.configurations WHERE configuration_id = 1568. On my server the row with id 1 shows the default trace and the column ‘path’ will show the current file that the trace is being written to (…\MSSQL\LOG). The command: select * from sys.traces will return a list of all traces that are created on the SQL server. Users can also create custom traces on SQL server. 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.
0 kommentar(er)
