Unanswered: Analysis Service is slowing down the server
I am facing the following problem on SQL2K.
When I start the service the server slows down and users start complaining that generation of reports based on system (i.e. databases) that are hosted on the same server have REALLY slowed down... and thus I have to stop the service...
Can some please guide me regarding how to solve this problem and how I can be able to use the Analysis service.