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.
source to share
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+
source to share