Analysis Services Load Simulator
This project contains SQL Server Analysis Services samples contributed by Microsoft outside of the regular release cycle, MVPs, and other members of the community.
Samples on this site include:
The sample code (Analysis Services Load Simulator aka ASLoadSim) contains a set of utilities used to generate a query load and test the scalability of Analysis Services server.
- ASQueryGenerator: console application to generate XML files with MDX queries to be used by the ASLoadSim library
- ASLoadSim: main library used by the Visual Studio for Testers to generate the MDX query load for Analysis Services server
- LoadTestReport: Reporting Services project to review the results of the simulation (logged to a SQL Server database)
- RssStyleSheet: auxilary file to be used by reporting services to define the report format
Documentation and setup instructions can be found in the attached file "SSAS Load Testing Best Practices - Draft v1.3b.zip"
More information : here
Download & Documentation : here
Have Fun
