This project contains SQL Server Analysis Services samples contributed by Microsoft outside of the regular release cycle, MVPs, and other members of the community.
If you would like to contribute new Analysis Services samples to this site or make contributions to samples already posted,
Contact the Project Admin
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. Documentation and setup instructions can be found in the attached file "SSAS
Load Testing Best Practices - Draft v1.3b.zip"
- 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
- Powershell Scripts for SQL Server 2008 Analysis Services DMVs
- Scripts for creating and deleting a processing log file
- Compress M2M C# Application
- Methodology for Monitoring SSAS Using Profiler trace files, SSIS packages, stored procedures, and SSRS reports