Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

view default trace file in SQL profiler Expand / Collapse
Author
Message
Posted Wednesday, January 23, 2013 6:42 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 12:10 PM
Points: 1,792, Visits: 3,262
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.

Post #1410865
Posted Wednesday, January 23, 2013 7:34 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Sunday, November 9, 2014 7:56 PM
Points: 450, Visits: 1,343
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

Post #1410872
Posted Wednesday, January 23, 2013 7:40 PM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Monday, November 24, 2014 5:46 AM
Points: 4,031, Visits: 7,172
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"
Post #1410873
Posted Wednesday, January 23, 2013 11:36 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 8:36 AM
Points: 40,615, Visits: 37,080
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

Post #1410912
Posted Thursday, January 24, 2013 12:09 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 3:20 PM
Points: 18,064, Visits: 16,099
In addition to what Gail said, here is a simple script to Read from the default trace

DECLARE @path NVARCHAR(260);
SELECT @path = REVERSE(SUBSTRING(REVERSE([path]),
CHARINDEX('\', REVERSE([path])), 260)) + N'log.trc'
FROM sys.traces WHERE is_default = 1;

SELECT *
FROM ::fn_trace_gettable(@path,DEFAULT)





Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1410925
Posted Thursday, January 24, 2013 9:32 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 12:10 PM
Points: 1,792, Visits: 3,262
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
Post #1411212
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse