Analysis Services Community Samples

Rating:        Based on 4 ratings
Reviewed:  4 reviews
Downloads: 45012
Released: Feb 27, 2009
Updated: Jul 31, 2013 by furmangg
Dev status: Stable Help Icon

Downloads

Application ActivityViewer
application, 74K, uploaded Feb 5, 2009 - 4044 downloads
Application AggregationManager
application, 65K, uploaded Feb 5, 2009 - 2070 downloads
Application ASCMD_StressTestingScripts
application, 35K, uploaded Feb 23, 2009 - 3264 downloads
Application ASLoadSim
application, 1551K, uploaded Feb 5, 2009 - 2115 downloads
Application ASQueryGen
application, 26K, uploaded Feb 5, 2009 - 2121 downloads
Application ASUV
application, 317K, uploaded Feb 5, 2009 - 1041 downloads
Application CompressManyToMany.zip
application, 55K, uploaded May 10, 2010 - 1516 downloads
Application CreateProcessingLog
application, 10K, uploaded Feb 5, 2009 - 1588 downloads
Application LoadTestReports
application, 16K, uploaded Feb 5, 2009 - 1511 downloads
Application MonitoringSSAS
application, 19656K, uploaded Mar 31, 2009 - 10408 downloads
Application Powershell_Scripts_for_SSAS_DMVs
application, 18K, uploaded Feb 5, 2009 - 1548 downloads
Application RssStyleSheet
application, 5K, uploaded Feb 5, 2009 - 1112 downloads
Application SSISPackageForCollectingSSAS_DMVData
application, 51K, uploaded Feb 27, 2009 - 2267 downloads
Application SSASMonitoringScriptsForManagementDataWarehouse
application, 5K, uploaded Mar 6, 2009 - 2513 downloads
Application SsasHelper
application, 65K, uploaded Nov 16, 2009 - 2379 downloads
Application ResMon
application, 28K, uploaded Mar 21, 2012 - 1856 downloads
Source Code ASTrace2008.zip
source code, 257K, uploaded Jul 25, 2013 - 2023 downloads
Source Code ASTrace2012.zip
source code, 318K, uploaded Jul 31, 2013 - 1636 downloads

Release Notes

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
  • ASTrace2008 - Updated 6/27/2013 with compiled binaries and support for monitoring multiple instances
  • ASTrace2012 - Updated 6/27/2013 with compiled binaries and support for monitoring multiple instances
  • Analysis Services Upgrade Verification Tool
  • Compress M2M C# Application - Updated 5/10/2010 with 12/25/2009 changes described here
  • 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
  • ResMon - added 11/4/2010 and documented here. updated 3/20/2012 for AS2012
  • ASLB - Analysis Services Load Balancing


Analysis Services 2012

Little testing of these community samples against SQL Server 2012 Analysis Services has been done. The following projects include code for 2012:
  • ResMon
  • ASTrace2012

Reviews for this release

     
works perfectly! Thanks
by dugome on Sep 3, 2013 at 3:47 PM
     
The most SSAS powerful tools that I'd recommend to everyone.
by murali12180 on May 8, 2012 at 7:09 PM
     
SSAS Monitoring For Management Data Warehouse is very nice
by josefjurak on Jun 3, 2011 at 7:39 AM
     
cool good nice
by neilni on Mar 10, 2011 at 7:14 AM