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: Tuesday, April 15, 2014 9:54 AM
Points: 1,720, Visits: 3,063
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: Tuesday, November 05, 2013 7:44 PM
Points: 446, Visits: 1,314
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


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 3:33 PM
Points: 3,731, Visits: 7,069
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: Yesterday @ 11:47 AM
Points: 41,525, Visits: 34,442
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


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 11:47 PM
Points: 20,458, Visits: 14,082
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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1410925
Posted Thursday, January 24, 2013 9:32 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 9:54 AM
Points: 1,720, Visits: 3,063
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