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

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 in Redmond this week (for more information, check out What is the SSAS Maestros?), there is even an obsession for IOps even within the context of Analysis Services as noted in the papers below Please click through to continue reading: Why the obsession with random…

Rate this:

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

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 so we’ll be noticeable from across the Washington State Convention Center.   Just in case you do not already know, SQLCAT is a SQL Server product group team that works with some of the largest implementations of SQL Server.  By doing this, we help improve…

Rate this:

Analysis Services ROLAP for SQL Server Data Warehouses

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 14 months of testing, validation, analysis, and all sorts of hardware headaches and dancing, I am proud to say that I have finally published the Analysis Services ROLAP for SQL Server Data Warehouses whitepaper with my trusted partners-in-crime Thomas Kejser and Kay Unkroth.  Thomas for…

Rate this:

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

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 to deploy such a setup. So let’s tackle these issues one-by-one. Does the whitepaper Scale-Out Querying with Analysis Services apply for SQL Server 2008? Yes! Okay, now a more verbose answer here :).  The paper is applicable to both SQL Server 2008 and SQL Server…

Rate this:

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

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 – so let’s do it: Advantages of placing SSIS and SQL on the same server: You can use the SQL Server Destination instead of OLE DB which allows you to load data into SQL faster. You remove network as a bottleneck for insertion of data…

Rate this:

Accelerating Microsoft adCenter with Microsoft SQL Server 2008 Analysis Services

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™, Microsoft adCenter offers customers a wide range of intelligence and analytics tools to target, reach, and engage the right audience with the right ad at the right time. A complex, multi-faceted Online Analytical Processing (OLAP) environment based on SQL Server® 2008 Analysis Services drives the…

Rate this:

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

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 video demonstrates how to measure and understand the performance of packages, based on lessons learned from enterprise customers. In this video, you will learn the following guidelines for improving performance: How the limits of the source system affect performance. Why disk I/O is important. Why…

Rate this: