Our application has slowed to a complete standstill. Hopefully someone can help us as any ax client work is becoming quite impossible.
What we found most interesting was that on one of our forms it can take 20+ seconds to browse the data grid. This datagrid is connected to the a table in the database with only 6000 records.
We do have other tables with 22+ million records but obviously this isn’t the same table above. Please let us know any fundemental problems we may be overlooking.
You have not mentioned hardware, version of SQL server / AX etc. You need someone capable to investigate all potential issues that could cause performance degradation and resolve them.