SSAS Tip – IndexBuildThreashold

<IndexBuildThreshold> Index creation is controlled by the number of rows, specified in the msmdsrv.ini (default location of msmdsrv.ini file – ?:\Program Files\Microsoft SQL Server\MSAS10_50.SQL2008R2\OLAP\Config\msmdsrv.ini) file as <IndexBuildThreshold>, with a default of 4096. Partitions with fewer rows will not have indexes built. Which means if you have less than 4096 records in a Partition you will…

1

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…

0

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