Res Mon Includes XMLA scripts that create a cube used for storing SSAS monitoring information.
You can use the cube for analysis or to build dashboards. The following samples are not included on the Downloads page but are available on Code Plex and are useful for managing Analysis Services.
Aggregation Manager Lets you view, design, edit, and add aggregations based on the information collected in the query log.
ASCMD Stress testing Scripts Enables a database administrator to execute an XMLA script, Multidimensional Expressions (MDX) query, or Data Mining Extensions (DMX) statement against an instance of Microsoft SQL Server Analysis Services, using the ASCMD command-line utility.
Click the Downloads tab to obtain the source code for the following projects.
Click the Documentation tab for a detailed list of the projects, including the version of SQL Server that is required, requirements, and when the project was last updated: Activity Viewer Provides functionality for SSAS similar to the SQL Server stored procedure sp_who and the kill command in Transact-SQL.
Displays users, connections, and processes for an instance of Microsoft SQL Server Analysis Services.
Use the tool to retrieve a list of these items and, if you want to, to stop a process.
SSAS Helper Provides two code projects, one that creates an SSAS database using an MSBuild task, and one that creates a library with functions to work with AMO objects in Visual Studio 2008.
Now, these tasks are not difficult to complete, but why not just automate them into a SQL Agent job and just run it whenever you need it or schedule it and let the job do all the work?
If you have read some of my previous articles (What is causing database slowdowns or Simple SQL Server automated user auditing), you will know I am a big proponent of automating repeatable tasks.
For this very simple task, I decided to compose a SQL Script and put it into a scheduled SQL Agent Job.
For this to work, you will need at least SQL Server Standard Edition as the agent is not available in SQL Express Edition.
I built this on SQL Server 2014 however it should run on versions beginning from 2008 – current.