in

SQL Server Blogs

Voices from the UK SQL Server Community
All Tags » SSAS » 2008 (RSS)

Browse by Tags

  • Working with SSAS traces and the dreaded Textdata in SSMS

    For good or bad i regularly work with SSAS traces that i have saved to a table and many years ago i was regularly frustrated by the fact that the contents of the textdata column containing the query is always truncated at 65535 characters. You may think 65535 characters should cover most queries but...
    Posted to Andrew Calvett (Weblog) by ACALVETT on Sat, Feb 4 2012

  • SSAS Crash Dump behavior

    In SSAS 2005, when an exception occurs, you will always get a crash dump generated in the log directory of the instance and this could potentially lead to a lot of crash dumps consuming resources and a lot of work for the person who has to analyse the contents of each dump. One of the benefits of this...
    Posted to Andrew Calvett (Weblog) by ACALVETT on Tue, Jan 17 2012

  • Extreme load and “the operation has been cancelled”

    There are many reasons why SSAS may generate an operation has been cancelled but i want to take you through a new, although rare, one that i recently discovered. To set the scene I had been tuning the Process Index phase on one of our servers so we could fit a full reindex of a 1.8TB cube comfortably...
    Posted to Andrew Calvett (Weblog) by ACALVETT on Sun, Sep 18 2011

  • SQL Agent and SSAS Commands

    SQL Agent can be used to execute SSAS commands such as processing of a dimension and i can see that it is useful when you want to quickly schedule an adhoc processing task but there is a major drawback you need to be aware of. You are not able to specify the database to connect to and whilst you may...
    Posted to Andrew Calvett (Weblog) by ACALVETT on Mon, May 30 2011

  • SSAS Exposes a W2K3 bug

    I recently came across a bug in Windows 2003 SP2 which causes a blue screen of death and SSAS was exposing the bug. In my scenario SSAS was the match, a file system cache function was the fuse and a BSOD the payload….. If your an all Windows 2008 shop then there is no need to read on and i am envious...
    Posted to Andrew Calvett (Weblog) by ACALVETT on Wed, Apr 6 2011

  • SSAS Deployment essentials

    Over the recent years i have enjoyed the privilege of working on a number of different SSAS deployments. Some are huge, some are complex and some of them are huge and complex and most interestingly they all behave differently. What i want to share today is what i consider to be essential for an SSAS...
    Posted to Andrew Calvett (Weblog) by ACALVETT on Wed, Mar 30 2011

  • SSAS <PreAllocate>: What you should know

    Preallocating memory for SSAS running on Windows 2003 is a good thing but as with all good things it is essential to know the behavioural changes you will experience, some of which may not be so obvious. My observations relate to SSAS 2008 SP1 CU8 running on Windows 2003 SP2. Why PreAllocate? In my opinion...
    Posted to Andrew Calvett (Weblog) by ACALVETT on Sun, Jul 18 2010

  • SSAS – Synchronisation performance

    I’ve always thought of SSAS synchronisation as a clever file mirroring utility built into SSAS and i have never considered the technology as bringing any performance gains to the table. So, its a good job I like to revisit areas…. :) I decided to compare the performance of robocopy and SSAS Synchronisation...
    Posted to Andrew Calvett (Weblog) by ACALVETT on Thu, Apr 8 2010

  • SSAS 2008 - INI Files and in place upgrades

    Being the suspicious person i am i wondered if there would be any differences in the MSMDSRV.ini of an instance upgraded from 2005 as opposed to a clean install. Now obviously i expect an in place upgrade to preserve my settings and add any new ones because it should not overwrite anything since i might...
    Posted to Andrew Calvett (Weblog) by ACALVETT on Thu, Sep 24 2009

  • Data Warehouse Scalability Features in SQL Server 2008

    By now you might be aware or have gone through the web resources and conferences about what's new within SQL Server 2008 version, one thing is sure scalability for your database platform. Though there isn't a real-time data warehouse implementation within my work place, I have browsing through the Technet...
    Posted to SQL Server Knowledge Sharing Network (Weblog) by ssqa.net on Fri, Mar 7 2008
Page 1 of 1 (10 items)
Powered by Community Server (Commercial Edition), by Telligent Systems