search

newrelic / nri-perfmon

Windows Perfmon / WMI On-Host Integration for New Relic Infrastructure
Other
13 stars 19 forks source link

ADO.net perf counters Application name not captured in the data sent to New Relic #32

Closed ravishankarmj closed 3 years ago

ravishankarmj commented 3 years ago

Nri-perfmon is installed on a windows server. ADO.net performance counter NETDataProviderforSqlServer Data is being sent to New Relic custom events. But the Name of the application is sent as alphanumeric value "190cbd3b-b5f8-4cf7-9c9b-516d38e37648" . There are multiple applications hosted on the IIS and also WCF windows hosting on the server. Only a single application data is captured and we are not sure which application it is as Name is captured as an alphanumeric value. Just to add: On my local machine application data is sent to New Relic correctly with the correct "Name" of the applications.

So how do we send multiple application data separately with Application names on the server?

Any help you can provide is appreciated

Config :

{ "provider": "NETDataProviderforSqlServer", "category": "NETDataProviderforSqlServer", "counters": [ { "counter": "*" } ] }

Thank you

sschwartzman commented 3 years ago

@ravishankarmj Taking a look at the NETDataProviderforSqlServer WMI object, "Name" is whatever is being set by the provider. Have you tried running the query at command line in PowerShell to see what data is coming to us?

This site both explains what counters are there, and offers a sample powershell script to execute: https://www.activexperts.com/admin/scripts/wmiscripts/powershell/1173/

sschwartzman commented 3 years ago

Closing due to inactivity. Please let me know if you need it reopened.