SSAS Scripts 
Teaser: SSAS Cache Warming with PowerShell
Teaser: SSAS Cache Warming with PowerShell
| Teaser: SSAS Cache Warming with PowerShell |
| Written by Darren Gosbell | |||
| Sunday, 16 November 2008 14:49 | |||
|
You may be thinking oh-no, not another one. Allan Mitchell recently posted an example of an SSIS package that would warm the SSAS cache which is an updated version with a slightly simpler SSIS data flow from something Chris Webb originally blogged. Being a PowerShell fan as I read Allan's post I realised that most of the tasks mapped to native PowerShell cmdlets and I already had PowerShell code to execute an MDX command, so all I was missing was someway of reading in the trace data. What I ended up with was the following 3 line script which uses 2 native and 2 custom cmdlets to do the same thing as Allan's SSIS package. Read more...
|
Tags: cache, performance, script
Most read
- SSIS Package to process all dimensions in one SSAS Database
- SSIS package to backup all Analysis Services databases on one instance
- SSIS Package to Back Up SSAS Databases by Dave Fackler
- SSIS Package to drop and create partitions based on data in SQL Server table
- WSH script to get SSAS DB info about aggregation designs
Top Rated
- PowerShell script to list info about SSAS databases
- PowerShell script to process all dimensions and cubes in one DB limiting workload
- WSH script to get SSAS DB info about aggregation designs
- SSIS Package to drop and create partitions based on data in SQL Server table
- SSIS Package to Back Up SSAS Databases by Dave Fackler
- Killing sessions automatically with SSIS
- Teaser: SSAS Cache Warming with PowerShell
- PowerShell script to process all dimensions in one Analysis Services database
