SQL BI

My Experience - Troubleshooting SQL BI Stack

Browse by Tags

Tagged Content List
  • Blog Post: 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 ( http://www.codeplex.com/MSFTASProdSamples ) or if you want to warm cache for SQL 2005 then you need to...
  • Blog Post: 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 are...
  • Blog Post: 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...
  • Blog Post: SQL 2005 SPN (SSAS/SSRS/SQL)

    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...
  • Blog Post: 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 Manager Test connection failed because of an error in initializing provider. ORA-12154: TNS:could not resolve the connect identifier specified BUTTONS: Environment...
  • Blog Post: 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: Error Event Source: SideBySide Event Category: None Event ID: 59 Date: 12/1/2008 Time: 1:52:35 AM User: N/A Computer: DBANALYSIS01 Description: Generate Activation Context failed for d:\Program...
  • Blog Post: Configuring Datapump in IIS 7

    Configuring HTTP Access to SQL Server 2005 or SQL 2008 Analysis Services on Microsoft Windows Server 2008 Getting Binaries Copy 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...
  • Blog Post: SSAS 2005:Performance

    Which Engine (Storage / Forumal) causing MDX Performance Issue? Improve MDX Performance
  • Blog Post: 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...
  • Blog Post: SSAS:Informative Links

    Links Related to Analysis Services: SQL Server 2005 Analysis Services Tutorial http://msdn.microsoft.com/en-us/library/ms170208(SQL.90).aspx Analysis Services 2005 Migration http://www.microsoft.com/technet/prodtechnol/sql/2005/asmigrtn.mspx Analysis Services 2005 Performance...
Page 1 of 1 (10 items)