I am trying to diagnose an issue with a production SQL Server instance. I have asked the DBA to provide a trace and have been given a set of SQL trace files (1185 files to be precise).
When I open the first file, SQL Profiler detects presence of additional trace files and prompts me to load the one by one - this approach does not scale to 1185 files.
Ultimately, what I want is to import all that trace data into SQL server so I can query it.
Can you recommend an approach or tool that would allow me to do this?