save Trace result (SQL Profiler)

#11

If all you are saving is the SQL Statements that are being executed, the
burden is not great at all. The burden only comes in when you you trace
things that are very internal to SQL Server, like locks, or memory growth,
or file growth.

--
HTH
----------------
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com

"M" <mary2001 (AT) canada (DOT) com> wrote

Quote:

Thanks,there were so many good points,
but is there other way to follow users' activities with low burden on
server?
would anybody please recommend a way to do this?

On Thu, 3 Jul 2003 13:10:35 -0700, Maciek Sarnowicz [MSFT]
macies (AT) online (DOT) microsoft.com> wrote:

A good way to configure a trace is to use SQL Profiler itself:
First create a trace in GUI and pick whatever events and columns you
want.
Run it manually to verify that it returns what you expect. Once you are
happy with it select File|Script Trace|For SQL 2000 menu option. It will
create a SQL script that configures and starts a trace that you have
just
ran.

A side note: Please remember that tracing puts a significant burden on a
server. There may be other ways of accomplishing what you need. If you
really want to go that route, configure your trace so it requests only
events and columns that you really need.

Hope that helps.

Regards,
Maciek Sarnowicz

-----------------------------
This posting is provided "AS IS" with no warranties, and confers no
rights.

"M" <mary2001 (AT) canada (DOT) com> wrote in message
news

prrn7dtg8hu9goh (AT) msnews (DOT) microsoft.com...
now I successed to define a trace with following code
now how can I start it?and how can I make as an autostart
statement when SQL Server will need to autostart?

-----------------it returned 12---------
declare @rc int, @TraceID int
declare @maxfilesize bigint

set @maxfilesize = 5
exec @rc = sp_trace_create @TraceID output, 2,
N'e:\esttrace', @maxfilesize, NULL
print @rc
-----------------

On Tue, 1 Jul 2003 22:18:27 -0700, Kalen Delaney
replies (AT) public_newsgroups (DOT) com> wrote:

-- Using M2, Opera's revolutionary e-mail client:
http://www.opera.com/m2/

--
Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/

#12

there's some question with me:
how can I automatically start a trace everyday?
I made a script on my trace information by SQl profiler
but there was no topic related to the name of table kept
my trace result,why?
how can trace result be stored in different tables related to different
days? in other word how can automatically
change the name of table ,to keep the result of several days?

On Tue, 01 Jul 2003 14:44:01 +0430, M <mary2001 (AT) canada (DOT) com> wrote:

Quote:

How can I schedul my trace to save the result periodicly
in SQL Profiler?

On Tue, 01 Jul 2003 10:44:23 +0430, M <mary2001 (AT) canada (DOT) com> wrote:

Hi

I 've SQL Server 2000(client/server) and I want to keep and save all
activities happening in my databases life,and I found SQL Profiler
which trace each steps and show me these activities,
but how can I do this everyday?should I physically come and
run a new trace in SQL Profiler ? and you know that it can
save the result at most in 9999rows table,so when it became to
full it's time to define another one,
another question:to prevent creating different tables for trace
result can we append second and 3th and... result at the end of
first one? totally,is it a correct way to save DB activities for
SQLAdmin
and refer to them in several times?
I'd be thankful for your help.

--
Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/