August 1, 2002 at 1:31 pm
Is this possible? I need to track a lot of tracing, but the files are too big to work with--about 20MB per hour.
August 1, 2002 at 1:37 pm
What do you mean? Run profiler programmatically? This can be done. There are stored procedures to run server side traces.
Steve Jones
August 1, 2002 at 1:39 pm
Using Profiler, you do have the option of starting on a new file once the current trace file reaches a certain size. For instance, if 10 MB files are your optimum size, set Profiler to roll over at 10 MB. We use 50 MB here when we have a very granular trace going. Anything more slams Profiler when we are reviewing the traces after the fact.
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
August 2, 2002 at 8:22 am
One of the things you can do is use xp_cmdshell to rename the file before starting the trace.
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
August 2, 2002 at 8:51 am
Thanks so much for the ideas. I'll try them out.
Lisa
August 5, 2002 at 6:57 am
I've set this up and it runs fine. Because of the "hook" into the file written by the procedures, I have the filenames roll over on a schedule, then run a custom proc to process the latest file (summarize, etc.) and populate a report table. The overhead is surprisingly low. I've had it running for a few months now without a problem.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply