Everyday I face performance issues on Navision. I've read some posts about fragmentation and tried to look for it on the SQL Server Navision Database.
My major issues are on the Warehouse entries and Item ledger entries tables. Every single day most of all keys have fragmentations over 70% or 80%, and for what i've read that is way over normal.
To get Navision a bit faster I make table Optimization, on my Navision client, and right after that the fagmentation goes below 1%, but if I wait for 2 or 3 hours the fragmentation of those tables goes up to 50% again.
Is there anything I can do to get solve this?
Thank you in advance!