• Blog Post: 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 have a shared...
  • Blog Post: 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...
  • Blog Post: 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...
  • 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: 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...
Page 1 of 1 (5 items)