Kibana version: 8.13.2
Elasticsearch version: 8.13.2
APM Server version: 8.13.2
APM Agent language and version: dotnet
-
APM was installed on the site being serviced by IIS 10 and Profiler Auto instrumentation was applied.
-
Config Setting IIS
name="COMPlus_LoaderOptimization" value="1"
name="COR_PROFILER_PATH"value="C:\TEMP\APM\elastic_apm_profiler.dll
name="ELASTIC_APM_PROFILER_INTEGRATIONS" value="C:\TEMP\APM\integrations.yml"
name="ELASTIC_APM_PROFILER_HOME" value="C:\TEMP\APM"
name="COR_PROFILER" value="{FA65FE15-F085-4681-9B20-95E04F6C03CC}"
name="COR_ENABLE_PROFILING" value="1"
name="ELASTIC_APM_SERVER_URL" value="https://xxx.xxx.xxx.xxx:8200"
-
The http request is being viewed normally
-
BUT SQL command connected to the web service is not being viewed at all.
-
AND Trace Log Config
[2024-05-24T13:26:42.269259800+09:00] [TRACE] -> System.Data.CommandBehavior = System.Data.CommandBehavior
[2024-05-24T13:26:42.269264900+09:00] [INFO ] enqueue for ReJIT module_id=140733202783800, method_def=100669857, app_domain_id=2531742682912, domain_neutral=false, assembly=System.Data, type=System.Data.SqlClient.SqlCommand, method=ExecuteReader, signature=[32, 1, 18, 135, 32, 17, 130, 92]
[2024-05-24T13:26:42.269273100+09:00] [DEBUG] The caller for method_def ExecuteReader expected 2 arguments while integration has 1
[2024-05-24T13:26:42.269293200+09:00] [TRACE] comparing signature for method System.Data.SqlClient.SqlCommand.ExecuteDbDataReader
[2024-05-24T13:26:42.269299500+09:00] [TRACE] -> System.Data.CommandBehavior = System.Data.CommandBehavior
[2024-05-24T13:26:42.269304800+09:00] [INFO ] enqueue for ReJIT module_id=140733202783800, method_def=100669855, app_domain_id=2531742682912, domain_neutral=false, assembly=System.Data, type=System.Data.SqlClient.SqlCommand, method=ExecuteDbDataReader, signature=[32, 1, 18, 139, 196, 17, 130, 92]
[2024-05-24T13:26:42.269324800+09:00] [TRACE] comparing signature for method System.Data.SqlClient.SqlCommand.ExecuteScalarAsync
[2024-05-24T13:26:42.269330500+09:00] [TRACE] -> System.Threading.CancellationToken = System.Threading.CancellationToken
[2024-05-24T13:26:42.269335500+09:00] [INFO ] enqueue for ReJIT module_id=140733202783800, method_def=100669875, app_domain_id=2531742682912, domain_neutral=false, assembly=System.Data, type=System.Data.SqlClient.SqlCommand, method=ExecuteScalarAsync, signature=[32, 1, 21, 18, 134, 65, 1, 28, 17, 134, 73]
[2024-05-24T13:26:42.269355300+09:00] [TRACE] comparing signature for method System.Data.SqlClient.SqlCommand.ExecuteScalar
[2024-05-24T13:26:42.269360600+09:00] [INFO ] enqueue for ReJIT module_id=140733202783800, method_def=100669826, app_domain_id=2531742682912, domain_neutral=false, assembly=System.Data, type=System.Data.SqlClient.SqlCommand, method=ExecuteScalar, signature=[32, 0, 28]
Why doesn't SQL DEPENDENCY appear?