Hi all

Is there any way by which we can perform the load test on OLAP cubes. My requirement is to understand the behavior of Analysis Services when the cubes are hit by say 10/ 50/ 75/ 100 users. Is there a tool by which I can simulate the scenario and test the load on OLAP server

Any help on this would be appreciated

Thank
Gomathi

When you say Load test I'm not sure what you mean....do you mean how much
pressure that is placed on As at a given time ?

It will depend a lot on the strucure of your cubes ... and the complexity in
your calculated members - if you have some.

http://www.microsoft.com/technet/pro.../ansvcspg.mspx

AS has some performance monitor tools which can be activated in the system
monitor on the server....just know that they exist - haven't dived that much
into them myself yet...but I will at some point.

http://msdn.microsoft.com/library/de...izing_976t.asp

If it's just because you need verification of what it can do...

http://www.mosha.com/msolap/tech.htm#Whitepapers

Check out t3 project...

\Michael Vardinghus

"GS" <anonymous (AT) discussions (DOT) microsoft.com> skrev i en meddelelse
news:90EB4B4D-DCB6-4B54-A4B2-599622BB9F43 (AT) microsoft (DOT) com...
cubes are hit by say 10/ 50/ 75/ 100 users. Is there a tool by which I can
simulate the scenario and test the load on OLAP server.