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…

11

SSAS 2005:Performance

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

1

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…

0

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 White Paper http://download.microsoft.com/download/8/5/e/85eea4fa-b3bb-4426-97d0-7f7151b2011c/SSAS2005PerfGuide.doc   SQL Server Best Practices Article: Identifying and Resolving MDX Query Performance Bottlenecks in SQL Server 2005 Analysis Services http://www.microsoft.com/downloads/details.aspx?FamilyID=975C5BB2-8207-4B4E-BE7C-06AC86E24C13&displaylang=en

0