May 7, 2009 at 2:50 pm
Check sp_trace_create in BOL. A problem I see withyour is options is set to 0, when it needs to be 2 for rollover.
May 7, 2009 at 3:10 pm
Thanks, Lynn. I initially had this set to 2, but same results. The script I built from Profiler actually uses 0, so I tried that next which is why I included it this way on the script above.
Thanks!
May 8, 2009 at 6:40 am
Well, since you are setting the stop time to 5 minutes I would venture to say that you are only collecting 128KB of data and would never fill a 5MB file so you wouldn't need to rollover.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
May 8, 2009 at 10:49 am
Well, the server processes many records a second. 5 minutes should fill up a 5mb file no problem so a roll_over would probably be expected. The problem is that it stops at 128KB, which I did not specify that limit.
May 8, 2009 at 11:48 am
JuanBob (5/8/2009)
Well, the server processes many records a second. 5 minutes should fill up a 5mb file no problem so a roll_over would probably be expected. The problem is that it stops at 128KB, which I did not specify that limit.
It's certainly easy to find out, increase the run time to 10 minutes or omit the stop time parameter and manually stop it.
How big the file gets depends on how many events and columns you include in trace and any filters you have applied as well as activity.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 5 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply