SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Which OS for SQL Server 2017 Standard? (new data warehouse)


Which OS for SQL Server 2017 Standard? (new data warehouse)

Author
Message
Rekonn
Rekonn
SSC Veteran
SSC Veteran (268 reputation)SSC Veteran (268 reputation)SSC Veteran (268 reputation)SSC Veteran (268 reputation)SSC Veteran (268 reputation)SSC Veteran (268 reputation)SSC Veteran (268 reputation)SSC Veteran (268 reputation)

Group: General Forum Members
Points: 268 Visits: 269
My company will be setting up a new data warehouse server using SQL Server 2017 Standard. We're a mixed shop, running both Windows and Ubuntu, seems we could choose either. What would you recommend? Pros/Cons
Rekonn
Rekonn
SSC Veteran
SSC Veteran (268 reputation)SSC Veteran (268 reputation)SSC Veteran (268 reputation)SSC Veteran (268 reputation)SSC Veteran (268 reputation)SSC Veteran (268 reputation)SSC Veteran (268 reputation)SSC Veteran (268 reputation)

Group: General Forum Members
Points: 268 Visits: 269
Another detail, this'll be two servers in an Availability Group actually.
Steve Jones
Steve Jones
SSC Guru
SSC Guru (594K reputation)SSC Guru (594K reputation)SSC Guru (594K reputation)SSC Guru (594K reputation)SSC Guru (594K reputation)SSC Guru (594K reputation)SSC Guru (594K reputation)SSC Guru (594K reputation)

Group: Administrators
Points: 594899 Visits: 21010
I would say Windows as the SQL AG story is more mature. Things should work fine on Linux, but I tend to avoid v1 versions of things like HA.

However, feel free to test and see. I think Joey D'Antoni and Allan Hirt have been happy with the HA story, but I know it has been a journey for them.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (860K reputation)SSC Guru (860K reputation)SSC Guru (860K reputation)SSC Guru (860K reputation)SSC Guru (860K reputation)SSC Guru (860K reputation)SSC Guru (860K reputation)SSC Guru (860K reputation)

Group: General Forum Members
Points: 860003 Visits: 47116
Rekonn - Thursday, December 7, 2017 8:43 AM
My company will be setting up a new data warehouse server using SQL Server 2017 Standard. We're a mixed shop, running both Windows and Ubuntu, seems we could choose either. What would you recommend? Pros/Cons


When given such options, take both. Wink

--Jeff Moden

RBAR is pronounced ree-bar and is a Modenism for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
anthony.green
anthony.green
SSC Guru
SSC Guru (100K reputation)SSC Guru (100K reputation)SSC Guru (100K reputation)SSC Guru (100K reputation)SSC Guru (100K reputation)SSC Guru (100K reputation)SSC Guru (100K reputation)SSC Guru (100K reputation)

Group: General Forum Members
Points: 100490 Visits: 8698
What components of SQL will be being installed on this new setup?

Do you need SSAS, SSIS and SSRS? If so use Windows as they are not supported on Linux just yet, if its just the engine, look at what is not supported yet on Linux and see if you'll be using any of the features, if you are then you have to use Windows, if you're not then you can choose which one you'll be most comfortable supporting.

https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-release-notes#Unsupported



How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger


Thom A
Thom A
SSC Guru
SSC Guru (80K reputation)SSC Guru (80K reputation)SSC Guru (80K reputation)SSC Guru (80K reputation)SSC Guru (80K reputation)SSC Guru (80K reputation)SSC Guru (80K reputation)SSC Guru (80K reputation)

Group: General Forum Members
Points: 80231 Visits: 20353
Considering that the OP stated that this'll be in a High Availablity Group, it might be worth noting there is a known issue with it on Linux. Not sure if it'll affect them, however:
Certain algorithms (cipher suites) for Transport Layer Security (TLS) do not work properly with SQL Server on Linux. This results in connection failures when attempting to connect to SQL Server, as well as problems establishing connections between replicas in high availability groups.

Details of a "resolution" can be found on the same page that Anthony linked to.


Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does :-P

Please always remember to encapsulate your code in IFCode Markup. For example [code=sql] [/code].
Click here to read Jeffs Guide on how to post SQL questions, and get swift and helpful answers from the community
Perry Whittle
Perry Whittle
SSC Guru
SSC Guru (210K reputation)SSC Guru (210K reputation)SSC Guru (210K reputation)SSC Guru (210K reputation)SSC Guru (210K reputation)SSC Guru (210K reputation)SSC Guru (210K reputation)SSC Guru (210K reputation)

Group: General Forum Members
Points: 210670 Visits: 18558
Steve Jones - SSC Editor - Thursday, December 7, 2017 11:25 AM
I would say Windows as the SQL AG story is more mature. Things should work fine on Linux, but I tend to avoid v1 versions of things like HA.

However, feel free to test and see. I think Joey D'Antoni and Allan Hirt have been happy with the HA story, but I know it has been a journey for them.


the thing is, the Linux support is still evolving here.
Tried and trusted for sometime now on Windows, the beauty is, you will be able to migrate to a new AG on a Linux system when the product is mature enough

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" ;-)
Rekonn
Rekonn
SSC Veteran
SSC Veteran (268 reputation)SSC Veteran (268 reputation)SSC Veteran (268 reputation)SSC Veteran (268 reputation)SSC Veteran (268 reputation)SSC Veteran (268 reputation)SSC Veteran (268 reputation)SSC Veteran (268 reputation)

Group: General Forum Members
Points: 268 Visits: 269
Thanks everyone! Sticking with Windows. Didn't know about the linux HA issue, and that it's engine only for now (we'll need SSIS).
kevaburg
kevaburg
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16014 Visits: 1283
Rekonn - Wednesday, December 13, 2017 10:19 AM
Thanks everyone! Sticking with Windows. Didn't know about the linux HA issue, and that it's engine only for now (we'll need SSIS).

Integration Services is available together with Full-Text Search Features on Linux / vNext. Although I wasn't aware of the issues with HAGs as Thom mentioned I also haven't experienced any problems in my test environment.

For me the most compelling argument comes from Perry with regarding to support that is still evolving, so to that end if you aren't comfortable supporting under Linux, stay with Windows.

Quick Edit: I tend to separate BI components from the engine anyway so it may be the case that even though some features are not yet supported by Linux that there is no reason to use the engine on Linux and BI on Windows.

Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search