Report Portal

SSIS Package For Collecting SSAS DMV Data (Free)

From the readme.txt file:

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 name

Edit 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

Download zip file here... (in the releases tab select file SSISPackageForCollectingSSAS_DMVData)

Tags: tool, performance, ssis, dmv, software

 

2007-2015 VidasSoft Systems Inc.