For the first quest, to find a way to performance test SSAS Cubes via a tool or some other feature. Part of this quest is to find a way to get performance numbers that can be reviewed and then calculated easily. The idea is to get the current numbers and scale them appropriately for the larger machines or environments the SSAS Cube would sit on. Again if anyone out there has 2 cents to apply, please do!
Just a review of what I’ve found relating to performance tools:
The first thing I stumbled on was Mark Russo’s SSAS Performance Tools Blog Entry. In his blog entry he mentions the second thing I came upon, the MDX Script Performance Tool on Codeplex. This tool written by Chris Webb is discussed more on his blog entry MDX Script Performance Analyser.
There are also the multitude of links for the Analysis Services 2005 Performance Tuning White Paper, something that might add to what I’m looking for, but not automated for sure.
So far with all these tools I haven’t found a complete “performance estimation tool” that would fulfill the functions that I’m looking for. I suppose I’ll have to start building my own.