A handy and free statement analysis tool plan Explorer

During the optimization of the query statement during the tuning process, the execution plan of the analysis statement is the only way, and a good execution plan analysis tool can really help us to do more.

tip : Plan Explorer is the new, completely free version of integrating Plan Explorer Pro with the free edition. Microsoft's database experts and developers are also using OH. Now, the entire feature set is free, and for DBAs, benefits!

The main features of Plan Explorer are:

1. Quickly locate which statement in the stored procedure statement using the total resource (percentage), and more Io reads and writes (the line thickness) by executing the plan form or graphical form.

2. Histogram statistical analysis, provide new query parameters and corresponding statistics and highlighting, while you can clearly see the compile and run-time query parameters on the performance of the impact, quickly find possible to lead to the "parameter sniffing", sorting problems, and the possibility of using appropriate filtering index.

3. By querying the performance analysis and playback functions, you can accurately identify how a query affects cpu,i/o and waits for resources. Specific operation can try it yourself, very interesting. Demo Video Click here

(Note: The playback feature supports SQLServer2014 and later versions)

4. Clearly show the actual execution plan cost and the cost of the execution plan based on the optimizer evaluator estimate.

5. The complete execution plan diagram shows the current path in a very clear way, quickly identifying the most expensive I/O and CPU Resource usage, and displaying the visual representation in percentages and colors.

6. You can also record the revision history in the statement tuning to help you see the contrast before and after. You can add contextual comments to any version of the plan, and then save and share them with others.

7. Under the same Plan Explorer instance, perform a tuning analysis of multiple statements at the same time.

8. Visually display deadlock information to help us quickly locate problems and solve ideas.

9. After you install the Plan Explorer plugin in SSMs, in the execution plan interface that appears after SSMS executes the statement, right-click the "View with SQL Sentry Plan Explorer" to switch to the Plan Explorer in one click for easy operation.

Plan Explorer official:Plan-explorer or Https://sentryone.com/plan-explorer

Summary: A good performance optimization analysis tool can help our technicians to quickly and effectively identify the source of the problem, and in the shortest possible time to achieve the desired optimization results. Most of the better tools on the market are commercially available, and it is rare to find several useful and exempt people, thanks to these contributors. If you want to reprint, please add this article link and note the source http://www.cnblogs.com/SameZhao/p/6186023.html, thank you!

A handy and free statement analysis tool plan Explorer