I've several cubes available for several users within my organization. I've the SQL Server 2005 and the Analysis Services running on the same machine but it has 30Gb of RAM, 8 processors and a quick enouth disk.
The problems is that i've some automatic processes that "build" some excel reports and the users use pivot tables with olap connections to the cubes regularly. I've noticed that the excel "locks" when the user is drilling down the data and the server has
only one processor (there are 8...) at 100%...
Is there a way to make the analysis services use the maximum processing capacity that is available? The users are complaining about the slowness of the cubes...
Thanks in advance
View Complete Post