Printable View
msmdsrv.exe is consuming almost 99% of my cpu and ram. i have a data cube in ssas with more than 40 partitions (monthwise). All the partitions for history data are set as MOLAP and the current one as ROLAP.
When I test the performance with sql profiler, the cubes are being processed even if the application is not started!!
Pls guide how to fix this up to free some cpu for other processes.
nobody??!! :(
This might help.
http://msdn.microsoft.com/en-us/libr...ys_performance
Disappointment continues...
What I observed in SQL Server Mgmt Studio is that the no. of logins for NT AUTHORITY keeps on increasing. I checked this in Activity Monitor as well as with sp_who stored procedure. This login is basically used by all the windows services...in this case it is Analysis Service.
What I fail to understand is why are the cubes being processed even though there's no updation on the database!!!????