We are running NAV 2009 SP1. I am relatively new to NAV but have a reasonable knowledge of SQL. Basically I have dropped and rebuilt the indexes to reduce fragmentation. But now when a user tries to run the Analysis By Dimensions it is taking 30 seconds to load. You can see it drawing the grid and populating the data very slowly.
Does anyone have any suggestions why this would happen?
Apparently this has been running very slow for sometime now. The rebuild of the indexes has not improved it. You can see it takes an age to even draw the screen and the CPU is being hammered whilst this process is running by the SQL server exe.
Can you explain how the analysis by dimensions works? Does it collate data into temp tables and if so I may need to alter fill facter to a lower value?