|
|
|
SSCommitted
      
Group: General Forum Members
Last Login: Yesterday @ 5:40 PM
Points: 1,631,
Visits: 2,834
|
|
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: Monday, June 10, 2013 10:06 PM
Points: 442,
Visits: 1,304
|
|
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: Yesterday @ 4:32 PM
Points: 2,063,
Visits: 3,787
|
|
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 @ 6:46 AM
Points: 38,079,
Visits: 30,373
|
|
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: Today @ 12:32 AM
Points: 18,855,
Visits: 12,439
|
|
|
|
|
|
SSCommitted
      
Group: General Forum Members
Last Login: Yesterday @ 5:40 PM
Points: 1,631,
Visits: 2,834
|
|
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
|
|
|
|