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
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
Introduction to MDX–Training–London

if you are looking to work with Analysis Services then you need to learn MDX and there is no better person to learn it from than Chris Webb Chris is a Microsoft MVP and a leading expert on MDX. He is the co-author of two books, "MDX Solutions" (second edition) and "Expert Cube Development...

Posted to Simons SQL Blog (Weblog) by simonsabin on Wed, Oct 5 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
Two new Analysis Services Blogs

Please welcome two new bloggers Pete Adshead and Christian Bracchi to the blogosphere! These guys truly know what it means to build enterprise class highly scalable Analysis Services Solutions and you now how the opportunity to read about their experiences. Don’t miss out!

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
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
Building a Dynamic OLAP Environment at #SQLbits8

On Saturday I attended the SQLBits conference in sunny Brighton. Great conference, well organized with lots of great speakers presenting high quality content. For me the highlight was meeting many of the senior guys from the Redmond SQL Server product team including Richard Tkachuk , Mark Souza and Ross...

Posted to Sparks from the Anvil (Weblog) by DrJohn on Mon, Apr 11 2011

Page 1 of 6 (56 items) 1 2 3 4 5 Next > ... Last »