Hi all, When we are opening any dynamics ax forms like: sales order details form. realease purchase order details form, it is taking much time and after getting opened if we move cursors from one line to another line, it is getting hanged.
I checked sql server activity monitor, killed all suspending transactions.
I went Administrations->Periodic->sql administration and did indexing for all tables
restart all the servers like: application server, database server, etc, But still our dynamics performance is very slow.
You may want to use Dynamics AX Trace Parser to identify what’s wrong - if the problem is a poor customization in active() method or in network latency (just for example), it doesn’t make sense trying to fix indexes in database.
Of course, when you find that the problem is in slow queries, then it’s a good idea to check statistics, index fragmentation and such things.
Dear mirza mujib,
i followed your steps for some performance issues which mentioned above… am facing some problem after the re indexing… the problem is in journal voucher form if i can the date of one journal line means automatically its updating all the other lines with the same date… please can you help in this scenario…