CODEWITHSUNDEEP
sql-serverperformanceindexing
kenwarner
kenwarner

Reputation: 29120

Alternative to SQL Server Tuning Advisor?

Are there any other tools out there that can analyze a SQL Profiler trace file and recommend indexes?

Upvotes: 5

Views: 2719

Answers (2)

Aaron Bertrand
Aaron Bertrand

Reputation: 280429

I highly recommend the free Qure Analyzer from DB Sophic:

http://www.dbsophic.com/qure-analyzer.html

Disclaimer: I work for SQL Sentry, who partners with DB Sophic on a paid version of their tools which work with our Performance Advisor product. This is not an attempt to up-sell, I am merely pointing you to a free tool that seems to meet your requirements.

You may also want to look at ClearTrace - it's not a one-for-one replacement for DTA, but it is quite useful if you're already collecting traces:

http://www.sqlmag.com/article/performance/cleartrace

Upvotes: 4

user847990
user847990

Reputation:

If you are running SQL 2005 or higher you can use the Index Related DMVs. You can probably search Google for a handful of scripts using them.

Upvotes: 2

Related Questions