Search Wiki:
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:


This release contains the following projects:

  • Compress M2M C# Application
  • Methodology for Monitoring Analysis Services (V2)
  • Script for Creating a Processing Log File
  • Powershell Scripts for Querying Analysis Services 2008 DMVs
  • AS Load Sim, including Load Testing Best Practices document
  • AS Query Generator
  • Load Test Reports
  • RSS Style Sheet
  • Activity Viewer
  • Aggregation Manager
  • AS Trace
  • Analysis Services Upgrade Verification Tool
Last edited May 19 at 7:27 PM  by carlrabeler, version 9
Comments
dmitrit wrote  Jun 15 2007 at 9:24 PM  
We are in the process of making some updates to the document describing the setup. Please stay tuned for the updates within next couple of days.

dmitrit wrote  Sep 15 2007 at 4:16 AM  
An updated version of Query Generator is released! It also includes sample query templates to test against Project REAL cubes. Query Generator randomizes queries on per file basis, rather than per-query basis to model more realistic browsing behavior and avoid returning empty result sets. Special thanks to RunyingM, EricJ and CarlR of the SQLCAT! Have fun! Stay tuned update on the documentation as well as query templates for Adventure Works.

garyf123 wrote  Feb 18 at 1:59 AM  
Is anyone working on this anymore.....? Nice code but it has many bugs...

JohnnyReaction wrote  Mar 14 at 4:17 PM  
Could we have a downloadable copy of AdventureWorksAS database for SQL Server 2005, please?

carlrabeler wrote  Mar 30 at 6:53 PM  
IMPORTANT: I found a bug in the SSIS packages for processing trace data related to MDX queries in the Methodology for Monitoring SSAS Using Profiler trace files, etc - will be posting a fix in a few days.
Carl

carlrabeler wrote  May 19 at 7:28 PM  
Methodology for monitoring Analysis Services updated to fix several bugs and replaced SSIS packages with T-SQL stored procedures.

Updating...