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
Enabling Kerberos Authentication for Reporting Services

Recently, I’ve helped several customers with Kerberos authentication problems with Reporting Services and Analysis Services, so I’ve decided to write this blog post and pull together some useful resources in one place (there are 2 whitepapers in particular that I found invaluable configuring Kerberos...

Posted to Rob's SQL Server Blog (Weblog) by robcarrol 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
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
Parallelism, CPU Time & DMV’s

Whilst reviewing the CPU statistics of a system that i knew was CPU bound i found the numbers were not adding up and i was not seeing the code i expected to see as a top CPU consumer so i decided to going digging. I quickly identified that if the query has gone parallel it: Only shows as one thread in...

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
Server Side Aliases

Over the years i have come across a few situations where server side connections to SQL server fail when you use a DNS alias that points back to the server your initiating the connection from but you can connect remotely. Its an annoying problem which has a very unhelpful error message that changed in...

Posted to Andrew Calvett (Weblog) by ACALVETT on Sun, Nov 7 2010
Retrieving Historical Deadlock Graphs

When I visit a client site to troubleshoot deadlocks, it is always a cause of annoyance when I cannot go through historical deadlock events to determine the frequency and causes of these deadlocks. I either have to talk them through enabling trace flag 1222 or explain to them how to enable profiler to...

Posted to The Tao Of Sql Server (Weblog) by blakmk on Sat, Oct 23 2010

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