Microsoft Dynamics AX 2012 R2 Administration Cookbook

Setting up Dynamics AX and SQL server counters

Along with tracing of the SQL statements, the state of AX and SQL Server instances is also important.

This recipe will show you how to set up Windows Server performance counters that can be used to identify a performance problem and should be coordinated with other performance tracing tools.

Getting ready

Log in to Windows with local administrator privileges on the local computer and the AX Server.

How to do it...

To create Windows performance counters, follow these steps:

1. Open Performance Monitor (navigate to Start | Run and enter PerfMon or search for Performance Monitor).
2. Click on the Performance Monitor node in the left-hand tree.

   Note

   CPU will already be added for your local machine, but we need to add ...