all

We have several performance issues, which I think could be mitigated by proper indices, better queries or even partitioning as some tables have over 1B records.

I was hoping to use Database Engine Tuning Advisor, as I would do on my local copy of the DB in my previous roles, but seems it does not work in Azure, so as per Dr Google’s advise, I opened Azure’s console, went to Performance recommendations and found… nothing: it recommends an index to two irrelevant to the problematic queries tables.

What is the best tool to perform Azure SQL DB analysis, please?