Working with large analysis services customer we found some complaints that users have to wait an additional 20-60 seconds to run basic reports on top of the usual time to warm up the calculation script. The slow down only happens on a cold server restart, or if the service is shut down and disk un-mounted … Continue reading Anatomy of Analysis Service Startup
Tag: SSAS
We all know that Analysis Services uses the windows file system cache when querying, but how does it use the file system write cache when processing dimensions and measure groups? I couldn't find much information in the will, so opened up the wonderful process monitor tool from sysinternals to check it out. As background you'll need to … Continue reading Does Analysis Services use the System Cache when Processing ?