2005 Express trace

18 Jun 2006 10:15 AM

Jonathan Crawford

Hi

Is there a simple way of doing a trace with the 2005 express
version. I have the full version so I can analyse the trace with that.
I am experience performance issues with a very small express database.

I downloaded a command utility but can't get it to work

thanks

jonathan

--
===============
Jonathan Crawford
j*@tgsi.net
===============

18 Jun 2006 3:22 PM

Erland Sommarskog

Jonathan Crawford (j*@jcrawford.co.uk) writes:

> Is there a simple way of doing a trace with the 2005 express
> version. I have the full version so I can analyse the trace with that.
> I am experience performance issues with a very small express database.
>
> I downloaded a command utility but can't get it to work

I was able to set up a Profiler trace against an instance of SQL Express,
so I guess the answer is "just do it!".

--
Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx