Microsoft KB Archive/300494

= FIX: Profiler Can Only Capture 1 GB File Size for SQL Server Activities =

Article ID: 300494

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q300494



BUG #: 235312 (SHILOH_BUGS)



SYMPTOMS
SQL Server does not set any limitation for the size of a captured trace. However, the GUI of the SQL Profiler does &quot;not&quot; allow you to set the maximum size of a captured trace to be greater than 1 GB. However, 1 GB may not be large enough for some situations.



RESOLUTION
To resolve this problem, obtain the latest service pack for SQL Server 2000. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack



WORKAROUND
To work around this behavior you can either:
 * Use the rollover facility for pure debugging or monitoring. When a trace file grows and becomes larger than 1,000 MB, the trace creates another file. However, for performing a replay you can only replay that first 1,000 MB file.

-or-


 * Start a trace through SQL Profiler, and then use scripting options to generate a SQL Server script and start writing to the file.

You can also work around the 1 GB limit by using these steps:
 * 1) Create a new default trace.
 * 2) Save the trace to a file.
 * 3) Clear Allow File rollover.
 * 4) Enter 9999 in the File Size text box.
 * 5) Click the Events tab.
 * 6) Click Run. View the properties of the running trace and note that the file size is 9999.



STATUS
Microsoft has confirmed that this is a problem in SQL Server 2000. This problem was first corrected in SQL Server 2000 Service Pack 1.



MORE INFORMATION
The fix in SQL Server 2000 Service Pack 1 (SP1) for SQL Profiler is to allow for a 4 GB file size. A server side file stops growing the trace file at 3.99 GB. The client side file stops growing the file at 4.00 GB.

Keywords: kbbug kbfix kbsqlserv2000sp1fix KB300494

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.