none
How Application Insight can add value to an IaaS SQL Server development?

    Question

  • Hi All,

    I am developing a system that leverages an IaaS SQL Server instance. I wonder how Application Insight can add value to the database development aspect of a database project?

    I can think of the following items, and I wonder how feasible are the items below:

    1.       Stored Procedures can add log entries to App Insight
    2.       App Insight agent monitors the health of the host windows server
    3.       App Insight agent monitors the health of the database server
    4.       App Insight agent monitors the performance of the database server
    5.       App Insight agent monitors the timing of queries and stored procedure calls

    Thank you,

    Tuesday, May 24, 2016 4:32 PM

Answers

  • Application Insights is InProc monitoring solution. You need to have an application to which you add instrumentation which than gets redirected to ApplicationInsights backend. I do not think that this is applicable to any scenarios you describe. Consider taking a look at Azure Ops Insights.


    Anastasia

    Thursday, May 26, 2016 10:44 PM
    Moderator