How can we improve Application Insights?

Please provide SQL monitoring for Application Insights

Please provide SQL monitoring

68 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Charles SterlingCharles Sterling shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
    completed  ·  Dale KoetkeAdminDale Koetke (Admin, Microsoft Visual Studio) responded  · 

    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.

    Thank you!

    2 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • Victor MushkatinVictor Mushkatin commented  ·   ·  Flag as inappropriate

        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.

      Feedback and Knowledge Base