Main Menu

SSTS Blog

Some news and tidbits that we share

SQL Server function to read SQL Profiler trace files (fn_trace_gettable)

by SSTS on Aug 07 in Blog 0 Comments

SQL Server Profiler creates files on the OS that can later be read in for analysis.

The following parses a trace file and inserts the data into a table.

SELECT * INTO trace_folder
FROM::fn_trace_gettable('C:\mytrace.trc', 4)

Tags: Untagged

Author

About the author

SSTS

Server Side Technology Solutions is a consulting firm that specializes in database design, development and support.

http://www.serverside-ts.com

Comments

Please login first in order for you to submit comments

Lower Your Costs

Lower the costs of your DBA while ensuring that you have the quality that your company needs to remain successful and optimized!

24 x 7 Monitoring

For things that are essential to your success, do not let potential hazards stand in the way. With our 24x7 Monitoring Alert System, we can make sure your systems are always running as efficiently as they should be, even if you're sleeping.

Get A Solution

We have extensive experience in the field which allows us to approach every situation head on and find the best solution quickly. Our solutions are custom tailored to your needs. We will work with you in coming up with a services agreement that fits your needs.

Solutions...