SQL Server 2019 for WIndows 11 Vs. SQL Server 2019 for Linux ...who is the fastest? the battle!
Hi Guys, Welcome to this post. In the previous posts here and here we have installed Windows 11 and SQL Server 2019 on a virtual machine and Ununtu (Linux) and SQL Server 2019 on another one. This was done to run benchmarks to verify which system is the fastest. Both VM has the same numerber of virtual processors (2), both has the same quantity of RAM (4gb) and both are installed on the same disk, a consumer samsung 1Tb SSD 860 qvo. From the management studio located in my pc we will connect in turn to the VMs with installed windows 11 and the VM with installed Ubuntu 20.04 lts. Enjoy the reading! How to connect to the VMs Connecting to the two VMs is simple! For the VM with windows, with the SQL server developer and express edition you need to enable the TCP/IP protocol : And open the TCP 1433 port in the firewall: To get the IP value simply open the command line and type the IPCONFIG command. For ubuntu VM machine, we need only to get the IP value by opening the terminal...