Geeks With Blogs



Locations of visitors to this page


marocanu2001 technicle blog July 2008 Entries
Concatenate Sql profiler traces in a table
Nowdays I am in charge of database optimization on our project. First I needed to see what the problem was, second resolve them. So I set on a profiler in Sql Profiler. Being overmotivated I added lots of events to trace which resulted in a table with very many columns. I also did another evil thing, I set the trace to roll at 20M. This resulted in 98 trace files . I tried to find some way to import them in SqlServer, but the SqlProfiler interface only allowed 1 trace file at one time to be saved ......

Posted On Thursday, July 31, 2008 4:10 AM

Copyright © marocanu2001 | Powered by: