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

Create trace problem Expand / Collapse
Author
Message
Posted Tuesday, December 14, 2010 8:34 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, January 28, 2014 3:52 PM
Points: 377, Visits: 685
I am trying to create a trace using the following where @outputfilename is "\\mycomputer\mysharedfolder\tracefilename"

exec @rc = sp_trace_create @TraceID output, 0, @OutputFileName, @MaxFileSize, @EndTime

The problem is that it does not create the file in that location and yet the trace is running on the serve

I have given full permission to "everyone" on that folder.

If I create a file named "tracefilename.trc" manually and then run the trace, it gives me a message that the file already exists.

Any ideas???

Thanks.
Post #1034476
Posted Tuesday, December 14, 2010 9:55 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 9:00 PM
Points: 2,828, Visits: 8,474
Sounds like you already have a trace running that's outputting to your desired filename.

What are the results of: select * from sys.traces



Post #1034541
Posted Tuesday, December 14, 2010 10:09 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Friday, June 27, 2014 12:43 PM
Points: 15,444, Visits: 9,596
Did you remember to turn the trace on? sp_trace_setstatus needs to be run to turn it on. Till you do that, it won't create any files.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Post #1034550
Posted Tuesday, December 14, 2010 1:14 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, January 28, 2014 3:52 PM
Points: 377, Visits: 685
The trace is running but it does not create the file.
Post #1034681
Posted Tuesday, December 14, 2010 1:42 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 9:00 PM
Points: 2,828, Visits: 8,474
When you run this: select * from sys.traces
What is in "path" ?



Post #1034705
Posted Wednesday, December 15, 2010 5:32 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, January 28, 2014 3:52 PM
Points: 377, Visits: 685
It is working and it is now creating the files. I have not made any changes since yesterday and this morning it is working and i have no clue why. But now when I try to open the trace file it gives me a message "There was a problem sending the command to the program". It is trying to open the file thru ATL/MFC Trace Tool. Any ideas?

Thanks for your time.
Post #1035049
Posted Wednesday, December 15, 2010 9:28 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 9:00 PM
Points: 2,828, Visits: 8,474
I'm not familiar with that tool. I use SQL profiler to open the .trc file


Post #1035263
Posted Friday, December 17, 2010 8:03 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, January 28, 2014 3:52 PM
Points: 377, Visits: 685
Thanks.
Post #1036548
Posted Wednesday, July 20, 2011 2:16 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, September 14, 2011 4:13 PM
Points: 16, Visits: 41
Can you please post the script I want to see a sample so I can modify the file size
Post #1145456
Posted Wednesday, July 20, 2011 3:37 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, October 27, 2011 1:53 PM
Points: 17, Visits: 115
You can try stopping and closing the trace. Then try again. I am not sure what your whole trace setup looks like, but you need to add events, columns, filters, etc. Here is an article that goes into the basics of tracing with SQL commands:

SQL Performance Trace

Microsoft's articles are really good as well.


Jason

Webmaster at SQL Optimizations School
Post #1145513
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse