PowerShell: Checking For Large SSAS String-Store Files
In a recent blog post, Why You Need to Routinely ProcessFull, I discussed an issue where we'd run into the 4GB file size limit on SSAS string store files. In an ideal world, we'd fully reprocess the SSAS databases on a regular basis which would eliminate this issue.and maybe even provide a (very) minor performance boost by keeping the database data files as compact as possible. But unfortunately we don't live in an ideal world and the task of updating our ETL process to address this particular issue hadn't quite made it to the top of the priority list when we ran into it again.
Read more...Tags: amo, process, script, powershell