In SQL Server, how to move/import a multiple .trc files to a trace table

Posted by frankadelic on Stack Overflow See other posts from Stack Overflow or by frankadelic
Published on 2010-05-06T21:39:17Z Indexed on 2010/05/06 21:48 UTC
Read the original article Hit count: 230

Filed under:

sqlprofiler

|

sql-server-profiler

|

sql-server

|

trace

|

sql-server-2005

I have a set of rollover .trc files recorded with Sql Profiler.

mytrace.trc

mytrace_1.trc

mytrace_2.trc

mytrace_3.trc

I can import the first one using this command:

use [my-database]
SELECT * INTO trace_folder
FROM::fn_trace_gettable('C:\mytrace.trc', 4)

However, this only appears to load the first file, not all four.

© Stack Overflow or respective owner

Related posts about sqlprofiler

Is a SqlProfiler Scan Started bad?

as seen on Stack Overflow - Search for 'Stack Overflow'
If in SqlProfiler you can see that to execute a query a Scan is Started, does this mean a full table scan or can it just be a lookup? If it can be both, how can you tell which one of the two it is? >>> More
Is this a bug in Profiler or Entity Framework?

as seen on Server Fault - Search for 'Server Fault'
Using Entity Framework 4 with stored procedures and SQL Server 2008 SP1... When running SQL Server Profiler (TSQL_SPs template), the lines that show my stored procedure call and its statements say that they executed in DatabaseID = 1 (Master) but it is actually happening in my application database… >>> More
TempDB is Full Issue for SQL Server 2000

as seen on Server Fault - Search for 'Server Fault'
Even though the log file shows that there is over 1 GB of free space, we start receiving an error message every 3 or 4 days saying that the TempDB file is full. I know cursors impact the TempDB file, but is there anything else I should be looking at to see why this keeps happening? I've tried running… >>> More
Unit of Measurement for Duration Column in Sql Profiler

as seen on Stack Overflow - Search for 'Stack Overflow'
What is the Unit of Duration column in SQL Profiler? i thought it is milliseconds but in following profiler row i found it contradicting with start and end time spid=163 duration=11310646 starttime=2010-04-06 17:45:24.480 endtime=2010-04-06 17:45:35.790 reads=152 writes=2 cpu=16 eventclass=12 textdata=… >>> More
SQL Profiler: Read/Write units

as seen on Stack Overflow - Search for 'Stack Overflow'
i've picked a query out of SQL Server Profiler that says it took 1,497 reads: EventClass: SQL:BatchCompleted TextData: SELECT Transactions.... CPU: 406 Reads: 1497 Writes: 0 Duration: 406 So i've taken this query into Query Analyzer, so i may try to reduce… >>> More

Related posts about sql-server-profiler

Determining Object Access Using SQL Server Profiler

as seen on Internet.com - Search for 'Internet.com'
Deanna Dicken examines an SQL Server Profiler event to determine object access...who is using the object, when, and how. This gives the SQL developer or database administrator much needed information for impact analysis prior to a change or the decommissioning of a SQL Server object. >>> More
Capture query results using SQL Server Profiler

as seen on Stack Overflow - Search for 'Stack Overflow'
It's possible to capture a query's result using SQL Server Profiler? >>> More
SQL Server Profiler and RDP session

as seen on Server Fault - Search for 'Server Fault'
Hi, does SQL Server Profiler continue to profile also if I close the program and log out from the RDP session? Thank you all for help >>> More
Is there a PostgreSQL equivalent of SQL Server profiler

as seen on Stack Overflow - Search for 'Stack Overflow'
I need to see the queries submitted to a PostgreSQL server. Normally I would use SQL Server profiler to perform this action in SQL Server land, but I'm yet to find how to do this in PostgreSQL. There appears to be quite a few pay-for tools, I am hoping there is a open source variant. >>> More
SQL Server Profiler Implementation Using C#/VB.net

as seen on Stack Overflow - Search for 'Stack Overflow'
I to implement sql Server Profile in C#/VB.net application, Can any one has good example of it, I have search on google but didn't find good working example, I don't have Sql server Profiler tool on my system ans also don't have Sql Server (it is on difference system). how do I can create profiler… >>> More