Browse by Tags

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
SSAS 2008 R2 Operations Guide

What can i say but WOO HOO! The SSAS 2008 R2 Operations Guide has been published so download your copy now! This document should be considered essential reading and contains over 100 pages of high quality information for configuring, testing and operating an Analysis Services server. Finally i consider...

Posted to Andrew Calvett (Weblog) by ACALVETT on Thu, Jun 2 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 Native v .net Provider

Recently I was investigating why a new server which is in its parallel running phase was taking significantly longer to process the daily data than the server its due to replace. The server has SQL & SSAS installed so the problem was not likely to be in the network transfer as its using shared memory...

Posted to Andrew Calvett (Weblog) by ACALVETT on Tue, Nov 30 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
Enter the SSAS server level lock......

Ok, so your reaction to the title is probably the same as mine when i found out about SSAS server level locks! So, i will give you the scripts to reproduce the server level lock but first lets get down to business…. :) Server locks were introduced in one of the SP2 cumulative updates. At the moment i...

Posted to Andrew Calvett (Weblog) by ACALVETT on Mon, Nov 23 2009
The cost of SSAS metadata management

This post will explain how we found ourselves in a situation where when processing a partition the metadata checks took 50 times longer than the actual partition and how to identify what time penalty you are incurring for the metadata checks. The system i was investigating had around 80 cubes with around...

Posted to Andrew Calvett (Weblog) by ACALVETT on Fri, Aug 21 2009
Analysis Server appears to hang…..

We had an ongoing problem where by users would suddenly start complaining that the Analysis Server was hanging. When investigating the box we could see that there appeared to be no physical constraints. Disks were a bit above average, CPU was very low and there was plenty of memory. When looking at the...

Posted to Andrew Calvett (Weblog) by ACALVETT on Sun, Apr 5 2009
SSAS 2005 – Server side tracing starter kit

Analysis services 2005 (SSAS) added the ability to trace server side events and i have used this feature a number of times. To date i had always used the profiler gui to do the SSAS tracing but today i found myself needing to initiate and manage a trace with scripts. The good news is that it can be done...

Posted to Andrew Calvett (Weblog) by ACALVETT on Mon, Apr 7 2008
Analysis Services 2005 Performance Tuning Whitepaper

This white paper describes how application developers can apply performance-tuning techniques to their Microsoft SQL Server 2005 Analysis OLAP solutions. It's a very interesting and thorough (and long!) paper and well worth a read. Download it here Also highly recommended if you're using Analysis Services...

Posted to sqldbatips.com blog (Weblog) by sqldbatips on Fri, Feb 2 2007

Page 1 of 1 (10 items)