SQLSrvAnalysisSrvcs Wiki & Documentation Rss Feed

Updated Wiki: Home

ddarden42 — Mon, 16 Nov 2009 16:59:04 GMT

Samples on this site include:

This release contains the following projects:

Compress M2M C# Application
A Solution for Collecting Analysis Services Performance Data for Performance Analysis - Updated 3/6/09 to simplify install and use
Scripts for Using ASCMD for Stress Testing - Updated 2/23/09
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
SSIS Package For Collecting SSAS DMV Data
SSAS Monitoring Scripts For Management Data Warehouse
SsasHelper - Work with Visual Studio SSAS Projects using AMO, sample MSBuild task to build a SSAS project

Updated Wiki: Home

ddarden42 — Fri, 18 Sep 2009 20:09:35 GMT

Samples on this site include:

This release contains the following projects:

Compress M2M C# Application
A Solution for Collecting Analysis Services Performance Data for Performance Analysis - Updated 3/6/09 to simplify install and use
Scripts for Using ASCMD for Stress Testing - Updated 2/23/09
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
SSIS Package For Collecting SSAS DMV Data
SSAS Monitoring Scripts For Management Data Warehouse
SsasHelper - Work with Visual Studio SSAS Projects using AMO

Updated Wiki: Home

carlrabeler — Fri, 06 Mar 2009 22:23:07 GMT

Samples on this site include:

This release contains the following projects:

Compress M2M C# Application
A Solution for Collecting Analysis Services Performance Data for Performance Analysis - Updated 3/6/09 to simplify install and use
Scripts for Using ASCMD for Stress Testing - Updated 2/23/09
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
SSIS Package For Collecting SSAS DMV Data
SSAS Monitoring Scripts For Management Data Warehouse

Updated Wiki: Home

carlrabeler — Fri, 27 Feb 2009 20:58:00 GMT

Samples on this site include:

This release contains the following projects:

Compress M2M C# Application
A Solution for Collecting Analysis Services Performance Data for Performance Analysis - Updated 2/27/09
Scripts for Using ASCMD for Stress Testing - Updated 2/23/09
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
SSIS Package For Collecting SSAS DMV Data
SSAS Monitoring Scripts For Management Data Warehouse

Updated Wiki: Home

carlrabeler — Tue, 24 Feb 2009 17:51:30 GMT

Samples on this site include:

This release contains the following projects:

Compress M2M C# Application
A Solution for Collecting Analysis Services Performance Data for Performance Analysis - Updated 2/23/09
Scripts for Using ASCMD for Stress Testing - Updated 2/23/09
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

Updated Wiki: Home

carlrabeler — Fri, 06 Feb 2009 00:22:18 GMT

Samples on this site include:

This release contains the following projects:

Compress M2M C# Application
A Solution for Collecting Analysis Services Performance Data for Performance Analysis
Scripts for Using ASCMD for Stress Testing
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
AS Validate Users

Updated Wiki: Home

edwardm — Fri, 18 Jul 2008 01:35:36 GMT

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
AS Validate Users

UPDATED WIKI: Home

carlrabeler — Mon, 19 May 2008 19:27:21 GMT

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

UPDATED WIKI: Home

carlrabeler — Mon, 24 Mar 2008 19:31:01 GMT

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

UPDATED WIKI: Home

carlrabeler — Mon, 24 Mar 2008 19:27:33 GMT

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"

UPDATED WIKI: Home

carlrabeler — Mon, 24 Mar 2008 19:26:52 GMT

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"

UPDATED WIKI: Home

nuanw — Fri, 20 Apr 2007 16:50:23 GMT

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"

UPDATED WIKI: Home

dmitrit — Thu, 19 Apr 2007 06:08:37 GMT

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

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.

Samples on this site include:

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"

UPDATED WIKI: Home

dmitrit — Thu, 19 Apr 2007 06:01:37 GMT

Samples on this site include:

ASQueryGenerator - console application to generate XML files with MDX queries
ASLoadSim - library used by 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 - auxiliry file to be used by reporting services to define the report format

UPDATED WIKI: Home

nuanw — Wed, 18 Apr 2007 17:38:06 GMT