問題描述

是否有一種工具可以查看您的 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模板網！