Saturday, February 1, 2014

SQL Doctor

Recently I found a tool which will help us to analyze SQL processes and to identify the performance degrading factors. It seems to be really good tool. But of course it will not be as intelligent as a human expert. And it cannot be.

As there are some well documented tips out there to boost SQL performance, this tool too would analyze the given DB or the Query and will give us some hints on improving the performance. As I said, it is not that brainy to analyze our logic flow and identify the causes but would give some static hints which are relevant to our Query/Queries.

It is not a free tool but 14 days trial version is available. The tool would help at least to learn something about elevating SQL performance I would say. I tested its features with a quite big DB.
Let me share the things that I found there.


Initial look would be like this.


 
We can add the database server and database there. Once we set this up, analysis will be started.

 

As we see in the above given screenshot, some hints will be given. If we double click on each item, then the detail window will pop up.

E.g: When I double click on that “duplicate index found” hint, the following detail window showed up.


 
We can diagnose the issues in each and every script one by one as well. In that case we need to click on “Diagnose Queries” option. Then we will get this window 
















Here if we paste our query and click on “Diagnose”, statistics window will appear.

In my sample query analysis, one and only issue is reported.

 
When double click on it, detail window appeared.


 
When it is script related issue, then if we click on “Show me the problem” option which was hidden in the previous case (duplicate index issue), it will direct us to the particular part of the script which has the issue.
 

 
There are varieties of analysis that would help us on improving the performance. The best thing about this tool is it’s very detailed and well organized. I’m not sure it would worth the price that we give for it if we are to buy. But it would help at least to gain some insight on SQL queries. I would recommend to try it once.


SQL Doctor seems to be a very knowledgeable doctor. :) 

Hope this helps.


No comments:

Post a Comment