"Erland Sommarskog" <esquel@sommarskog.se> wrote in message
news:Xns9A56F06EF195DYazorman@127.0.0.1...
> John Sheppard (nospam@spamspam.com) writes:
>> What do you mean profile on a server-side trace?
>
> In the SQL Server program group, you find Profiler under Performance
> tools. This tool permits you trace a whole bunch of things that goes
> on in SQL Server. If you just press OK on all buttons that comes up,
> you will see all command batches that are sent to the server. You can
> set up filter to trace only a certain connection. And a lot more.
>
> The Profiler is just the front-end. The trace engine itself lives in
> SQL Server, and you can access it directly by setting up a server-side
> traces. (The easiest way to do that is to set up the trace in Profiler and
> then export the trace.) Server-side trace is the recommended for long-term
> traces, and also when you trace in loaded production environments, as
> it takes less load than a Profiler trace.
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/pro...ads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinf...ons/books.mspx

ic! Thats what I want!

Now you're gonna tell me that it doesnt come with SQL Server Express, right?
Im pretty sure it doesnt as theyre not there....

I'll look into it

Thanks for your help man, I'll see what I can find...
John