Add support for SQL Databases
To complete the monitoring scenario with PaaS services in Azure we will value the possibility of adding Operational Insights for Azure SQL Database to help to detect complex escenarios and points for improvement (most heavey queries, concurrency, use of the performance tiers, DTUs, in my apps, detect cpu consuming queries, RAM consuming queries, etc.).
Hi, do you see this as an extension of the analysis of the ‘SQL Assessment’, or as a completely new solution tailored just for Azure SQL instances/databases?
What is most important to you in this area?
Lionel Godolphin commented
Could you simply make SQL a data source? It'd be great to pull queries ourselves and alert on them.
Sorry for the tardy reply.
Yes, indeed it would be some different solution with different best practices etc.
We (OMS) are not currently working on that ourselves, nor is the CSS organization that owns the SQL Assessment.
We had actually spoken with the Azure SQL team in the past and there was some interest there to do that themselves as 'first class', but I am not sure where that idea is at. I would try suggesting the same idea (either 'standalone' or 'in OMS' - your preference :-)) in the Azure SQL forum http://feedback.azure.com/forums/217321-sql-database
From our perspective we can envision a SQL Database instance/databases solution different from IaaS SQL Assessment. We understand there are different aproaches, and different info we can get from the PaaS model, so in order to see the model growing or adding other interesting features to monitor (as Elastic Pool for example)... We think it would worth a SQL Database (or SQL PaaS) "Smart pack"; we also understand there are some common info about the use, connections, etc. but at least by now they are two different DB Service models in the Azure offering and so we think it would be ok to have two oppinsights packs for both solutions... Make it sense?