SQL 2005 Show Server Trace

18 Oct 2006 5:04 PM

NYX

Am I the only one who found this useful?
I am unable to find in Management Studio the equivelent to 2000 Query
Analyzers "Show Server Trace".

If it is no longer there, is there an equivelent way to do this?
It helped tremendously to show a query took a tenth of a sec to run but 33
secs to deliver to the client. Know what I mean?

19 Oct 2006 9:51 AM

Robert Klemme

On 18.10.2006 19:04, NYX wrote:

> Am I the only one who found this useful?
> I am unable to find in Management Studio the equivelent to 2000 Query
> Analyzers "Show Server Trace".
>
> If it is no longer there, is there an equivelent way to do this?
> It helped tremendously to show a query took a tenth of a sec to run but 33
> secs to deliver to the client. Know what I mean?

You can invoke the profiler from Mgmt Studio. Plus, you can save a SQL
script from a trace to be used for server side tracing. Does that help?

Kind regards

robert