dbTalk Databases Forums  

Trace Log for SQL Profiler

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools


Discuss Trace Log for SQL Profiler in the microsoft.public.sqlserver.tools forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Joe
 
Posts: n/a

Default 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.





Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.