June 24, 2005 at 3:14 am
Hi! Remember the window "Trace Properties" in SQL Profiler? You can specify "Save to table"...
BUT, sp_trace_create has ONLY FILENAME parameter! What a mess?!
Who knows, how trace starting can be automated and writing to a table be achieved simultaneosly?
REMARK: writing to a table is performed because of speed the history of SP calls can be retrieved (often no time to wait to log file exceed its MaxSize)
June 24, 2005 at 10:31 am
like it or not is a two step process.
If you try to script the profiler settings when performing table output it will write this line in the script:
-- Client side File and Table cannot be scripted<O> </O>
<O> </O>
if you are interested in automating the process have a look at :
http://www.sqlservercentral.com/columnists/jyao/sqlserverauditingandnotification.asp
http://www.sqlservercentral.com/columnists/rsharma/schedulingsqlservertracespart2.asp
Or if you can live with third parties:
* Noel
June 25, 2005 at 5:34 am
Noel - BIG thanks!
first article is great!
I see you have much more experience in this brunch.
And following question -
Is there a method of reporting that new trace file has begun and its time to upload trace results in DB table?
How can i set an anchor to such event?
I could use TRACE_PRODUCE_BLACKBOX to generate trace output to file and when it switches between two blackbox files - perform DB table insertion...
September 15, 2005 at 2:08 pm
When I try to get to the 2nd link it comes back as page not found - how can I get that link?
Thanks!
September 16, 2005 at 3:59 am
me too...
try bugging tech-support for that page, Susan!
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply