locked
Can i use application insight for query monitoring for Sql server on virtual machine RRS feed

  • Question

  • can we use application insight for monitoring sql queries on sql server vm

    sharma priya

    Wednesday, May 13, 2020 7:19 AM

All replies

  • Hello Priya, 

    Thanks for reaching out to us. 

    Yes, you can use Application Insights for Monitoring Sql Queries by setting the following : 

    Grant modify access to IIS_IUSRS group for these paths:

    %WINDIR%\Temp
    %WINDIR%\System32\config\systemprofile\AppData\Local


    Then, Application Insights  will start to record SQL queries.

    You also can do this via the command line:

    icacls %WINDIR%\Temp /t /c /grant IIS_IUSRS:(OI)(CI)M
    icacls %WINDIR%\System32\config\systemprofile\AppData\Local /t /c /grant IIS_IUSRS:(OI)(CI)M

    Also take a look at this thread for more info - AI Tracking SQL Queries

    I hope this information helps.

    If the above response helped, Please "Mark as Answer" and "Upvote"  the same. 

    Wednesday, May 13, 2020 1:07 PM