Limitation on TRC file? - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Limitation on TRC file?

Author

Topic

dewacorp.alliances

452 Posts

Posted - 2006-10-12 : 00:10:27

Does any one know whether that TRC file (trace file) has a limitation on the size of rows?

I run a server trace from http://vyaskn.tripod.com/server_side_tracing_in_sql_server.htm

Run on SQL Job on specific job for

quote:
DECLARE @TraceID int

EXEC usp_CreateTrace
'C:\_SYSTEAM\SQL_Trace\Start Trace Job',
@OutputTraceID = @TraceID OUT

EXEC usp_AddEvent
@TraceID,
'Database File Auto Grow, Log File Auto Grow, ErrorLog, EventLog, Exception, Lock:Deadlock, Lock:Deadlock Chain, RPC:Completed, RPC:Starting, SP:CacheHit, SP:CacheInsert, SP:CacheMiss, SP:CacheRemove, SP:Completed, SP:ExecContextHit, SP:Recompile, SP:Starting, SP:StmtCompleted, SQL:BatchCompleted, SQL:BatchStarting, SQL:StmtCompleted',
'SQLSecurityLoginname, ClientHostname, ApplicationName, CPU, SPID, DatabaseName, Duration, EndTime, Error, EventSubClass, HostName, IntegerData, LoginName, NTUserName, ObjectName, StartTime, TextData'

EXEC usp_StartTrace @TraceID
GO

Also, run a separe job for stopping:

quote:
EXEC usp_StopTrace 1
GO

EXEC usp_ClearTrace 1
GO

But what I found is actually generating multiple trace files every 10 minutes or so. It's kind a pain cause need to save this trc file into table one by one and join into one.

My question is: Is this a limitation on trace file? If it does ... is there any way to join this multiple trace file into one efficiently.

Thanks

sponguru_dba
Yak Posting Veteran

93 Posts

Posted - 2006-10-12 : 05:19:35

Profiler Can Only Capture 1 GB File Size

SreenivasaRao
"Every Thought is Possible"