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

Stairway to Server-side Tracing - Step 6: How to Import Trace Data Expand / Collapse
Author
Message
Posted Monday, February 14, 2011 10:37 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, April 18, 2014 7:07 AM
Points: 53, Visits: 280
Comments posted to this topic are about the item Stairway to Server-side Tracing - Step 6: How to Import Trace Data
Post #1063690
Posted Monday, July 25, 2011 11:45 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 11:32 AM
Points: 180, Visits: 326
I have been usinging the AdHoc trace file for some time now. I typically save the trace files to a network share location for retention. The location is backed up to tape regularly. Recently I have attempted to review the files using the fn_trace_gettable and have found that regarding my SQL 2008 files, I cannot access the files and receive an error "either does not exist or is not a recognizable trace file. Or there was an error opening the file". I played with my trace and did find that if I saved the file to the local drive I don't encounter any problems. I also found that I have absolutely no problems using SQL 2005 and the fileshare location.
Is there possibly a new bug regarding this matter? I thought this used to work with SQL 2008 but I'm not 100% sure I have attempted to view the log file since I have applied SP2.
Any ideas? It's not very practical to save the files to a local drive as it will continue to rollover and take up drive space and It is not secure to save this information on the server.
Post #1147752
Posted Monday, July 25, 2011 6:05 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, April 18, 2014 7:07 AM
Points: 53, Visits: 280
You should be able to select from a remote trace file with fn_trace_gettable using a UNC path without problems. I just ran a cursory test and had no problems under SQL 2008 SP2. Is the error intermittent?
Post #1147952
Posted Saturday, January 07, 2012 3:30 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 10:36 AM
Points: 896, Visits: 1,479
This has to be the best article I've read about traces ever.
Please keep them coming with real world examples like the one from Listing 5 and 6.
Much appreciated.

Best regards,


Best regards,

Andre Guerreiro Neto

Database Analyst
http://www.softplan.com.br
MCITPx1/MCTSx2
Post #1231976
Posted Monday, January 16, 2012 8:04 AM


Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, April 14, 2014 7:10 AM
Points: 7, Visits: 183
I received the same error in a test environment where I was running SSMS 2008 on my local box but connected remotely to a SQL Server 2005 instance. I believe something changed in the .trc formatting from SQL Server 2005 to SQL Server 2008 R2, but I'm not clear yet on exactly what it was. If anyone has information on the details of those changes, I'm very curious.

And I agree with codebyo - great series!!


------------------------
David Caughill
Production DBA
Grad Student
Coffee Enthusiast
Post #1236633
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse