Running simultaneously Microsoft Windows SQL 2005, 2008, 2014, 2017, 2019
by Mountain Computers Inc., Publication Date: Saturday, October 22, 2022
View Count: 159, Keywords: Microsoft Windows, Microsoft SQL Server, Simultaneously, Oracle Virtual Box, Hashtags: #MicrosoftWindows #MicrosoftSQLServer #Simultaneously #OracleVirtualBox
In the last 15 years, I have had to support MS SQL databases from a variety of sources, and I still get support requests lately dating back to 2005. Wow, even my oldest systems dating back to 1998 are still running in production serving over 1 million users per month, and 10 million per year. Amazing how strong and long SQL can survive.
Lately, though, running multiple versions has been a challenge, so I just use Oracle Virtual Box and spin up unique operating systems to support those different SQL versions.
It's not too hard. You just have to keep your versions and operating systems labeled properly, and enough extra disk space for the size of your databases. Usually 100GB on the side per OS and SQL instance is more than enough, yet for some larger sets, 1-2TB is required. As far as the number of CPU cores and RAM, I set aside 8GB and 8 core on either of my 16 CPU core 32 thread 128GB 16TB systems.
That's more than enough horsepower to do what I need to do.
more to come...
if you found this article helpful, consider contributing $10, 20 an Andrew Jackson or so..to the author. more authors coming soon
FYI we use paypal or patreon, patreon has 3x the transaction fees, so we don't, not yet.
© 2023 myBlog™ v1.1 All rights reserved. We count views as reads, so let's not over think it.