SQL query optimzer

[BTrees]

Hi All,

I am looking for some sql query optimizer tool , which can suggest improvements (indexes, joins, etc) and point out week areas in term of performance and like that.
I am using sqlserver 2016. Is there any free tool? Or I can take advantage of ssms. Any help?

Thanks

 

[Olaf Doschke]

The Tuning advisor does that based on workload traces you record with SQL Server Profiler. The set of tools MS provides is quite complete.
I don't think there is something better for free, but redgates toolbelt is known to put everything a on major league up, including tuning.
But first use what you already have at hand.

You can profile even with the Express edition, the tuning advisor only is available with the Enterprise edition, but also with the Developer edition, as that's equal to the Enterprise edition.

Bye, Olaf.

Olaf Doschke Software Engineering

https://www.doschke.name

 

[BTrees]

Thanks Olaf, useful for me indeed.

 

[johnherman]

If you don't mind paying for it, TOAD is also a very good multiplatform SQL tool. TOAD, which originally stood for The Oracle Application Developer, has plug-ins for the various major databases, including SQL Server. And the company that owns TOAD bought a company called Lecco Tech several years ago, and Lecco had a great SQL optimizer, which has since been incorporated in TOAD. But, as Olaf mentioned, Free is Free, and TOAD is not.

==================================
advanced cognitive capabilities and other marketing buzzwords explained with sarcastic simplicity

 

[SaltyTheFrog]

You are aware of being able to view the execution plan from Enterprise manager right?

 

[BTrees]

Yes Salty, I am aware. Its hard to understand. Developing my skills in it.