Microsoft KB Archive/272446

{|
 * width="100%"|

INF: Profiler Restricts the Maximum Size Per Trace File to 1 GB

 * }

Q272446

-

The information in this article applies to:


 * Microsoft SQL Server 2000 (all editions)

-

SUMMARY
Microsoft SQL Server 2000 Profiler lets you specify a maximum size per trace file. When you use the GUI Profiler, the maximum size per trace file that you can specify is 1 gigabyte (GB). There is no way to change this setting because it is by design.

MORE INFORMATION
You can work around this limitation by tracing with system stored procedures. The sp_trace_create stored procedure has a parameter @maxfilesize with a type of BIGINT. The numerical maximum for the BIGINT data type is very high and is of the order of 2 to the power of 64.

Additional query words:

Keywords : kbDSupport kbSQLServ2000

Issue type : kbinfo

Technology : kbSQLServSearch kbAudDeveloper kbSQLServ2000Search kbSQLServ2000