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
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 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 – 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
Exploring backup read io performance

I was recently exploring how to increase the backup read throughput on one of our SQL servers. Below are some interesting facts i found. I would say that one of the most important reminders that came from the exercise is, do not assume that 2 databases being backup up on the same server using an identical...

Posted to Andrew Calvett (Weblog) by ACALVETT on Sun, Jan 24 2010
SQL Server Upgrade issues - How to evaluate potential issues?

During the end of March 2009 I have presented a session " Upgrading To SQL Server 2005 & 2008: Notes & Best Practices" in SQLBits IV conference at Manchester. The session covered a brief tour on SQL Server Upgrade options, methodology, tools and planning, technical and non-technical...

Posted to SQL Server Knowledge Sharing Network (@sqlmaster) (Weblog) by ssqa.net on Tue, Jun 9 2009
SQL Server 2008 Policy Based Management - managing and troubleshooting policy failures

Policy Based Management (PBM) is an effective system for DBAs to manage one or more instances of SQL Server. Just to give a brief overview of what it consists, it consists 3 components: Policy management for Administrators to create policies Explicit administration for Administrators to select multiple...

Posted to SQL Server Knowledge Sharing Network (@sqlmaster) (Weblog) by ssqa.net on Fri, Jan 9 2009
SQL Server 2008 features - Relational & Data Warehouse Scalability list (new)

Scalability is an important aspect in every application, a common achievement within OLTP environment and still applicable to OLAP (Anlaysis Services) environment. In any if the application or a cube or mining model may be unavailable for querying because of a hardware or software failure, also it could...

Posted to SQL Server Knowledge Sharing Network (@sqlmaster) (Weblog) by ssqa.net on Thu, Jun 12 2008

Page 1 of 1 (8 items)