Hi,
I am wondering if anyone has activated partitioning in SQL Server for Dynamics AX DB (/tables), I am thinking especially on large tables (GJAE / InventTrans / etc).
Our implementation is reaching it's billion (10^9) record shortly in GJAE (shortly followed by other tables), and we are starting to see this volume's strain on some of the functionalities; one example is the financial year closing, in relation to the volume of data in GJAE, as well as another being updating the dimension focus data.
I am curious how other implementations are handling this.
Thanks.