問題描述
是否有一種工具可以查看您的 T-SQL 并提出提示以提高性能?例如，它查找 SARG 的用法并將查詢轉(zhuǎn)換為一個(gè)查詢而不使用 sarg.或者查明聯(lián)接的低效使用.
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.
我正在尋找數(shù)據(jù)庫引擎優(yōu)化顧問之外的工具使用探查器.例如，我目前正在檢查具有一些優(yōu)化功能的 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 有一個(gè)優(yōu)化器，它可以為我的查??詢創(chuàng)建不同的查詢或場景，并評估每個(gè)查詢的成本，但它的建議是原始的 &簡單的.它的方向是正確的，但希望優(yōu)化器會(huì)隨著時(shí)間的推移變得更智能，更有用.
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.
推薦答案
雖然它不會(huì)做早餐也不會(huì)修理你的汽車，LessThanDot SqlCop 可以突出顯示一些對性能有影響的任性的數(shù)據(jù)庫代碼和對象.它是一個(gè)最佳實(shí)踐分析器，比 Microsoft 最佳實(shí)踐分析器(更面向 DBA)更面向應(yīng)用程序.價(jià)格對他們來說都不錯(cuò)(免費(fèi)).
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 最佳實(shí)踐分析器
這篇關(guān)于用于優(yōu)化 T-SQL 的高級工具?的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網(wǎng)！