用于优化 T-SQL 的高级工具?

问题描述

是否有一种工具可以查看您的 T-SQL 并提出提示以提高性能?例如，它查找 SARG 的用法并将查询转换为一个查询而不使用 sarg.或者查明联接的低效使用.

Is there a tool which can look at your T-SQL and suggest hints for better performance? For example it finds usage of SARGs and converts a query into one without use of a sarg. Or pinpointing inefficient use of joins.

我正在寻找数据库引擎优化顾问之外的工具使用探查器.例如，我目前正在检查具有一些优化功能的 Toad for SQL Server.

I am looking for tools beyond the Database Engine Tuning Advisor & use of the Profiler. For example I am currently checking out Toad for SQL Server which has some optimization features.

添加:

Toad 有一个优化器，它可以为我的查​​询创建不同的查询或场景，并评估每个查询的成本，但它的建议是原始的 &简单的.它的方向是正确的，但希望优化器会随着时间的推移变得更智能，更有用.

Toad has an optimizer where it creates different queries or scenarios for my query and evaluates the cost of each query but its suggestions are primitive & simple. It's in the right direction but hopefully the optimizer gets a lot more smarter over time and be more useful.

推荐答案

虽然它不会做早餐也不会修理你的汽车，LessThanDot SqlCop 可以突出显示一些对性能有影响的任性的数据库代码和对象.它是一个最佳实践分析器，比 Microsoft 最佳实践分析器(更面向 DBA)更面向应用程序.价格对他们来说都不错(免费).

While it won't cook breakfast nor repair your automobile, the LessThanDot SqlCop can highlight some wayward database code and objects which have an effect on performance. It is a best practices analyzer that is more application-oriented than the Microsoft Best Practices Analyzer (which is more DBA-oriented). The price is nice for both of them (free).

自己检查一下...

• LessThanDot SqlCop

MS 最佳实践分析器

这篇关于用于优化 T-SQL 的高级工具?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持html5模板网！