Browse by Tags

SSAS - What is running ?

I saw a tweet today from respected blogger john sansom asking how a SQL DBA should attempt to performance tune SSAS. I've been through a similar scenario - and one of the tools I developed as part of my troubleshooting was my own 'SSAS version' of sp_who. I've written a stored procedure...

Posted to Steve Hindmarsh's SQL Blog (Weblog) by steveh99999 on Thu, Dec 15 2011
SQL Server Training in the UK–SSIS, MDX, Admin, MDS, Internals

If you are looking for SQL Server training they there is no better place to start than a new company Technitrain Its been setup by a fellow MVP and SQLBits Organiser Chris Webb. Why this company rather than any others? Training based on real world experience by the best in the business. The key to Technitrain...

Posted to Simons SQL Blog (Weblog) by simonsabin on Wed, Nov 23 2011
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

Page 1 of 1 (8 items)