SQL server 2016 build - Polybase/Minimum requirements

Question

SQL server 2016 build - Polybase/Minimum requirements

SQL!$@w$0ME

SSChampion

Points: 12349
More actions
August 8, 2016 at 2:01 pm

#328930

Hi Folks,
I have a requirement to build a test SQL 2016 box. We need to utilize polybase feature to archive data from on-prem to Hadoop/Azure Blob Storage/Azure SQL datawarehouse.
* Any suggestions on selecting the right edition of SQL 2016 (Ent/Std)
* What is scale-out configuration(enterprise edition) & Compute node only(standard edition)?
* What are the minimum requirements for a test instance (Memory & CPU) with the above feature.
Many thanks!

Viewing 6 posts - 1 through 5 (of 5 total)

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

Phil Parkin SSC Guru Points: 246960 More actions · Answer 1

Did you read this page? Explains compute node/head node differences at least.

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

SQL!$@w$0ME SSChampion Points: 12349 More actions · Answer 2

Thank Phil. If we don't want scale-out feature, should I go with standard edition of SQL?

Phil Parkin SSC Guru Points: 246960 More actions · Answer 3

SQL!$@w$0ME (8/9/2016)
Thank Phil. If we don't want scale-out feature, should I go with standard edition of SQL?

I don't have practical experience of this – only what I have read – so I am hoping that someone who knows better than I will advise you.

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

Eirikur Eiriksson SSC Guru Points: 182911 More actions · Answer 4

SQL!$@w$0ME (8/8/2016)
Hi Folks,
I have a requirement to build a test SQL 2016 box. We need to utilize polybase feature.
* Any suggestions on selecting the right edition of SQL 2016 (Ent/Std)
* What is scale outscale-out configuration(enterprise edition) & Compute node only(standard edition)?
* What are the minimum requirements for a test instance (Memory & CPU) with the above feature.
Many thanks!

Quick question, what is the intended use for the PolyBase?

😎

SQL!$@w$0ME SSChampion Points: 12349 More actions · Answer 5

Quick question, what is the intended use for the PolyBase?

Planning to archive data from on-prem to Hadoop/Azure Blob Storage/Azure SQL datawarehouse.

Thanks!