Application Insights - View SQL Query

I have a .NET 4.6.1 installation. I can see the SQL showing up as a dependency, but I would like to see the commands it executes in this way, we can take a look at what is taking the most time. Right now in the commands section, it just shows the FQDN for the SQL server.

Any help would be greatly appreciated.

+3


source to share


1 answer


Depends on what application you have and where it is deployed, but full instructions are here:

https://docs.microsoft.com/en-us/azure/application-insights/app-insights-asp-net-dependencies



Setting up dependency control

Partial dependency information of the automatically collected Insights SDK.

For complete details, install the appropriate agent for the host server.

  • IIS server. Either install Health Monitor on your server, or update your app to .NET 4.6 or higher and install the Insights App SDK in your app.

  • Azure Web App - In the web application dashboard, open the Application Insights vocabulary in the web app dashboard and select Install If prompted.

  • Azure Cloud Service - use a startup task or install .NET framework 4.6+

+1


source







All Articles