CODEWITHSUNDEEP
azure-application-insights
Kishore Gunalan
Kishore Gunalan

Reputation: 41

Application Insights - Unable to view SQL Query

I have hosted an ASP.NET MVC application and configured Application Insight. All HTTP calls and SQL dependencies are logged in a text file. But, I am unable to log/get the SQL queries via Application Insight "commandName" parameter.

Can someone help me on this, please.

  1. Application Insight without Azure account.
  2. To get the SQL queries, do I need to install any profilers ?

Upvotes: 4

Views: 1404

Answers (1)

cijothomas
cijothomas

Reputation: 3126

If your application is hosted on Azure Web Apps, install Application Insights Extension. If hosted on any other VM, install Status Monitor on that VM. Then restart the application, and you should start seeing full SQL queries in Dependency command.

https://learn.microsoft.com/en-us/azure/application-insights/app-insights-monitor-performance-live-website-now

Upvotes: 3

Related Questions