performance issue with joins in AzureSQLDB

Question

Hi Team,

We are facing a lot of performance issues with one of our DB.
We looked into the issue, and a lot of Joints in the code are not properly designed. The previous Developers added all unnecessary joins.

Now I am planning to fix it.
As part of this yesterday when I was talking to one of my colleagues (DB2 DBA), he was telling me that There is a tool in DB2 that can analyze the entire DB and provide recommendations on joins. really I was surprised.

So, I am also looking for such kind of tool in AzureDB or some kind of mechanism which can analyze the entired DB and provide bottle necks on exiting joins and recommend fixing.

Answer 1

Hi @Vijay Kumar ,

Thanks for posting question in Microsoft Q&A forum and for using Azure services.

Regarding your ask about performance issues with Join in Azure SQL Database, it is suggested that if queries are badly designed at the application level, there isn’t such a tool that can easily fix them.
If instead performance issues are related to lack of indexes supporting those joins, then they can take a look at performance recommendations here: Database Advisor performance recommendations for Azure SQL Database

Or at Database Tuning Advisor if they are testing it locally on a SQL Server instance: Tutorial: Database Engine Tuning Advisor - SQL Server | Microsoft Learn

Hope this helps. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.

Answer 2

Hi @Vijay Kumar ,

I think you can try Query Perfomence Insight and Database advisor both available from Database panel:
https://learn.microsoft.com/en-us/azure/azure-sql/database/query-performance-insight-use?view=azuresql
https://learn.microsoft.com/en-us/azure/azure-sql/database/database-advisor-implement-performance-recommendations?view=azuresql
It will not show you unnecessary joins but you should be able to find the queries which consume more resources so they are good candidates to improvement.

Please upvote or accept as answer if it helped.