Application Insights - View SQL Query

Question

I have a .NET 4.6.1 setup. I am able to see SQL show up as a dependency but I'd like to view the commands it's executing to this way we can take a look at what's taking the most time. Right now in the command section, it's just showing the FQDN for the sql server.

Any help would be greatly appreciated.

Answer 1

Depends on what kind of app you have and where it is deployed, but the full instructions are here:

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

Set up dependency monitoring

Partial dependency information is collected automatically by the Application Insights SDK.

To get complete data, install the appropriate agent for the host server.

• IIS Server - Either install Status Monitor on your server or Upgrade your application to .NET framework 4.6 or later and install the Application Insights SDK in your app.

• Azure Web App - In your web app control panel, open the Application Insights blade in your web app control panel and choose Install if prompted.

• Azure Cloud Service - Use startup task or Install .NET framework 4.6+