A Quick Look at the MPP World

Question

A Quick Look at the MPP World

David.Poole

SSC Guru

Points: 75992
More actions
August 11, 2010 at 12:05 am

#103970

Comments posted to this topic are about the item A Quick Look at the MPP World
LinkedIn Profile

Viewing 15 posts - 1 through 15 (of 16 total)

You must be logged in to reply to this topic. Login to reply

jcrawf02 SSC-Insane Points: 24198 More actions · Answer 1

Nice article, David!

---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]

"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

TheSQLGuru SSC Guru Points: 134017 More actions · Answer 2

Microsoft is WAY behind the curve on this topic, and PDW will take at least another 18 months or so to be anywhere close to where it should be. Oracle Exadata is doing very well in the marketplace I think, although I think part of that is very aggressive sales and marketing tactics.

It is definitely a tough problem to solve, but I think PDW will get there eventually. The Datallegro IP (and people) they acquired are good.

Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service

SanjayAttray SSChampion Points: 13157 More actions · Answer 3

Very informative article. Thanks Dave for compiling it, thoroughly.

I am sure my current company / project would not be using it in near future. But, still good to have knowledge of storm before it hits the shore.

SQL DBA.

WayneS SSC Guru Points: 95460 More actions · Answer 4

David,

This is definitely an excellent, thought-provoking article. Thanks!

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

TimothyAWiseman SSCrazy Eights Points: 8819 More actions · Answer 5

This provides an excellent overview of the current MPP situation, thank you for providing it.

---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/

SQLRNNR SSC Guru Points: 281334 More actions · Answer 6

Thanks for the article.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

katedgrt Ten Centuries Points: 1197 More actions · Answer 7

Absolutely a great article and good guide to pertinent questions. Thanks for sharing!

😎 Kate The Great :w00t:
If you don't have time to do it right the first time, where will you find time to do it again?

gary.strange-sqlconsumer SSCommitted Points: 1816 More actions · Answer 8

Great article David,

I'm currently using Neteeza Twinfins two process some heavy analytics and was very interested to hear about the SQL server MPP offering. Do you have any first hand experience with the new product and do you have knowledge of the hardware requirements?

lkagan.sqldba Newbie Points: 7 More actions · Answer 9

Great overview - thanks.

...This discussion could also include open source platform choices, particularly with shared nothing architectures.

Misha_SQL SSCertifiable Points: 5407 More actions · Answer 10

Very informative, thank you! I would add another relative newcomer to this list: AsterData. We have been using their system at my last job with great success. It's especially good at supporting complex NPath (map reduce) queries. You can read more about it on their website.

David.Poole SSC Guru Points: 75992 More actions · Answer 11

Do you have any first hand experience with the new product and do you have knowledge of the hardware requirements?

Not yet but I have spoken with people in the DW industry who are saying that, while it is on the right path, it isn't there yet. Given M$ enthusiasm for the BI stack I expect them to do whatever it takes to make it a success.

LinkedIn Profile

gary.strange-sqlconsumer SSCommitted Points: 1816 More actions · Answer 12

hmm, successful as in profitable?

Taking a step back from the technical discussion I see a mayor re-marketing strategy pushed forward with 2008 R2 but as developers are we getting quality products or market domination? We have so many editions developer, standard, enterprise, express, web, workgroup, datacenter, Parallel Data Warehouse, compact, azure, etc, etc. But do any of these products truely stand on there own two feet or are they all reliant on additional M$ technologies (windows server, share point, .net, excel, even bing) and additional M$ certificated personel.

All the competitive products mentioned deliver very successfully without forcing you to commit to a M$ marriage and a very expensive long term relationship.

I just hope the MPP solution houses keep producing quality and don't get eaten up by the marketing giant.

David.Poole SSC Guru Points: 75992 More actions · Answer 13

IBM has acquired Neteeza.

http://www-03.ibm.com/press/us/en/pressrelease/32955.wss

LinkedIn Profile

gary.strange-sqlconsumer SSCommitted Points: 1816 More actions · Answer 14

And M$ got their datallegro.

I went to a virtual Denali seminar earlier this week, which was very good.

M$ will be allowing their deminsional modeling engine to interact with the new the PDW. A cube on steroids, nice!