Microsoft Dynamics NAV Performance Metrics

This dashboard collects all 31x “performance counters” that is available for Microsoft Dynamics NAV via performance collector objects in Microsoft Windows. These are the metrics you can see in the “perfmon” tool in Windows. Now you can see it in style in Grafana and better yet over a longer period of time.

The Grafana template uses the Telegraf client to pull performance metrics via the inputs.win_perf_counters.object. Example Telegraf input plugin configuration is attached in this template post.

Features:

1. Variables setup for “selected_host”, “selected_instance” allow you to select what host and which Dynamics instance to monitor.
2. Variable for “Sampling Interval” allows you to smooth the curve to the best sampling rate.

Steps to get going:

1. Create an InfluxDB named “dynamics_monitoring_results”
2. Install Telegraf Windows client on your server. (see many other blog posts about this)
3. Set your agent to measure every 1min.
4. Configure your Telegraf client to capture the Dynamics performance counters (details in Collector Config section)
5. Make sure you set your input agent to save to a metric called “ms_dynamics_nav” this will be the metric name in InfluxDB and Grafana: ( Measurement = “ms_dynamics_nav” )
6. Test your Telegraf config with console mode, debug and command line output (in influxdb format) before starting it as a service. For example: “c:\Program Files\telegraf\telegraf.exe” –console –debug –config “c:\Program Files\telegraf\telegraf.conf”
7. Run your Telegraf client as a service. (see many other blog posts about this)
8. When you import this template, select the datasource that you created in step 1.

Start watching your Dynamics instances.

Note: This dashboard was tested with Microsoft Dynamics NAV 2017.