Azure SQL Intelligent Insights , SQL Insights etc...

Question

We have set up diagnostics and are using KQL to dig into application insights ( dependencies and exceptions).

We also use KQL to query Log analytics workspace ( we stream each database logs to this workspace).

We are looking for the generally available options Microsoft offers to monitor Azure sql databases - one of which is the solution called Azure SQL Analytics (Preview). BY monitoring, I mean we have a way to detect and query details of
performance hogs, errors/exceptions, waits etc...

Q1: What is the MSFT direction for Azure SQL Analytics (Preview)? Is there a generally available version?
Q2: Is there a difference between SQL Intelligent Insights and Sql Insights? My interpretation of the documentation seems to indicate that something is deprecated...
Any light you can throw on MSFT offerings to monitor Azure SQL will be much appreciated.

          https://www.infoq.com/news/2021/03/sql-insights-azure-preview/   
       https://learn.microsoft.com/en-us/azure/azure-monitor/insights/sql-insights-overview  

https://learn.microsoft.com/en-us/azure/azure-sql/database/intelligent-insights-overview

Answer 1

@Nguyen, Hoa Thank you for reaching out.

Q1: What is the MSFT direction for Azure SQL Analytics (Preview)? Is there a generally available version?

Azure SQL Analytics (currently in preview) is the solution for all your monitoring needs with Azure SQL.
All the rich diagnostic information like Errors, DatabaseWaitStatistics, Blocks, Timeouts, Deadlocks etc will be collected relayed to Azure Monitor.

The service is currently in preview, you can still configure and use it. We don't have a GA date as of now.

Q2: Is there a difference between SQL Intelligent Insights and Sql Insights? My interpretation of the documentation seems to indicate that something is deprecated...

I agree that there is an overlap and confusion with the naming conventions here. This will become consistent once the services are GA and the documentation is overhauled accordingly. I will pass on this feedback to the product teams.

The monitoring you have already set up per database will continue to work without any changes.
SQL insights enables integration with Azure monitor and will be the comprehensive solution for monitoring all products in the Azure SQL family.

----------

If an answer is helpful, please "Accept answer" or "Up-Vote" which might help other community members reading this thread.