+1.
And if you don’t have diag pack licenses, the same author has written a
freeware ASH alternative which Mumbai can use instead.
Regards
Jo
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
Virusvrij.
www.avast.com
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
On 24 November 2017 at 03:36, Mladen Gogala <gogala.mladen@xxxxxxxxx> wrote:
I like Marcus Moening's "Mumbai" tool. You can download it here:
https://marcusmonnig.wordpress.com/download/
It works only on Winduhs (yeah, I know), but is otherwise an excellent
too, at least in my opinion.
Regards
On 11/19/2017 07:39 PM, dba oracle wrote:
Hi Gurus,
I am currently looking for a SQL Tuning tool can be used by DBA as well as
developers. The background is that we have many complex SQLs being
developed in our products, each developer may touch those SQLs and change
them if he/she is handling a ticket related to them. Every change might
cause performance changing (and actually they did). We want to find a tool
can be easily used by the developers, and then give them a training
session, they will be able to tune their new developed/changed SQL before
tagged to the release.
I've tried SQL developer. It just simply give us the chance to use SQL
Advisor.
I also tried Toad, it more looks like an offline SQL advisor. And it has
crashed several times in my Win 10. It is really frustrating.
I also found this tool, SQLBooster, from www.SQLFast.com. It's cool
because it can brake the complex SQL down to small queries to analyze the
bottleneck. But there is only a few documents provided in the website and
the UI is not so friendly. I am still struggling on testing it.
Do you guys have any recommendation?
Regards,
Wil
--
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
