45TB-60TB / 45-60 mil file volume recommendations?

scottalanmiller

@jim9500 said in 45TB-60TB / 45-60 mil file volume recommendations?:

but as stated I spend 10-15% of my time on Hardware.

Im' not sure what this means. You mean you do rack and stacks?

Linux is easier to maintain, easier to support. Requires less effort and it is ridiculously easier to get someone to assist you when you need help. The less time you have to fool around and fiddle, the more important Linux becomes compared to a more "time intensive" product like Windows. I'm not knocking Windows, someone has to be easier, someone has to have better support, someone has to take less time... and Linux wins by a landslide here in all three cases for the use cases you are mentioning: file sharing and MS SQL Server.

And updates take, what, 1% as much time? Maybe less, for real, maybe .1% the time of maintaining updates on Windows. If your time matters, then why is Windows on the radar for these use cases?

jim9500

@scottalanmiller May spin up Ubuntu VM & try this again, last time I did I ran into issues & got lost down rabbit hole of trying to figure out what the problem was.

scottalanmiller

@jim9500 said in 45TB-60TB / 45-60 mil file volume recommendations?:

May spin up Ubuntu VM & try this again, last time I did I ran into issues & got lost down rabbit hole of trying to figure out what the problem was.

Great. For starters, be SURE to get Ubuntu 21.04. Do NOT let them convince you to run three versions old, which is some bizarre thing that Ubuntu does. It's crazy. It's nice that they have this "run old stuff with support" option. But for the best support, best performance, best reliability and least admin effort, stick with current, always.

scottalanmiller

@jim9500 You'll run into questions if you haven't done this much before. Ask here quickly, being new to it, it's going to feel like there is more work than any system you are more used to. That's natural. But it isn't because it is more work or harder, it's that some of it is different.

Trust me, going from Linux to Windows, it is staggering how many tasks and just time wasting things are required to do the simplest things or to do things that no other operating system even needs in the first place!

scottalanmiller

@jim9500 this is the link to the current version of the Server OS...

https://ubuntu.com/download/desktop/thank-you/?version=21.04&architecture=amd64

scottalanmiller

You CAN run the desktop version with a GUI as a server, unlike Windows that doesn't allow their desktop to be used as a server.

But I don't think that it will make what you are doing easier. People often do it thinking that a GUI will be handy. But very little takes enough effort to justify it. On Windows the same is true, it is just that so many of us got used to the GUI way before the command line option was there.

scottalanmiller

@scottalanmiller said in 45TB-60TB / 45-60 mil file volume recommendations?:

@jim9500 this is the link to the current version of the Server OS...

https://ubuntu.com/download/desktop/thank-you/?version=21.04&architecture=amd64

Ugh, spoke too soon. Because Microsoft doesn't consider their database to be at the enterprise level of PostgreSQL or MySQL, they recommend the less production ready, less supported "older" version of Ubuntu that only comes out every two years. This is done for companies that don't have faith in their own developers. So for SQL Server, you are supposed to stick to the LTS version, not the current fully support version. But it is ONLY Microsoft, and not Ubuntu, creating this reduction in support... but don't worry, support for old LTS Ubuntu is still thousands of times (no exaggeration) better than Windows support.

https://ubuntu.com/download/desktop/thank-you?version=20.04.2.0&architecture=amd64

scottalanmiller

Installing MS SQL Server on Ubuntu 20.04...

Just do this, copy past and voila. So much easier than walking someone through opening a menu...

wget -qO- https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -
sudo add-apt-repository "$(wget -qO- https://packages.microsoft.com/config/ubuntu/20.04/mssql-server-2019.list)"
sudo apt-get update
sudo apt-get install -y mssql-server curl
sudo /opt/mssql/bin/mssql-conf setup
systemctl status mssql-server --no-pager

Done. With that SQL Server is installed, configured, and enabled! You can start using immediately. Try to do that on Windows!