Question: How do we send SQL queries? about applicationinsights-ruby HOT 7 CLOSED

There are multiple telemetry types as defined in the contract classes, all of them support properties which are custom defined, that is, you define the property and responsible for tracking its value.

from applicationinsights-ruby.

@jngli thank you, we'll try sending SQL data using this and setting it to 3

Our goal is to make sure the SQL metrics show up here:

We also weren't sure if SQL metrics could include SQL-specific things like Time + Query (we can include them as custom properties.)

from applicationinsights-ruby.

The rdd (RemoteDependencyData) is not officially supported by Ruby SDK yet, not exposed directly via TelemetryClient. You could manually create an rdd and send to AI using the telemetry channel, what you've done I think. However there are two issues while processing rdd:

1. The dependency kind is not processed correctly and got addressed recently with a schema change but not updated in Ruby SDK yet.
2. The rdd would be ignored if ai.device.id is not specified which would be fixed in the server side in the near future.

You can work around the above issues with following changes:

1. rdd.dependency_kind = 0 # SQL should be set to 0
2. tc.context.device.id = "1" # explicitly set device id

What do you mean by 'Time', the time stamp making the sql query, execution time, or something else? For query, yes, you can use the custom property to track it.

Thanks,
Jing

from applicationinsights-ruby.

@jngli exactly — the SQL query execution time.

Thank for all the other info, btw.

from applicationinsights-ruby.

The 'value' field is supposed to use for tracking execution time (i.e., dependency duration used in UI).

from applicationinsights-ruby.

@jngli ok perfect, thank you!

from applicationinsights-ruby.

@dkullmann the sdk is updated with latest schema where the dependency kind issue should be fixed.

from applicationinsights-ruby.