监控数据库与应用程序调用启示

问题描述:

所以,我一直在读通过微软发布的应用程序洞察信息,特别是这篇文章:的https://azure.microsoft.com/en-gb/documentation/articles/app-insights-search-diagnostic-logs/

So I've been reading through the Application Insights information published by Microsoft, and in particular this article: https://azure.microsoft.com/en-gb/documentation/articles/app-insights-search-diagnostic-logs/

所以,我要问的是,什么是最合理的方法来记录数据库调用?

So what I want to ask is, whats the most logical methodology to log database calls?

在我的头上,我希望能够登录到应用程序的见解,看到的最常见的数据库调用出现了,看到他们的平均通话时间是什么。这样的话,我可以说哇查找到的会员资料表格的时间几秒钟的今天,这是怎么回事?

In my head, I want to be able to log into application insights, see the most common database calls being made, and see what their average call times are. That way, I can say "wow the lookup to the membership profile table is taking a few seconds today, what's the deal?"

所以我有一个数据库名,一个存储过程的名称,执行时间,什么是对我采取这一数据并将其存储在AI的最佳方式?作为一个指标,一个事件,别的东西?

So I have a database name, a stored procedure name, and an execution time, what's the best way for me to take that data and store it in AI? As a metric, an event, something else?

所有AI首先有依赖电话自动采集。请阅读这个。其次,计划下周发布SDK 1.1。作为该版本的一部分,在那里,你将有被监视S​​QL,HTTP,blob和其他外部依赖性特意加DependencyTelemetry类型。

First of all AI has dependency calls autocollection. Please read this. Secondly it is planned to release SDK 1.1 next week. As part of that release there you will have DependencyTelemetry type that is added specifically for monitoring SQL, http, blob and other external dependencies.