SplitTrc.exe - Chunk SQL Trace Files

version: 1.0.0.1
last updated: 13 April 2005
platform: MSDE 2000 and SQL Server 2000 running Windows NT 4.0 and higher

Description:

SplitTrc splits a large SQL Server 2000 trace file in to multiple smaller trace files. The resulting file will almost never of the exact same size as specified by the -s max file size parameter; since trace events are of a variable length, the tools simple copies events in to the target file until the max file size is reached (>= max file size).

Usage:

SplitTrc.exe version 1.0x1

SplitTrc usage:

-i input file
-o output file
-s max file size, default 1073741823 bytes

-v version information
-? command line usage

Sample output:

Dump the content of a SQL Server 2000 trace file to the console.

Input file: trace.trc is 75,535 bytes

SplitTrc -i c:\temp\trace.trc -o c:\temp\chunks -s 8192

Resulting files:

chunks_1.trc     8,299 bytes
chunks_2.trc    10,105 bytes
chunks_3.trc    11,238 bytes
chunks_4.trc     9,993 bytes
chunks_5.trc     8,480 bytes
chunks_6.trc    11,873 bytes
chunks_7.trc     8,204 bytes
chunks_8.trc     1,525 bytes

Installation:

Simply copy "SplitTrc.exe" onto your machine; preferred location is the "C:\Program Files\Microsoft SQL Server\80\Tools\Binn" directory, but it can be installed in any directory, as long as the "C:\Program Files\Microsoft SQL Server\80\Tools\Binn" direct is on the PATH.

Download: SplitTrc.zip

Requirements:

The SQL Server 2000 client tools need to be installed.
The "C:\Program Files\Microsoft SQL Server\80\Tools\Binn" needs to be on the PATH (default when SQL Server 2000 Client Tools are installed)

Planned functionality enhancements:

None
Other suggestions, ideas, please send email to ideas