I want to create a trace for the profiler for index tuning. What is the best template and/or event classes to capture in my trace? I want to use a workload file to tune indexes.
I usually grab the sp completed, and stmt ending events, check the duration and do a count of the instances and go from there. I think the standard template that pops up as hese, just remove the session stuff.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply