This article gives an overview of viewing execution plans in the Azure Data Studio.
本文概述了在Azure Data Studio中查看执行计划。
介绍 (Introduction)
Database administrators use a query execution plan for troubleshooting query performance issues. Suppose one day a user calls you and says my query is running slow. You might perform several checks such as blocking, deadlock, CPU, memory, IO utilization, waits etc. You can also capture the query execution plan to check the overall flow of the query internally. You get detailed information in the plan.
数据库管理员使用查询执行计划来解决查询性能问题。 假设某天某用户打电话给您,并说我的查询运行缓慢。 您可能会执行一些检查,例如阻塞,死锁,CPU,内存,IO利用率,等待等。您还可以捕获查询执行计划,以在内部检查查询的总体流程。 您将在计划中获得详细信息。
We can get two formats of a query execution plan:
我们可以获得查询执行计划的两种格式:
Graphical: it gives a graphical representation of all operators, their properties, tooltip information. We can interpret results quickly in a graphical format
图形化:它以图形方式表示所有操作员,其属性和工具提示信息。 我们可以以图形格式快速解释结果
XML format: It shows a query plan in an XML format. It gives detailed information, but you should be an experienced DBA to understand it
XML格式:它以XML格式显示查询计划。 它提供了详细的信息,但是您应该是有经验的DBA才能理解它
You can check out the following articles to get a detailed knowledge of execution plans.
您可以查看以下文章以获得执行计划的详细知识。
- SQL Server Execution Plans overview SQL Server执行计划概述
- How to Analyze SQL Execution Plan Graphical Components 如何分析SQL执行计划图形组件
SQL Server provides the following types of query plans:
SQL Server提供以下类型的查询计划:
- Estimated execution plan: SQL Server generates the query plan without actually executing the query 估计执行计划 :SQL Server生成查询计划,而无需实际执行查询
- Actual execution plan: It is an actual representation of a query plan that SQL Server generates by executing the query 实际执行计划:这是SQL Server通过执行查询生成的查询计划的实际表示。
You can go through SQL Server Execution Plans types for comparison of an estimated and actual query plan.