Rob Kerr has just released what looks like an extremely useful tool on Codeplex to do load testing on SSAS: AS Performance Workbench. Check it out here:
http://asperfwb.codeplex.com/
I can see that I’ll be using this a lot…
AS Performance Workbench
Published
Chris I need to be in contact with you with regards to a mutual friend; Hans who recently came back to SA after a long time overseas. Drop us a mail
Cheers
David
Hi David,
You can find my contact details at http://www.crossjoin.co.uk
Chris
Hi Chris,
we are facing difficulty to connect SSAS 2014 server.Application get crash when we try to connect SSAS 2014 . My question here is that doesn’t it support SSAS 2014 server. It was working fine for SSAS 2008 server. will appreciate your help and waiting for your expert suggestions.
I don’t know whether it supports SSAS 2014, sorry. Have you tried contacting the authors?
Hi Chris,
execuse me that I post my question here, since I don’t have the contact info of the authors, Rob Kerr, who developed asperfwb.
I downloaded asperfwb from codeplex
https://archive.codeplex.com/?p=asperfwb
and unzipped it on my local machine. There are some folders, with some json files inside. But I didn’t find .exe or some other installation files. How can I install it? As you said, this tool is very helpful for stress test on Cube. I would like to use it.
I am looking forward you reply.
Thanks.
best regards,
Chunyan
I’m sorry, I don’t have the contact information for Rob either. It’s an old tool and I’m not even sure it would work with recent versions of Analysis Services.
Hi Chris,
Thanks for your reply. ASPerfWB is indeed one old tool. But it sounds useful for stress test of cube. It might be obsolete for the recent version. Could you please recommend some other similar tools for stress test?
Best regards,
Chunyan
Lots of good information here: https://sqlbits.com/Sessions/Event10/Load_Testing_Analysis_Services