One of my clients (running Navision Attain 3.60 on SQL Server 2000) reported extremely slow update of their analysis view after adding a new dimension. Their database contains only some 90,000 G/L Entries but after adding the new dimension code and confirmed deletion of existing analysis views, a renewed update took roughly 20 hours (speed: 1 record/sec)!
I have made tests on a local SQL Server based on a Navision Backup from the client. This revealed that updating G/L Entries ran as expected but when it came to G/L Budget entries, the speed slowed down to 2 records/sec.
Tests on a native Navision Attain ran smoothly so the problem is exclusively related to SQL Server.
We have tried updating stats, recreating indexes and truncating the transaction log with no apparent effect.
Any hints would be greatly appreciated.