Microsoft SQL Server Community Samples: Analysis Services

Updated Release: Analysis Services Community Samples-February, 2009 (Feb 27, 2009)

ddarden42 — Mon, 16 Nov 2009 17:04:19 GMT

This release contains the following projects:

Activity Viewer
Aggregation Manager
ASCMD Stress Testing Scripts - Updated 2/23/09 to support Database name different from DatabaseID
AS Load Sim, including Load Testing Best Practices document
AS Query Generator
AS Trace
Analysis Services Upgrade Verification Tool
Compress M2M C# Application
Script for Creating a Processing Log File
Load Test Reports
A Solution for Collecting Analysis Services performance data from multiple sources (MonitoringSSAS.zip) - Updated 3/31/09 to fix one additional named instance bug
Powershell Scripts for Querying Analysis Services 2008 DMVs
RSS Style Sheet
SSIS Package For Collecting SSAS DMV Data - added 2/27/2009 (extracted from MonitoringSSAS solution)
SSAS Monitoring Scripts For Management Data Warehouse - added 2/27/2009 (extracted from MonitoringSSAS solution) - Updated to fix bug - named instance counters for SSAS must be entirely in capital letters
SsasHelper

Released: Analysis Services Community Samples-February, 2009 (Feb 27, 2009)

Mon, 16 Nov 2009 17:04:19 GMT

This release contains the following projects:

Activity Viewer
Aggregation Manager
ASCMD Stress Testing Scripts - Updated 2/23/09 to support Database name different from DatabaseID
AS Load Sim, including Load Testing Best Practices document
AS Query Generator
AS Trace
Analysis Services Upgrade Verification Tool
Compress M2M C# Application
Script for Creating a Processing Log File
Load Test Reports
A Solution for Collecting Analysis Services performance data from multiple sources (MonitoringSSAS.zip) - Updated 3/31/09 to fix one additional named instance bug
Powershell Scripts for Querying Analysis Services 2008 DMVs
RSS Style Sheet
SSIS Package For Collecting SSAS DMV Data - added 2/27/2009 (extracted from MonitoringSSAS solution)
SSAS Monitoring Scripts For Management Data Warehouse - added 2/27/2009 (extracted from MonitoringSSAS solution) - Updated to fix bug - named instance counters for SSAS must be entirely in capital letters
SsasHelper

Updated Wiki: Home

ddarden42 — Mon, 16 Nov 2009 16:59:04 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
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

Source code checked in, #29416

ddarden42 — Mon, 16 Nov 2009 16:55:12 GMT

Added sample MSBuild task, minor refactoring.

Created Issue: ssas.SSASCleanBatch looks to have bug. [10929]

opoudel — Thu, 12 Nov 2009 16:45:12 GMT

ssas.SSASCleanBatch procedure has where criteria as P_BatchID <= @BatchID in order to get rid of all the old batches. Should not that be P_BatchID < @BatchID?

New Post: Problem Installing SSAS Monitoring App

opoudel — Thu, 12 Nov 2009 16:43:09 GMT

In order to make it work you need to change WHERE P_BatchID <= @BatchID to WHERE P_BatchID < @BatchID to get rid of all batches before current batch.

Source code checked in, #29279

ddarden42 — Fri, 06 Nov 2009 07:13:12 GMT

Removed an unnecessary, but possibly confusing, line of code from the ValidateDatabase method.

Source code checked in, #29247

ddarden42 — Wed, 04 Nov 2009 00:45:31 GMT

Added a method to validate a SSAS Database. The method will return a true/false if there are errors, as well as returning the result collection.

New Post: Problem Installing SSAS Monitoring App

MKeuper — Thu, 08 Oct 2009 15:03:44 GMT

Hi,

I've just installed the monitoring app and the management data warehouse like it was described on yout paper.

But if i look into the trace table, there are no data for the performance traces. Everything else works fine. Including the SSIS tasks.

Could you please tell me why the app still doesn't work?

Best Regards

Marcus

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 Release: Analysis Services Community Samples-February, 2009 (Feb 27, 2009)

ddarden42 — Fri, 18 Sep 2009 20:07:47 GMT

This release contains the following projects:

Activity Viewer
Aggregation Manager
ASCMD Stress Testing Scripts - Updated 2/23/09 to support Database name different from DatabaseID
AS Load Sim, including Load Testing Best Practices document
AS Query Generator
AS Trace
Analysis Services Upgrade Verification Tool
Compress M2M C# Application
Script for Creating a Processing Log File
Load Test Reports
A Solution for Collecting Analysis Services performance data from multiple sources (MonitoringSSAS.zip) - Updated 3/31/09 to fix one additional named instance bug
Powershell Scripts for Querying Analysis Services 2008 DMVs
RSS Style Sheet
SSIS Package For Collecting SSAS DMV Data - added 2/27/2009 (extracted from MonitoringSSAS solution)
SSAS Monitoring Scripts For Management Data Warehouse - added 2/27/2009 (extracted from MonitoringSSAS solution) - Updated to fix bug - named instance counters for SSAS must be entirely in capital letters
SsasHelper

Released: Analysis Services Community Samples-February, 2009 (Feb 27, 2009)

Fri, 18 Sep 2009 20:07:47 GMT

This release contains the following projects:

Activity Viewer
Aggregation Manager
ASCMD Stress Testing Scripts - Updated 2/23/09 to support Database name different from DatabaseID
AS Load Sim, including Load Testing Best Practices document
AS Query Generator
AS Trace
Analysis Services Upgrade Verification Tool
Compress M2M C# Application
Script for Creating a Processing Log File
Load Test Reports
A Solution for Collecting Analysis Services performance data from multiple sources (MonitoringSSAS.zip) - Updated 3/31/09 to fix one additional named instance bug
Powershell Scripts for Querying Analysis Services 2008 DMVs
RSS Style Sheet
SSIS Package For Collecting SSAS DMV Data - added 2/27/2009 (extracted from MonitoringSSAS solution)
SSAS Monitoring Scripts For Management Data Warehouse - added 2/27/2009 (extracted from MonitoringSSAS solution) - Updated to fix bug - named instance counters for SSAS must be entirely in capital letters
SsasHelper

Updated Release: Analysis Services Community Samples-February, 2009 (Feb 27, 2009)

ddarden42 — Fri, 18 Sep 2009 20:03:15 GMT

This release contains the following projects:

Activity Viewer
Aggregation Manager
ASCMD Stress Testing Scripts - Updated 2/23/09 to support Database name different from DatabaseID
AS Load Sim, including Load Testing Best Practices document
AS Query Generator
AS Trace
Analysis Services Upgrade Verification Tool
Compress M2M C# Application
Script for Creating a Processing Log File
Load Test Reports
A Solution for Collecting Analysis Services performance data from multiple sources (MonitoringSSAS.zip) - Updated 3/31/09 to fix one additional named instance bug
Powershell Scripts for Querying Analysis Services 2008 DMVs
RSS Style Sheet
SSIS Package For Collecting SSAS DMV Data - added 2/27/2009 (extracted from MonitoringSSAS solution)
SSAS Monitoring Scripts For Management Data Warehouse - added 2/27/2009 (extracted from MonitoringSSAS solution) - Updated to fix bug - named instance counters for SSAS must be entirely in capital letters
SsasHelper

Updated Release: Analysis Services Community Samples-February, 2009 (Feb 27, 2009)

ddarden42 — Fri, 18 Sep 2009 20:01:25 GMT

This release contains the following projects:

Activity Viewer
Aggregation Manager
ASCMD Stress Testing Scripts - Updated 2/23/09 to support Database name different from DatabaseID
AS Load Sim, including Load Testing Best Practices document
AS Query Generator
AS Trace
Analysis Services Upgrade Verification Tool
Compress M2M C# Application
Script for Creating a Processing Log File
Load Test Reports
A Solution for Collecting Analysis Services performance data from multiple sources (MonitoringSSAS.zip) - Updated 3/31/09 to fix one additional named instance bug
Powershell Scripts for Querying Analysis Services 2008 DMVs
RSS Style Sheet
SSIS Package For Collecting SSAS DMV Data - added 2/27/2009 (extracted from MonitoringSSAS solution)
SSAS Monitoring Scripts For Management Data Warehouse - added 2/27/2009 (extracted from MonitoringSSAS solution) - Updated to fix bug - named instance counters for SSAS must be entirely in capital letters
SsasHelper

Source code checked in, #28774

ddarden42 — Fri, 18 Sep 2009 19:53:34 GMT

SsasHelper - Initial Release Sample on working with Visual Studio SSAS Projects + AMO; Serialize/De-Serialize Databases, build .ASDatabase files, Clean SSAS projects for merging.

Closed Issue: Unable to use ASTrace in 64 Bit machine

furmangg — Fri, 21 Aug 2009 16:13:28 GMT

I tried to build ASTrace targetting x86 cpu and deployed into 64bit server. I cant get to start the service. It always fails with following message.
8/19/2009 10:28:54 PM: Error: Microsoft.SqlServer.Management.Trace.SqlTraceException: Failed to initialize object as reader. ---> System.Runtime.InteropServices.COMException (0x8004021A)
at ?A0x8159d01c.ProcessError(Int32 hr, UInt16* lpszMessage)
at Microsoft.SqlServer.Management.Trace.CTraceControllerBase.InitSource(Boolean bReOpen)
at Microsoft.SqlServer.Management.Trace.CTraceObjectsRowsetController.InitSource(Boolean bReOpen)
at Microsoft.SqlServer.Management.Trace.TraceServer.InitializeAsReader(ConnectionInfoBase serverConnInfo, String profileFileName)
--- End of inner exception stack trace ---
at Microsoft.SqlServer.Management.Trace.TraceServer.InitializeAsReader(ConnectionInfoBase serverConnInfo, String profileFileName)
at ASTrace.Trace.OnStart(String[] args)

I have already applied the sugesstions given in the other thread related to this issue.

Please let me know what else needs to be done.
Comments:

resolved

Commented Issue: Unable to use ASTrace in 64 Bit machine

sambathraj — Fri, 21 Aug 2009 04:31:04 GMT

Thanks For your reply. I now reinstalled the service and added the registry key. It now worked.

Commented Issue: Unable to use ASTrace in 64 Bit machine

furmangg — Thu, 20 Aug 2009 19:58:04 GMT

you followed the instructions at http://timlaqua.com/2008/11/installing-astraceexe-in-a-64-bit-environment/ and it still didn't work? Works great for me.

Created Issue: Unable to use ASTrace in 64 Bit machine

sambathraj — Thu, 20 Aug 2009 05:36:47 GMT

New Post: Does SQL 2008 Performance Studio replace the MonitoringSSAS app?

dbamark — Tue, 26 May 2009 19:58:43 GMT

So - it plugged into the MDW, added a custom collector under Data Collection node..

Is there some sample i can use for a report(s), maybe add it to the MDW Reports node?