Why do we need SPN for File Server (NAS / RAS / File Share System) DNS Alias (Cname)

Very often we use UNC location while taking backup of SQL or Analysis Services Database or try to upload data in SQL Tables using bulk load command where text or csv file located in File Server so we access it by giving UNC. Sometimes File Server Machine (NAS / RAS or a computer where we…

0

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

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…

9

Gemini (In-Memory Business Intelligence)

The key question behind Gemini is: how much value can an Excel user derive from Microsoft’s BI stack without having to pick up a book on OLAP, Dimensional Modeling or Analysis Services?  New feature in SQL 2008R2 with which Excel user can build models, analysing data from Excel 2010 and  share it with others by uploading it to…

0