Feeds:
Posts
Comments

Posts Tagged ‘Performance’

Announcing SSAS Maestros v1.2

Posted in Analysis Services, tagged , , on May 12, 2011 | 1 Comment »

In homage to the maestro, the Battlestar Galactica image links to Bear McCreary’s All Along The Watch Tower. Note, This is a re-post of Announcing SSAS Maestros v1.2 on the SQLCAT blog. — We are proud to announce that SQLCAT will continue with the SSAS Maestros course in June and July in Redmond and Madrid. [...]

Read Full Post »

Why the obsession with random I/O within the context of SSAS?

Posted in Analysis Services, tagged on March 1, 2011 | Leave a Comment »

As many of you know from the various blogs, whitepapers, and conferences from SQLCAT, there is a big obsession or compulsion toward I/O by various members of SQLCAT.  If you’re not already familiar with this topic, definitely reference Mike Ruthruff’s whitepaper Predeployment I/O Best Practices. But as could be seen from the SSAS Maestros session [...]

Read Full Post »

Getting ready for enterprise SSAS and PowerPivot at PASS with SQLCAT!

Posted in Analysis Services, PowerPivot, tagged on November 3, 2010 | Leave a Comment »

If you’re online this week, and admittedly the last few weeks I have been extremely dormant, you may know that next week is the 2010 SQL Server PASS Summit!   It’s one of the most important SQL Server conferences and my team, SQLCAT,  will be out in force.  Heck, we’ll be in our green SQLCAT shirts [...]

Read Full Post »

Analysis Services ROLAP for SQL Server Data Warehouses

Posted in Analysis Services, tagged , , , on August 24, 2010 | 2 Comments »

You’re sh*&ting me. No way. Man, that sucks. rocks! – Toby Lee Shavers, from XXX (2002), altered of course! And before you start, yes, I’m starting to follow the schtick of quotes from fellow PowerPivot bloggers Rob Collie (@PowerPivotPro) and Kasper de Jonge (@Kjonge).  For more memorable movie quotes, check out http://www.powerpivotpro.com/  . After about [...]

Read Full Post »

Scale-Out Querying with Analysis Services…does it apply to SQL Server 2008 or 2008 R2?

Posted in Analysis Services, tagged , on May 18, 2010 | 3 Comments »

I recently received a great question concerning the whitepaper Scale-Out Querying with Analysis Services: Question, does this also apply for SQL Server 2008? What are you experiences with the scale out? I’m in the process of recommending using this technology to a large customer of mine and want to make sure we are actually able [...]

Read Full Post »

Pros/Cons of deploying #SSIS with the SQL engine server

Posted in Integration Services, tagged , , on January 10, 2010 | 5 Comments »

I was asked a pretty good question recently on what are the pros and cons of deploying SQL Server Integration Services packages on the same server that has your SQL Engine Server as well.  While we covered a lot in Top 10 SQL Server Integration Services Best Practices, we never really addressed this issue specifically [...]

Read Full Post »

Accelerating Microsoft adCenter with Microsoft SQL Server 2008 Analysis Services

Posted in Analysis Services, tagged , , on September 19, 2009 | Leave a Comment »

How Microsoft adCenter takes advantage of groundbreaking performance and scalability enhancements and innovative design tools available with Microsoft SQL Server 2008 Analysis Services   For more information, please refer to the whitepaper Accelerating Microsoft adCenter with Microsoft SQL Server 2008 Analysis Services.   Executive Summary As an Internet platform for online advertising campaigns on Microsoft® Bing™, [...]

Read Full Post »

Designing and Tuning for Performance your SSIS packages in the Enterprise (SQL Video Series)

Posted in Integration Services, tagged , , on May 12, 2009 | Leave a Comment »

For all of those whom are interested in SSIS performance, we have posted a new SQL video series about how to design and tune your SSIS packages for performance. Measuring and Understanding the Performance of Your SSIS Packages in the Enterprise (SQL Server Video) Link | Watch this video Author: Denny Lee, Microsoft Corporation This [...]

Read Full Post »

The Ultimate SQL Data Loading Performance Guide

Posted in Integration Services, SQL, tagged , on February 15, 2009 | Leave a Comment »

For all of you whom wanted to know about how to load data within SQL Server, please refer to the "Ultimate" SQL Data Loading Performance Guide at: http://sqlcat.com/whitepapers/archive/2009/02/15/the-data-loading-performance-guide-2008.aspx   This document described techniques for bulk loading large data sets into SQL Server. It covers both the available techniques as well as methodologies to performance tune [...]

Read Full Post »

Reporting Services Performance Optimization

Posted in Reporting Services, tagged on January 15, 2009 | Leave a Comment »

The final technical note as part of the Building and Deploying Large Scale SQL Server Reporting Services Environments technical note series on Reporting Services Performance Optimization has just been published at Reporting Services Performance Optimization.   This technical note provides guidance on the reasons to use 64-bit, how to handle large workloads, Monitoring Reporting Services [...]

Read Full Post »

Older Posts »

Follow

Get every new post delivered to your Inbox.

Join 1,049 other followers