Trace flag 4136 can improve the performance in Dynamics AX--How to test that before and after the change

• Anjan Bhowmick

  Old Hand

  Points: 398

  More actions

  May 8, 2014 at 9:12 pm

  #288552

  Hi Friends

  I have 5 TB DB for AX.

  And I know parameter sniffing default behavior may cause seek to scan for parametrized stored procedures.

  And now I want to use T4136 flag to prevent this as per AX best practice.

  How do I test it in production server to show customers before and after the change.

  Regards,

  Anjan