azure-application-insights - 应用程序见解-查看SQL查询

Question

我有一个.NET 4.6.1设置。我能够看到SQL显示为依赖项，但我想查看它正在以这种方式执行的命令，我们可以看看花费最多的时间。现在在命令部分，它只是显示sql服务器的FQDN。

任何帮助将不胜感激。

Answer 1

取决于您拥有的应用程序类型和部署位置，但是完整的说明在这里:

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+