Dot net Depency Problem

Elastic Observability APM
1

Kibana version: 8.13.2
Elasticsearch version: 8.13.2
APM Server version: 8.13.2
APM Agent language and version: dotnet

  1. APM was installed on the site being serviced by IIS 10 and Profiler Auto instrumentation was applied.

  2. 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"

  1. The http request is being viewed normally

    image
    image1623×640 57.4 KB

  2. BUT SQL command connected to the web service is not being viewed at all.

    image
    image1125×360 10.2 KB

  3. 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?