Microsoft SQL Server Community Samples: Analysis Services

UPDATED RELEASE: Analysis Services Community Samples (May 19, 2008)

Fri, 18 Jul 2008 21:30:44 GMT

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

edwardm — Fri, 18 Jul 2008 01:35:36 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

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 RELEASE: Analysis Services Community Samples (May 19, 2008)

Fri, 18 Jul 2008 01:34:44 GMT

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

New Post: Performance impact of Methodology for Monitoring Analysis Services (V2)

adillow — Wed, 11 Jun 2008 13:36:30 GMT

Is the trace file Methodology for Monitoring Analysis Services (V2) meant to be run 24x7, or does the trace have too much of a negative impact on the performance of Analysis Services?

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

CREATED RELEASE: Analysis Services Community Samples (May 19, 2008)

Mon, 19 May 2008 19:25:09 GMT

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 RELEASE: SQL CAT BP Team Release

Mon, 19 May 2008 19:14:59 GMT

This release contains four new 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

This release contains the four projects related to Analysis Services load testing
* AS Load Sim, including Load Testing Best Practices document
* AS Query Generator
* Load Test Reports
* RSS Style Sheet
This release also contains the following four Analysis Services tool samples
* Activity Viewer
* Aggregation Manager
* AS Trace
* Analysis Services Upgrade Verification Tool

Source code checked in

carlrabeler — Mon, 19 May 2008 19:07:38 GMT

Source code checked in

carlrabeler — Mon, 19 May 2008 19:06:33 GMT

Source code checked in

carlrabeler — Mon, 19 May 2008 18:56:27 GMT

Source code checked in

carlrabeler — Mon, 19 May 2008 18:50:05 GMT

UPDATED RELEASE: SQL CAT BP Team Release

Mon, 19 May 2008 18:23:40 GMT

This release contains four new projects:
* Compress M2M C# Application
* Methodology for Monitoring Analysis Services
* Script for Creating a Processing Log File
* Powershell Scripts for Querying Analysis Services 2008 DMVs

This release also contains the four projects related to Analysis Services load testing
* AS Load Sim, including Load Testing Best Practices document
* AS Query Generator
* Load Test Reports
* RSS Style Sheet

CREATED ISSUE: ASTrace IA64, X64

edwardm — Fri, 04 Apr 2008 17:49:14 GMT

Problem reported with AS trace on IA64 and x64 platforms
Environment:
======================
1.　Windows2003 ENT ENU
2.　DEV ENU 09.00.3033.00

Repro Steps:
======================
1. Build ASTrace.sln.
2. Create a folder named ASTrace under folder "C:\Program Files\Microsoft SQL Server\MSSQL.1"
3. Copy the files "ASTrace.exe.config" and "Standard.tdf" from the default sample installed folder "C:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\Administrator\ASTrace" to the folder ASTrace created in step1. The copy ASTrace.exe (The size of this file is 24KB.) from the debug folder to the folder ASTrace created in step1.
4.Open a Visual Studio 2005 Command Prompt, CD to "C:\Program Files\Microsoft SQL Server\MSSQL.1\ASTrace".
5.Execute the following command:
InstallUtil.exe ASTrace
6.Keey the properties of ASTrace.exe.config file as default.
7.Open Windows Service Control Manager and navigate to ASTrace, then start it.

Expectations:
======================
1.The ASTrace service should be started without error and after that the status ASTrace service displayed in Windows Service Control Manager shoulde be "Started".
2.Table "ASTraceTable" should be created in database "AdventureWorksDW".

Actual Results:
======================
1.Failed to start ASTrace service. Warning message provided by Windows Service Control Manager

Source code checked in

ReedMe — Thu, 03 Apr 2008 16:50:27 GMT

Initial commit for migration of ASTrace, ASUV, ActivityViewer and AggregationManager from product samples to community samples.

Source code checked in

carlrabeler — Wed, 26 Mar 2008 17:51:12 GMT

Added support for relative pathing

Source code checked in

carlrabeler — Wed, 26 Mar 2008 17:49:08 GMT

Source code checked in

carlrabeler — Wed, 26 Mar 2008 17:45:45 GMT

Get Size for All Databases in Analysis Services instance

NEW POST: Script CancelAllQueries.ps1 has hardcoded script path inside

carlrabeler — Wed, 26 Mar 2008 15:41:02 GMT

Yes, if you execute the powershell script from within the c:\scripts folder. However, if you execute the powershell script from another location using an absolute path to refer to the script you wish to execute, the relative pathing will fail - unless you use the Set-Location command in the script. For example, Set-Location C:\Scripts - add this to the beginning of the CancelAllQueries.ps1 script - you can then use relative pathing.
HTH
Carl

NEW POST: Getting error while executing PowerShell script

carlrabeler — Wed, 26 Mar 2008 15:23:12 GMT

I know - sorry for the confusion. Will be fixed.

NEW POST: Getting error while executing PowerShell script

vidas_m — Wed, 26 Mar 2008 01:37:19 GMT

Single quotes works! Thank you.

By the way, examples at the top of this file use double quotes, that is what confused me.

Thanks again

Vidas Matelis