Tip of preventing the App.Tier (MSMDSRV.EXE) from using all the resources!

Question

I just wanted to share what I found according to CPU usage by MSMDSRV.EXE.

By default the Warehouse was designed to run processing every hour, but the Demo is set by default to every other minute. The link below shows you how to change it.


http://blogs.msdn.com/buckh/archive/2005/04/19/409886.aspx


It's already mentioned on the forum here as well

http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=3063


After this, my labserver averages about 10-11% instead of 55-60% of CPU usage.