問(wèn)題描述

是否有一種工具可以查看您的 T-SQL 并提出提示以提高性能?例如，它查找 SARG 的用法并將查詢(xún)轉(zhuǎn)換為一個(gè)查詢(xún)而不使用 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ù)庫(kù)引擎優(yōu)化顧問(wèn)之外的工具使用探查器.例如，我目前正在檢查具有一些優(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)化器，它可以為我的查??詢(xún)創(chuàng)建不同的查詢(xún)或場(chǎng)景，并評(píng)估每個(gè)查詢(xún)的成本，但它的建議是原始的 &簡(jiǎn)單的.它的方向是正確的，但希望優(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ì)修理你的汽車(chē)，LessThanDot SqlCop 可以突出顯示一些對(duì)性能有影響的任性的數(shù)據(jù)庫(kù)代碼和對(duì)象.它是一個(gè)最佳實(shí)踐分析器，比 Microsoft 最佳實(shí)踐分析器(更面向 DBA)更面向應(yīng)用程序.價(jià)格對(duì)他們來(lái)說(shuō)都不錯(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 的高級(jí)工具?的文章就介紹到這了，希望我們推薦的答案對(duì)大家有所幫助，也希望大家多多支持html5模板網(wǎng)！