How to set a maximum file size for a trace file (SQL Profiler)

How to set a maximum file size for a trace file (SQL Profiler)

To set a maximum file size for a trace file

1. On the File menu, point to New, and then click Trace.
   
   
2. In the Connect to SQL Server dialog box, select the server to which you want to connect and a connection method.
   
   
3. In the Trace Properties dialog box, do the following:
   • In the Trace name box, type a name for the trace.
     
     
   • In the Template name list, select a trace template.
4. Select Save to file, and then specify a file in which to store the trace information.
   
   
5. In the Set maximum file size (MB) check box, specify a maximum file size for the trace. File rollover is enabled by default.

   When the file size reaches this maximum, the trace events are no longer recorded.

See Also

Monitoring with SQL Profiler