SSIS Package For Collecting SSAS DMV Data (Free)
From the readme.txt file:
Download zip file here... (in the releases tab select file SSISPackageForCollectingSSAS_DMVData)Use the files in this folder to use the Read_SSAS_DMV package in a SQL Agent job to collect SSAS DMV data to tables in a database called DMV.
Edit the following files before installing framework:
Read_SSAS_DMV.dtsConfig -- specify the SSASInstanceName
Configuring_SSAS_DMV_Data_Collection.cmd -- specify the data collection server name, the SSAS server name, and the SSAS instance nameEdit these files to start and stop the SQL Agent job that periodically executes the SSAS_DMVs job.
Start_Collection.cmd -- specify the data collection server name, the SSAS server name, and the SSAS instance name
Stop_Collection.cmd -- specify the data collection server name, the SSAS server name, and the SSAS instance name
Tags: tool, performance, ssis, dmv, software