Memory usage

[Murlivelage]

I need a query to find Memory usage more than 90 percent by hostname

is it a good idea to do in splunk vs app dynamics

[tscroggins]

If your Splunk environment is properly configured, you can find memory usage with this:

tag=performance tag=memory
| stats max(eval(100*mem_used/mem)) as mem_used_percent by host
| where mem_used_percent>90

This isn't the best place to discuss AppDynamics, but you can use the machine agent to collect basic hardware metrics, reports to display them, and health rules to alert on them. Extended metrics require a Server Visibility license.