Please provide SQL monitoring for Application Insights
Please provide SQL monitoring
Being a part of Azure eco-system and having a strong partnership with Azure domain experts, we are currently working to improve our app dependencies analysis and leverage tools and expertise of Azure related services. Leveraging this partnership with SQL, we have recently started
1. Incorporating SQL Azure insights and tools into Application Insights, reflecting available active recommendations, such as index, schema and parameterization recommendations at DB level, which may fix a detected issue and improve app performance.
2. Keeping flow context we enable a user who starts navigating in App Insights to continue his analysis in SQL complementary tools such as Query Performance Insights and view top consuming queries, individual query details, and more for a related SQL Azure DB.
If you have feedback or ideas to further refine SQL monitoring capabilities in Application Insights, please create new a new UserVoice suggestion in the “Service monitoring and diagnostics” category at https://visualstudio.uservoice.com/forums/357324-application-insights/category/162000-service-monitoring-and-diagnostics.
Alexandr Marchenko commented
Would be nice if there will be something like guys from NewRelic are doing
Victor Mushkatin commented
Currently we're not providing SQL monitoring as part of AI. We've heard about scenarios to track query blocking issues, index distribution and collecting query plans. At current moment those scenarios in the backlog but are not actively worked on. If you have any particular story you would like to address we'd love to learn about it.
With that said, there are two ways you can infer SQL performance:
1) you can go to Diagnostic\Events select Event type: Performance and group by: Heaviest Resources. If SQL call was causing the problem you will be able to see it. In addition to that, in any performance event you can select resource view (icon under stack section) to see all collected SQL calls. Not a monitoring scenario, but a handy tip for diagnostics.
2) you can go to Performance tab and look under Response Time and Load vs Dependencies chart to see the list of external dependencies. Your SQL DB's will appear there and you will be able to learn how much time your code spends in a particular DB and overall call volume.