App Insights不收集在云服务上运行的Web应用程序的SQL命令文本 [英] SQL Command text is not collected by App Insights for web app running on Cloud Service
本文介绍了App Insights不收集在云服务上运行的Web应用程序的SQL命令文本的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
跟随standard installation guide from Microsoft
- 已选中角色属性中的"将诊断数据发送到应用程序洞察",并已将应用程序发布到CS-未收集任何请求数据。
- 将SDK添加到项目中,并重新上传APP-GET请求数据,但所有SQL依赖项都是用完全无用的"命令文本"--"服务器名|数据库名"收集的。
但是,如果安装了Azure状态监视器,则在我的本地IIS上跟踪同一应用的SQL命令。
我通过RDP连接到服务器,似乎Azure PaaS诊断插件已成功安装AI状态监视器,但未注册为W3SVC的COR_PROFILER,因此它实际上什么也不做。
是否存在用于启用云服务的完整SQL命令跟踪的特定配置开关?
sdk
启用推荐答案向应用程序洞察发送诊断数据并将sdk添加到项目应该就足以收集依赖项数据。
但是,Azure云服务PaaS诊断插件v1.10.1.1中包含的状态监视器的当前安装程序已损坏。我尝试了以前版本插件(v.1.10.0.0)中的安装程序--它工作得很好。
从最新版本的插件运行StatusMonitor orApplicationInsightsAgent.msi会记录以下异常:
Calling custom action CustomActions!CustomActions.CustomActions.SetEnvironmentVariables
Error: could not load custom action class CustomActions.CustomActions from assembly: CustomActions
System.IO.FileLoadException: Could not load file or assembly 'CustomActions, Version=2.4.0.18059, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. Strong name validation failed. (Exception from HRESULT: 0x8013141A)
File name: 'CustomActions, Version=2.4.0.18059, Culture=neutral, PublicKeyToken=31bf3856ad364e35' ---> System.Security.SecurityException: Strong name validation failed. (Exception from HRESULT: 0x8013141A)
我解压了CustomActions.dll,并通过sn检查了它的强名称。
sn.exe -vf CustomActions.dll
CustomActions.dll is a delay-signed or test-signed assembly
对v1.10.0.0中的CustomActions.dll进行的相同检查显示
Assembly 'CustomActions.dll' is valid
显然,MS中的某人在发布之前忘记了签署该DLL,因此状态监视器不再正确安装在CS VM上。已向微软支持部门报告,希望他们能尽快修复。
解决方法可能是在角色启动时手动添加缺少的注册表项,而W3SVC尚未启动:
HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesW3SVC@Environment
具有值的多字符串值类型
COR_ENABLE_PROFILING=1
COR_PROFILER={324F817A-7420-4E6D-B3C1-143FBED6D855}
MicrosoftInstrumentationEngine_Host={CA487940-57D2-10BF-11B2-A3AD5A13CBC0}
原始注册文件为:
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesW3SVC]
"Environment"=hex(7):43,00,4f,00,52,00,5f,00,45,00,4e,00,41,00,42,00,4c,00,45,
00,5f,00,50,00,52,00,4f,00,46,00,49,00,4c,00,49,00,4e,00,47,00,3d,00,31,00,
00,00,43,00,4f,00,52,00,5f,00,50,00,52,00,4f,00,46,00,49,00,4c,00,45,00,52,
00,3d,00,7b,00,33,00,32,00,34,00,46,00,38,00,31,00,37,00,41,00,2d,00,37,00,
34,00,32,00,30,00,2d,00,34,00,45,00,36,00,44,00,2d,00,42,00,33,00,43,00,31,
00,2d,00,31,00,34,00,33,00,46,00,42,00,45,00,44,00,36,00,44,00,38,00,35,00,
35,00,7d,00,00,00,4d,00,69,00,63,00,72,00,6f,00,73,00,6f,00,66,00,74,00,49,
00,6e,00,73,00,74,00,72,00,75,00,6d,00,65,00,6e,00,74,00,61,00,74,00,69,00,
6f,00,6e,00,45,00,6e,00,67,00,69,00,6e,00,65,00,5f,00,48,00,6f,00,73,00,74,
00,3d,00,7b,00,43,00,41,00,34,00,38,00,37,00,39,00,34,00,30,00,2d,00,35,00,
37,00,44,00,32,00,2d,00,31,00,30,00,42,00,46,00,2d,00,31,00,31,00,42,00,32,
00,2d,00,41,00,33,00,41,00,44,00,35,00,41,00,31,00,33,00,43,00,42,00,43,00,
30,00,7d,00,00,00,00,00
这篇关于App Insights不收集在云服务上运行的Web应用程序的SQL命令文本的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文