SQL 2005 (SQL 2008) Analysis Services Server Side Tracing

With Analysis Services 2005 (2008) you can collect traces without using gui this feature is known as Server Side Tracing. In this article we’ll talk about how to achieve Server Side Tracing. How to create a Server Side Trace Open SQL Server profiler connect to Analysis Services and in an Event Selection define the SSAS…

5

SQL Server Analysis Services Port (SQL 2005 / 2008)

Default Port:2383 You can change default Port for AS in msmdsrv.ini file of the Instance. Port Used by SQL Server Browser Services for SSAS is 2382 How to determine on which port AS is running? -Open Task Manager Get the PID for msmdsrv.exe -Open command Prompt type netstat /ao >>c:\output.txt -Look for the PID in…


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…

4

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…

2