Dropping the log onto SQL Profiler
-
When I run SQL Profiler (SQL 2000) I typically dump my trace results to a SQL table - then query that table to review the results.
I recently heard a SQL DBA mention that he drops the SQL trace log into Profiler to view it.
Can you please explain, generically, how this is done?
Is the trace dumped to a TXT file then that TXT file is viewed via Profiler? What is meant by "dropping the trace into Profiler"?
Would appreciate a brief overview. Thanks in advance.
BT -
Save trace results as .trc File.
Next time when you want ot analyse that trace
Open Profiler
On the File menu, click Open, and then click Trace File.
In the Open File dialog box, select the trace data file you want to open.
Hope this clarifies,
Kindest Regards,
Sameer Raval [Sql Server DBA]
Geico Insurance
RavalSameer@hotmail.com -
As Sameer mentioned (beat me to it
)Open the files in Profiler and you can replay them against another server or look through them. Filter them, etc.
-
Chances are you already noticed, but since you already dump your traces to a table, you can also do File, Open, Trace Table.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply