StrataFrame Forum » .NET Forums » General .NET Discussion » SQL Server Query Optimization

SQL Server Query Optimization

Edhy Rijo — Sat, 29 Aug 2009 12:11:34 GMT

Does anybody know of a tool that would help you optimize SQL tables (with proper indexes) for a particular query?

RE: SQL Server Query Optimization

Trent L. Taylor — Sat, 29 Aug 2009 12:11:34 GMT

It is good and we have used it in the past. It is a good product and the price point isn't bad. For most things it works really well. However, we now use AQTime from automated QA which doesn't seem to get bogged down when running very large applications. Here is their link: [url=http://www.automatedqa.com/products/aqtime/]http://www.automatedqa.com/products/aqtime/[/url]

RE: SQL Server Query Optimization

Edhy Rijo — Sat, 29 Aug 2009 12:09:11 GMT

Thanks Trent, I will keep looking.

BTW for .NET applications I came across to this one: [url=http://www.red-gate.com/products/ants_performance_profiler/index.htm]ANTS Performance Profiler™[/url] from RedGate.

After looking briefly to some videos it looks like a one of those tools that are a MUST to have.

RE: SQL Server Query Optimization

Trent L. Taylor — Sat, 29 Aug 2009 12:02:10 GMT

Well, there are a number of tools that show the execution plan. If you can learn to interpret the execution plan through SSMS you can really get a lot of good information here. But there are a number of tools out there that will give metrics and analytics showing what is broken, but I do not know of one that tells you how to change your query to an explicit value.