SQL BI

My Experience - Troubleshooting SQL BI Stack

Browse by Tags

Tagged Content List
  • Blog Post: 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...
  • 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: 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...
Page 1 of 1 (3 items)