Trace Log for SQL Profiler -
07-29-2008
, 02:48 PM
Good Afternoon,
I have run the SQL Server Profiler to assist me in optimizing the perfomance
of one of my databases. The Profilier was started and ran during our peak
time of our business day. When I reviewed the location the trace log was
saved, there were 160 individual trace files. What I am concerned about is
when I use the trace file in the Database Tuning Advisor, will it know to
analize all the files and then make recommendations, or will it analize one
trace file at a time? If the answer in 'no', is it possible for me to one
trace file that collects data based on our peek time of the day, 4 hours?
Thank you for your time and I am looking forward to the repsonses. |