How to Warm AS Cache using SSIS Package

By following below mentioned steps we can warm AS Cache using SSIS Package by using Process Execute & Analysis Services Execute DDL Task -You need to get ascmd for SQL 2008 Analysis Services ( or if you want to warm cache for SQL 2005 then you need to get ascmd version for SQL 2005 (…


Tampering master.vmp file may result in losing all Analysis Services Databases

  The master.vmp file is the master version map that contains the GUIDS for all of the objects and the version of each object that currently exists on the server.   When the server starts, it looks at the master.vmp file and attempts to find each of the objects referenced in the file. If there…


Analysis Services Preallocate Memory Setting – Insight

Q: What is Preallocate Setting?  Answers: Preaallocate Setting specifies a certain percentage of memory be allocated to Analysis Services when the service starts (memory preallocation). This configuration setting was introduced because the Microsoft Windows Server 2003 operating system did not scale well with many small virtual memory allocations due to memory fragmentation and inefficiencies in…



What is SPN? An SPN is a unique identifier for a service on a network that uses Kerberos authentication. It consists of a service class, a host name, and a port. On a network that uses Kerberos authentication, an SPN for the server must be registered under either a built-in computer account (such as NetworkService…


SSAS(64 Bit) and Oracle Client Issues

While trying to create an Analysis Service Data Source that connects to Oracle using ORAOLEDB Provider, you get an error – TITLE: Connection ManagerTest connection failed because of an error in initializing provider. ORA-12154: TNS:could not resolve the connect identifier specifiedBUTTONS: EnvironmentWindows 2003 x64 Sp2SQL Server 2005 x64 SP2 CU10 There can be 2 Scenerios:…


SSAS Performance Counter Error while collecting BLG file Reference error message: Access is denied.

While Creating BLG file for SSAS counters getting below mentioned error message: System Log:Event Type:        ErrorEvent Source:    SideBySideEvent Category:                NoneEvent ID:              59Date:                     12/1/2008Time:                     1:52:35 AMUser:                     N/AComputer:          DBANALYSIS01Description:Generate Activation Context failed for d:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\bin\msmdctr90.DLL. Reference error message: Access is denied.For more information, see Help and Support Center at Application Log:The description for Event…


Configuring Datapump in IIS 7

Configuring HTTP Access to SQL Server 2005 or SQL 2008 Analysis Services on Microsoft Windows Server 2008 Getting BinariesCopy the contents of the %Installation folder%\OLAP\bin\isapi directory into the folder you would like to become the base for the virtual directory in IIS. In this example, we are going to copy all the files from the…


SSAS 2005:Performance

  Which Engine (Storage / Forumal) causing MDX Performance Issue? Improve MDX Performance               


Which Engine (Storage / Formula) causing MDX Performance Issue?

  Follow below mentioned steps: -Set Profiler with Query Begin and Query End Event, Run Profiler Trace and Execute MDX which you need to tune. -Stop Profiler trace and save trace to table in RDBM -What you need to do is run the following SQL query against the table in which you had saved Profiler Trace Select…


SSAS:Informative Links

  Links Related to Analysis Services:   SQL Server 2005 Analysis Services Tutorial   Analysis Services 2005 Migration   Analysis Services 2005 Performance White Paper   SQL Server Best Practices Article: Identifying and Resolving MDX Query Performance Bottlenecks in SQL Server 2005 Analysis Services