How to load profiler data into SQL Server ?

• SQL Guy 1

  SSCoach

  Points: 15981

  More actions

  December 17, 2010 at 3:21 pm

  #244493

  This may sound like a trivial question, but we received .trc files from production and trying to load it into SQL Server. I opened one file (there are many of them) in Profiler, tried File /Export, /Import, but none of them seems to load the data in SQL Server database. Am I doing something rwong ?

  Thanks

• Shawn Melton

  SSC-Insane

  Points: 24685

  More actions

  December 17, 2010 at 3:40 pm

  #1264283

  This is what you need:

  fn_trace_gettable

  EDIT: You can indicate how many rollover files you want to import. You can also specify only columns of interest to speed up the import.

  Shawn Melton
  Twitter: @wsmelton
  Blog: wsmelton.github.com
  Github: wsmelton