O'Reilly logo

Microsoft Dynamics AX 2012 R2 Administration Cookbook by Simon Buxton

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Configuring Dynamics AX SQL tracing

If a user wishes to report a specific performance issue, there are a range of options available to us.

The following traces should be done for a specific time window and coordinated with the user who is reporting a performance problem (for example, searching for a customer and posting an invoice). Collection of the traces will add a load to the system; so, it should be done for a limited time—long enough to capture the data but short enough to limit the potential impact on other users.

Getting ready

To set up this configuration, you will need to launch the AX client as a system administrator.

To perform investigation work in SQL Server Management Studio, you will also need:

  • The VIEW SERVER STATE permission
  • One of ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required