What tool can monitor my SQL Server usage and suggest optimizations?

views:

207

answers:

+2 Q:

What tool can monitor my SQL Server usage and suggest optimizations?

I have a vague recollection of hearing about a profiling tool that could sit and watch the SQL Server that is serving data to my production website. In particular, I'm looking for a tool that can, based on profiling what is actually taking the most time, do things like make suggestions for new indexes or other sorts of simple optimizations.

What tool can do this?

+8 A:

Database Engine Tuning Advisor and SQL Profiler are the way to go.

If you are using SQL Server 2000, you could use Index Tuning Wizard instead of DB Engine Tuning Advisor.

Mehrdad Afshari 2009-03-20 21:21:10

Looks like DETA is only available on 2005 and up. Too bad for me (2000).

lush 2009-03-20 21:28:40

@Christopher: There was a 2000 thingy, if I remember correctly, "Index tuning wizard" or something. (long time no 2000).

Mehrdad Afshari 2009-03-20 21:30:05

http://msdn.microsoft.com/en-us/library/cc966541.aspx

Mehrdad Afshari 2009-03-20 21:30:36

Check out this article from the January 2008 issue of MSDN magazine.

Uncover Hidden Data to Optimize Application Performance

WakeUpScreaming 2009-03-21 17:54:47

ansaurus

tags:

views:

answers:

What tool can monitor my SQL Server usage and suggest optimizations?

related questions