SSAS Synchronization: Across different versions

  Problem Statement: Synchronization between different builds or versions of Analysis Services. Solution: The Synchronize Database Wizard makes two Microsoft SQL Server Analysis Services databases equivalent by copying the data and metadata from a source server to a destination server. This wizard can also be used to deploy a database from a staging server onto…

0

SSAS encryption

Description: Customer asking if AS supports TDE like encryption we got in SQL Engine. Solution: SSAS doesn’t support any data encryption on disk, in simple words – SSAS doesn’t do any kind of encryption. What it supports: HTTPS – You can use Analysis Services using PUMP and configure pump with HTTPS Windows File System encryption …

1

SSAS Data Collection: Collecting Perfmon for SSAS

Applies to Windows7, Windows 2008/R2 and Vista SQL Server all builds >= SQL 2005 Generally, for troubleshooting SSAS Issues, we recommend to collect below mentioned Perfmon Counters – All Counters Related to SSAS (MSAS_ or MSOLP$) For default instance SSAS Counter Name suffix with MSAS.n and for named instance it start with MSOLAP$Instance Name –…

0