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…

19

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 get ascmd version for SQL 2005 (http://www.codeplex.com/MSFTASProdSamples/Wiki/View.aspx?title=SS2008%21Readme%20For%20Command-line%20Utility%20Sample&referringTitle=Home)…

0

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…

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