Re: trace file created but not populated
From: Jacco Schalkwijk (jacco.please.reply_at_to.newsgroups.mvps.org.invalid)
Date: 11/26/04
- Next message: ch: "Re: SQL Statement length"
- Previous message: Andrew D. Newbould: "Re: cluster index and identity"
- In reply to: Zarko Jovanovic: "trace file created but not populated"
- Next in thread: David Gugick: "Re: trace file created but not populated"
- Reply: David Gugick: "Re: trace file created but not populated"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 26 Nov 2004 14:34:52 -0000
The trace is kept in memory until it has reached a certain size (128 KB if I
remember correctly) or until the trace is stopped. Only then is it actually
written to disk.
-- Jacco Schalkwijk SQL Server MVP "Zarko Jovanovic" <mind_less_NOSPAM_@bigfoot.com> wrote in message news:1101478848.859745@internet.fina.hr... >I created the trace in profiler and it runs ok in the profiler. When I > transfered it as a script and run it, it is running, it did create the > file, > but the file size stays 0 and it's empty. what happened? > > btw, I even removed filters to see if file gets populated but nothing > happened. Trace is catching rpc completed and sql batch completed > > tia > > Zarko > >
- Next message: ch: "Re: SQL Statement length"
- Previous message: Andrew D. Newbould: "Re: cluster index and identity"
- In reply to: Zarko Jovanovic: "trace file created but not populated"
- Next in thread: David Gugick: "Re: trace file created but not populated"
- Reply: David Gugick: "Re: trace file created but not populated"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
