Geek Answers Handbook

Are there any query optimization tools for SQL Server?

Are there any query optimization tools for SQL Server 2005 and higher?

I searched and found nothing.

What do you recommend?

If this question was repeated before you can close it, but I have not seen anything like it

+8
sql-server query-optimization
source share
6 answers

The best tool that I have ever used to optimize queries in MS SQL Server today is the option "Include an actual execution plan" in Microsoft SQL Server Management Studio. It displays detailed information about the execution path that the server executes when executing the request. (Note that this works best when there is data in the tables. Of course, without good test information, any optimization is purely theoretical anyway.)

This basically gives you three very important things:

  • It tells you which steps take more processing time and what they do at this point.
  • It tells you which steps take most of the data to the next step, including the number of records that help identify places where you can be more specific about the data you want and eliminate unnecessary records.
  • This gives you an idea of ​​the internal workings of SQL Server and what it does with your queries. This knowledge will help you significantly optimize things over time.
+25
source share

The SSMS - Tools | Database Engine Tuning Advisor - Doesn’t work in Express versions.

+4
source share

One very good tool and now free to use is the Plan Explorer from SentryOne: https://sentryone.com/plan-explorer

(they also have many other optimization programs, such as Azure software, etc.)

+3
source share

One of the best query optimizers is to simply run the query in SQL Management Studio and then check the query plan. This will give you hints as to which indexes it uses (or doesn't use), and how you can modify the query to take advantage.

+2
source share

As John Saunders noted, the best tool at your disposal is your own mind. Following the comment by bernd_k, here are some tips for tightening this tool.

0
source share

It is also a good tool for monitoring and optimizing queries:

Red Gate Sql Monitor

0
source share

Source: https://habr.com/ru/post/650141/

More articles:


All Articles