SQL Server can run on ARM64 quite well, but it depends upon your usecase. However, it's not going to work out of the box - the first issue is the installation which will fail on ARM64. The solution to that is to use my scripts that someone here already mentioned: https://github.com/jimm98y/MSSQLEXPRESS-M1-Install
These will workaround the 2 problematic components of the installation that are causing it to fail:
- AzureAttestService (I have no idea what this one does)
- FileStream driver (it's a system driver, so Microsoft would have to compile it natively for ARM64 to make it work)
With these out of the way, the SQL installation succeeds.
Next issue after the installation will be in the GUI configuration (at least some part of it). On ARM64, Microsoft compiled mmc.exe for ARM64 (instead of ARM64EC) which means mmc won't be able to load the configuration DLLs. So for instance if you want to enable TCP, you have to do it by manually editing the registry keys: https://github.com/jimm98y/MSSQLEXPRESS-M1-Install/issues/4
Finally, some advanced features such as SQL Replication might not be working - I've never needed them, so I did not investigate the reasons why.
This being said, it's definitely possible to run SQL Server on ARM64 in emulation and for general NET development tasks it works quite well.