Activity Viewer

Description: The Activity Viewer sample is a tool that displays users, connections, and processes for an instance of Microsoft SQL Server Analysis Services. You can use this tool to retrieve a list of these items and, if you want to, to stop a process.
The functionality similar to the SQL Server stored procedure sp_who and the kill command in Transact-SQL.

Includes: Readme, Visual Studio 2005 solution file

Contributors: Product sample by Edward Melomed, Migrated to community sample in 2008

Updates: None

Version support: This sample works only with SQL Server 2005 and SQL Server 2008. It will not work with any version of SQL Server earlier than SQL Server 2005.

Aggregation Manager

Description: Aggregation Manager is a sample application that lets you view, design, edit, and add aggregations based on the information collected in the query log.

Includes: Readme, Visual Studio 2005 solution file

Contributors: Product sample by Edward Melomed, Provided as community sample in 2008

Updates: This Aggregation Manager tool has been encorporated into BIDS Helper for SQL Server 2005, 2008, 2008 R2, and 2012. Many improvements and new features were added, too. http://bidshelper.codeplex.com/wikipage?title=Aggregation%20Manager&referringTitle=Documentation

Version support : Current solution file uses VS 2005.

ASCMD_StressTestingScripts

Description: The ASCMD command-line utility contains functionality for Analysis Services that resembles the sqlcmd utility included with SQL Server.
It enables a database administrator to execute an XMLA script, Multidimensional Expressions (MDX) query, or Data Mining Extensions (DMX) statement against an instance of Microsoft SQL Server Analysis Services.

Includes: Includes ASCMD.EXE , the command line utility for Analysis Services, and a number of scripts that can be run using ASCMD (.CMD. XMLA, MDX). The package also contains a number of queries (MDX) that can be used to simulate load.

Contributors: Carl Rabeler

Updates: None

Version support: Package last updated for 2008. Version of ASCMD is for Analysis Services 2008

Related samples or documentation: Documentation is available for ASCMD on MSDN: http://msdn.microsoft.com/en-us/library/ms365187(SQL.100).aspx

A description of how to install and use these tools has also been provided by Christo Olivier on this site: http://www.beeii.com/?p=466
Also contains white paper published as part of PROJECT REAL: “Using Visual Studio 2005 to Perform Load Testing on SQL Server 2005 Analysis Services”

ASLoadSim

Description: Describes how to perform performance analysis on SQL Server 2005, and provides code and scripts for configuring and running load tests.

Includes: Best practices white paper, Visual Studio 2005 solution file,
XMLA scripts, code for creating unit tests, and code and scripts for configuring and running load tests.

Contributors: Jaime Basilico, Dmitri Tchikatilov

Updates: None

Version support: Current solution file uses VS 2005.

Related samples or documentation: A description of how to install and use these tools has also been provided by Christo Olivier on this site: http://www.beeii.com/?p=466

Contains white paper published as part of PROJECT REAL: “Using Visual Studio 2005 to Perform Load Testing on SQL Server 2005 Analysis Services”

This project requires the ASQueryGen project.

ASQueryGen

Description: Describes how to perform performance analysis on SQL Server 2005, and provides code for configuring and running load tests.

Includes: Best practices white paper, Visual Studio 2005 solution file,
XMLA scripts, code for creating unit tests, and code and scripts for configuring and running load tests.

Contributors: Jaime Basilico, Dmitri Tchikatilov

Updates: None

Version support: Current solution file uses VS 2005.

Related samples or documentation: A description of how to install and use these tools has also been provided by Christo Olivier on this site: http://www.beeii.com/?p=466

This project requires the ASLoadSim project.

AS Trace

Description: The ASTrace utility runs as a Windows service that connects to Analysis Services and logs trace events into a SQL Server table using the SQL Server Profiler format.

Includes: The solution files required to build the service DLL. Documentation on how to set up and use the service.

Contributors: Product sample by Edward Melomed, Migrated to community sample in 2008

Updates: Updated by Greg Galloway for 2012.
Versions added for 2008, 2008 R2, and 2012 by Karan Gulati.
Updated version that allows monitoring multiple SSAS instances thanks to code from Andrew Calvett.

Version support : Version available for 2005, 2008, 2008 R2, and 2012.
The version of the utility must match the version of SSAs you intend to monitor.

Related samples or documentation: Included (Word 2010 document)

ASUV

Description: The Analysis Services Upgrade Verification Tool lets you compare Multidimensional Expressions (MDX) query results and performance between a Microsoft SQL Server 2000 Analysis Services database and a Microsoft SQL Server 2005 Analysis Services (SSAS) database. This tool helps you verify that your upgrade from SQL Server 2000 to SQL Server 2005 was successful.

Includes: Readme, Visual Studio 2005 solution file, internal help file (.CHM), sample MDX queries

Contributors: Product sample, Migrated to community sample in 2008

Updates: None

Version support : This sample works only with SQL Server 2005 and SQL Server 2008. It will not work with any version of SQL Server earlier than SQL Server 2005.

Related samples or documentation: Tool has its own help file.

CompressManyToMany

Description: This project creates a utility that enables you to easily implement the many-to-many compression technique discussed in the Analysis Services Many-to-Many Dimensions: Query Performance Optimization Techniques best practices white paper.
The application may be useful in cubes that have many to many relationships, resulting in poor query performance.

Includes: Visual Studio 2008 solution file

Contributors: Carl Rabeler, Greg Galloway

Updates: Updates to this functionality are available as part of a related project, BIDS Helper, which includes the ManyToMany Matrix tool, and has been updated for SQL Server 2010.
http://bidshelper.codeplex.com/wikipage?title=Many-to-Many Matrix Compression

Version support : Versions of the manyToMany matrix Tool for BIDS Helper available for 2005, 2008, and 2012. Versions of the ManyManyCompression utility available for 2005 and 2008.

Related samples or documentation: A description of the utility and its usage has been published here.
http://www.softcodedlogic.com/CompressManyToManyRelationships.htm

Download the original white paper from the SQL Server Best Practices web site at: http://technet.microsoft.com/en-us/sqlserver/bb671430.aspx
http://bidshelper.codeplex.com/wikipage?title=Many-to-Many Matrix Compression

CreateProcessingLog

Description: Provides two scripts that create/delete a system-wide processing log file. You can execute these scripts either interactively using SQL Management Studio or scheduled with SQL Agent.

Includes: Readme (.docx), Two XMLA scripts

Contributors: SQLCAT (Carl Rabeler)

Updates: None

Version support : The scripts should be compatible with later versions. You can update the headers if you need to use the scripts with later versions of Analysis Services.

Related samples or documentation: None

LoadTestReports

Description: Reporting Services reports that display the results of the load tests generated by the solutions, ASLoadSim and ASQueryGenerator.

Includes: Visual Studio 2005 solution file, Multiple Reporting Service reports (.RDL)

Contributors: RunYing Mao

Updates: None

Version support: Supports SQL Server 2008.

Related samples or documentation: A description of how to install and use these tools has been provided by Christo Olivier on this site: http://www.beeii.com/?p=466

Requires the database, LoadTest, which is created as part of the related projects, ASLoadSim and ASLoadGen.

ISSUES: There is an MSCONNECT bug open about the inability to reference DLLs for Analysis Services and for the ADOMD.NET client, which are used in this project, even when the DLLs are installed. The workaround is to manually browse to the location where the DLLs are installed.
https://connect.microsoft.com/VisualStudio/feedback/details/556584/unable-to-add-a-reference-to-microsoft-analysisservices-adomdclient-in-vs-net-2010

Reference	Location
Microsoft.AnalysisServices.DLL	C:\Program Files\Microsoft SQL Server\110\SDK\Assemblies
Microsoft.AnalysisServices.AdomdClient.dll	C:\Program Files\Microsoft.NET\ADOMD.NET\110

Monitoring SSAS

Description: Collection of scripts (T-SQL, CMD and XMLA) and Integration Services packages for collecting various kinds of information about an Analysis Services server.

Includes: Includes documentation, Database template (.bak file) and T-SQL scripts, XMLA scripts, ASCMD scripts, sample MDX queries, Integration Services packages, Reporting Services reports to display the information, Visual Studio 2008 solution file

Contributors: Carl Rabeler

Updates: 2009, Update for 2012 in progress

Version support: Current version 2008

Related samples or documentation: Includes the SQL Server 2008 Analysis Services Performance guide white paper

PowerShellScripts for SSAS DMVs

Description: A set of PowerShell scripts that use Dynamic Management Views (DMVs) to query real-time system information for administrative and other purposes.

Includes: Readme (Word .docx)

Contributors: SQLCAT

Updates: None

Version support : SQL Server 2008 Analysis Services
PowerShell scripts do not work on versions earlier than 2008; however, PowerShell scripts for SSAs are generally “forward-compatible”.
For more information, see http://msdn.microsoft.com/en-us/library/hh213141.aspx

Related samples or documentation: None

RssStyleSheet

Description: This file contains formatting definitions that can be applied to the solution, Monitoring SSAS. For example, these functions change the color of a counter when the value changes, etc.

Includes: Visual Studio 2005 solution file

Contributors: SQLCat

Updates: None

Version support : Current solution file uses VS 2005.

Related samples or documentation: Use with the sample, MonitoringSSAS, to enhance reports.

SSIS Package for Collecting SSAS DMV Data

Description: Use the included scripts to create an SSIS package that can be run by using SQL Agent. The package uses DMVs to extract information about an instance of Analysis Services and write it to a data collection server specified in the package.

Includes: Readme (.txt), Integration Services package (2008), T-SQL scripts for use in package, command scripts

Contributors: Carl Rabeler

Updates: None

Version support : SQL Server 2008

Related samples or documentation: Extracted from the sample, MonitoringSSAS. Can be used independently of the related samples.

SSAS Monitoring Scripts for Management Data Warehouse

Description: Use the included scripts to start and stop collection of data.

Includes: T-SQL scripts for use in package, command scripts

Contributors: Carl Rabeler

Updates: None

Version support: Created for 2008 but not version specific

Related samples or documentation: Extracted from the sample, MonitoringSSAS. Can be used independently of the related samples.
Scripts can also be used with sample, SSIS package for Collecting SSAS DMV data.

SSAS Helper

Description: Includes two projects:
SSAS Builder demonstrates how to create an SSAS database using an MSBuild task

SSAS Helper provides a library containing functions to help bridge the gap between Visual Studio 2008 files and AMO objects.

Includes: Two (2) Visual Studio 2008 solution files, Readme files (.mht) for each project

Contributors: Ddarden42

Updates: None

Version support : SQL Server 2008

Related samples or documentation: None

ResMon

Description: A series of XMLA scripts that create a cube used for storing SSAS monitoring information. You can then access this cube for analysis or to build dashboards.

Includes: XMLa scripts, Readme (.txt)

Contributors: Edward Melomed, Greg Galloway

Updates: Separate documentation for this download available at http://sqlsrvanalysissrvcs.codeplex.com/wikipage?title=ResMon%20Cube%20Documentation&referringTitle=Home

Version support : Originally developed for 2005. Scripts have been added to support 2008 and 2012.
Updated for 2012 by Furmangg

Related samples or documentation: Full documentation at http://sqlsrvanalysissrvcs.codeplex.com/wikipage?title=ResMon%20Cube%20Documentation