Analysis Services Performance Testing and Artsy Things

I’m on a couple new quests as of this week.  One is to find a decent way to performance test SSAS without buying or putting in place large servers similar to what would be used in a production environment.  The second is to figure out how to have JavaScript or some code provide the timeline or time slice of a flash video that could be on my server or some other server embedded in my web page.

With the JavaScript and Flash needs, I’m at ground zero still.  Most of what I’ve looked at just doesn’t seem to work.  Silverlight could totally replace the need, but the request is for Flash.  @#$(^& Flash!!!!  Argh.  Anyone with any ideas, or know any good places to find information of Flash Video functionality, please let me know and post a comment.

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.

Another tool Chris Webb mention via his blog is the load testing tool.

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.