SQL Server 2005’s Analysis Services uses a process titled Msmdsrv.exe
The memory used by this process does not decrease as expected and results in error on deployment. The error usually is
“Server: The operation has been cancelled”
Memory utilization by Analysis Services increases when performing process operation, typically to the type of the object being processed.
a. Memory increase is approximately the size of the dimension plus Read-ahead and the process buffer settings for AS.
b. Returns to the pre-processing level, for pre-processed dims. For the first time processing, memory usage increases by size of dim that is loaded in the server memory space.
a. Memory increases by the size of the read-ahead and the process buffers.
b. Memory usage returns to pre-processing levels after processing completes.
This problem occurs when the memory usage of the Analysis Services Server (Msmdsrv.exe) does not return back to the pre-processing levels.
This issue can be resolved by deleting the unused databases and cubes that are saved. Also what helps is choosing the processing option as “Full” instead of Default. Default processing is usually incremental update and when the file store of the attributes reach 4GB, error message are issued while processing cubes/dimensions in AS.
Possible HotFix :
It is safer to retain just the databases and cubes that are currently being used and avoid unnecessary data dumps. Also, though incremental processing is fast, Full processing done saves memory usage