Re: SQL 7 Traces
From: Greg Linwood (g_linwoodQhotmail.com)
Date: 04/21/04
- Next message: Learner: "Rephrased with more details : SQL is driving me crazy"
- Previous message: Vinodk: "Re: Index Tuning Wizard problem"
- In reply to: Greg: "SQL 7 Traces"
- Next in thread: Tibor Karaszi: "Re: SQL 7 Traces"
- Reply: Tibor Karaszi: "Re: SQL 7 Traces"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 21 Apr 2004 15:01:22 +1000
Hi Greg.
With SQL 7, you can simply use the SQL Profiler to trace the server. SQL
Profiler is a GUI tool that hooks into server events inside SQL Server.
There are server side services that can run without the GUI which are more
efficient and particularly convenient for admin purposes (can be scheduled
etc).
To see what traces are running:
use master
exec xp_trace_enumqueuehandles gives you all current trace queues (whether
Profiler is attached to them or not)
To stop server side traces you'd use a combination of the
xp_trace_enumqueuehandles and xp_trace_destroyqueue system extended stored
procedures. These are written up in SQL 7.0 Books Online so I suggest you
read up on them there..
HTH
Regards,
Greg Linwood
SQL Server MVP
"Greg" <anonymous@discussions.microsoft.com> wrote in message
news:AAB5C58A-BBB1-42D7-8DD5-A4B76E820131@microsoft.com...
> Can someone tell me how to do a server side trace in SQL 7?
> How to see what traces are running?
> How to stop them?
> Etc.....
- Next message: Learner: "Rephrased with more details : SQL is driving me crazy"
- Previous message: Vinodk: "Re: Index Tuning Wizard problem"
- In reply to: Greg: "SQL 7 Traces"
- Next in thread: Tibor Karaszi: "Re: SQL 7 Traces"
- Reply: Tibor Karaszi: "Re: SQL 7 Traces"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
