|
|
|
SSCommitted
      
Group: General Forum Members
Last Login: 2 days ago @ 4:55 PM
Points: 1,597,
Visits: 2,770
|
|
If I open the default trace log in sql server profiler to view. It opens all the rollover files in one window.
Is there a way that I can filter out the records by some criteria?
I don't see an option, I can see a find... option, but it is not very helpful.
|
|
|
|
|
SSC-Addicted
      
Group: General Forum Members
Last Login: Thursday, May 16, 2013 8:44 PM
Points: 442,
Visits: 1,300
|
|
What version of Profiler are you using? I get a popup asking me if I want to open the next Rollover file.
I'm using Profiler from SQL 2008 R2.
Leo
|
|
|
|
|
SSCrazy
      
Group: General Forum Members
Last Login: 2 days ago @ 8:50 AM
Points: 2,035,
Visits: 3,759
|
|
In SQL 2005 & 2008, Under SQL Profiler Options there should be a radio button under "File Rollover Options" to say "Prompt before loading rollover files". And yes, there is also a way to filter and search through the trace file itself - click on the "find" icon, or press Ctrl-F
______________________________________________________________________________ "Never argue with an idiot; They'll drag you down to their level and beat you with experience"
|
|
|
|
|
SSC-Dedicated
           
Group: General Forum Members
Last Login: Today @ 3:10 AM
Points: 37,642,
Visits: 29,896
|
|
Much easier to use fn_trace_gettable and then filter within SQL. The profiler GUI's a pain to filter, sort and search in.
Gail Shaw Microsoft Certified Master: SQL Server 2008, MVP SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter We stand on the bridge and no one may pass
|
|
|
|
|
SSCoach
         
Group: General Forum Members
Last Login: Thursday, May 16, 2013 1:46 PM
Points: 18,732,
Visits: 12,329
|
|
|
|
|
|
SSCommitted
      
Group: General Forum Members
Last Login: 2 days ago @ 4:55 PM
Points: 1,597,
Visits: 2,770
|
|
Thanks all.
Yes that's what I found too, I am using 2008, and it prompts if I want to open rollover files. And I see a Find button that is not very helpful to search.
I think I will use T_SQL then.
Thanks
|
|
|
|