On: Running Intel Binaries in Linux VMs with Rosetta

[draebek]

I know of Azure SQL Edge, which has significant limitations, but I don't know how to run MS SQL Server on an M1 at anything more than glacial speeds (i.e. full system emulation in Qemu). Is there something I don't know about? Please share!

[my123 → draebek]

the Drawbridge environment has some peculiar needs that most JITted envs don't provide. So unlikely to work but will test that out soon...

[draebek → my123]

If you're speaking about the existing technique MS has developed to run MS SQL on Linux, it doesn't work on M1s in Docker under Qemu user emulation: https://github.com/microsoft/mssql-docker/issues/668

That's 2019. I haven't tested 2017 or 2022, but I assume they don't work either. AFAIK the official advice is to use Azure SQL Edge instead.

[my123 → draebek]

qemu-user is indeed hopelessly unsuitable for any kind of heavy use. Use anything else. :)

But that doesn't answer the question of "does Rosetta deal with it properly?".

[my123 → my123]

SQL Server doesn't work under Rosetta.

[draebek → my123]

Oh! Sorry, I didn't realize you were going to try it under Rosetta. That is very disappointing that Rosetta doesn't do any better. Thanks for testing.