是否有适用于 SQL Server 的查询优化工具? [英] are there any Query Optimization Tools for SQL Server?
问题描述
是否有任何工具可以对 SQL Server 2005 及更高版本进行查询优化?
Are there any tools that do Query Optimizations for SQL Server 2005 and above?
我已经搜索过 &什么都没找到.
I've searched & didn't find anything.
你有什么推荐?
如果此问题在您关闭之前重复出现，但我没有看到任何类似内容
If this Question was repeated before you can close it but I didn't see anything similar
推荐答案
迄今为止，我在 MS SQL Server 中用于优化查询的最佳工具是 Microsoft SQL Server 管理中的包括实际执行计划"选项工作室.它显示有关服务器在运行查询时采用的执行路径的详细信息.(请注意，当表格中有数据时，这种方法效果最好.当然，如果没有大量测试数据，任何优化都只是理论上的.)
The best tool I've ever used for optimizing queries in MS SQL Server, by far, is the "Include Actual Execution Plan" option in Microsoft SQL Server Management Studio. It displays detailed information about the execution path taken by the server when running your query. (Note that this works best when there's data in the tables. Of course, without a good bit of test data, any optimization is purely theoretical anyway.)
它基本上为您提供了三件非常重要的事情:
It basically gives you three very important things:
- 它会告诉您哪些步骤需要最多的处理时间以及他们在该步骤中正在做什么.
- 它会告诉您哪些步骤将最多的数据带到下一步，包括有多少记录，这有助于确定您可以更具体地了解所需数据的位置，并排除不必要的记录.
- 它让您吨深入了解 SQL Server 的内部工作原理以及它对您的查询的作用.随着时间的推移，这些知识将帮助您优化很多事情.
- It tells you which steps take the most processing time and what they're doing at that step.
- It tells you which steps carry the most data to the next step, including how many records, which helps identify places where you can be more specific about the data you want and exclude unnecessary records.
- It gives you a ton of insight into the inner workings of SQL Server and what it does with your queries. This knowledge will help you optimize things a lot over time.
这篇关于是否有适用于 SQL Server 的查询优化工具?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
