SQL Profiler 2000

10 Sep 2007 9:08 PM

Ron

SQL2000 SP4

Does SQL2000 have a tuning advisor (like SQL2005) or anything comparable? I
have a trace I'd like to analyze but it's a bear to go through.

Thanks

Ron

10 Sep 2007 9:51 PM

Erland Sommarskog

Ron (R**@discussions.microsoft.com) writes:

> Does SQL2000 have a tuning advisor (like SQL2005) or anything
> comparable? I have a trace I'd like to analyze but it's a bear to go
> through.

There is the Index Tuning Wizard. It's reputation is not as good as
of DTA. I have used neither myself.

--
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

14 Sep 2007 5:54 PM

Ron

Thanks Erland - I didn't realize you could point it at a trace.

Show quote

"Erland Sommarskog" wrote:

> Ron (R**@discussions.microsoft.com) writes:
> > Does SQL2000 have a tuning advisor (like SQL2005) or anything
> > comparable? I have a trace I'd like to analyze but it's a bear to go
> > through.
>
> There is the Index Tuning Wizard. It's reputation is not as good as
> of DTA. I have used neither myself.
>
>
> --
> 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
>