{"id":237,"date":"2021-04-17T20:26:51","date_gmt":"2021-04-17T18:26:51","guid":{"rendered":"https:\/\/threedots.ovh\/blog\/?p=237"},"modified":"2022-04-26T22:27:31","modified_gmt":"2022-04-26T20:27:31","slug":"sql-server-on-arm","status":"publish","type":"post","link":"https:\/\/threedots.ovh\/blog\/2021\/04\/sql-server-on-arm\/","title":{"rendered":"SQL Server on Arm"},"content":{"rendered":"\n<p>Microsoft has an <em>edge<\/em> SQL Server product that is also available on 64-bit Arm in addition of x86 processors, offering core functionality. <\/p>\n\n\n\n<p>However, forget about .NET extensibility, snapshots, replication and <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/azure-sql-edge\/features\">other features<\/a> that are excluded from this product.<\/p>\n\n\n\n<p>The <em>Developer<\/em> edition of Azure SQL Edge is limited to 4 cores and 32GB of RAM.<\/p>\n\n\n\n<p>The SQL Server on Linux <a href=\"https:\/\/threedots.ovh\/blog\/2021\/01\/drawbridge-what-sql-server-on-linux-is-built-on\/\" data-type=\"post\" data-id=\"146\" target=\"_blank\" rel=\"noreferrer noopener\">infrastructure<\/a> is used, with the container OS being based on Windows build 10.0.17134 (corresponding to Windows 10 version 1803). Those images, including the NT user-mode kernel, are <em>shared<\/em> with the x86_64 version.<\/p>\n\n\n\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/azure-sql-edge\/\">Azure SQL Edge<\/a> can be pulled from Microsoft&#8217;s container registry.  <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>docker pull mcr.microsoft.com\/azure-sql-edge:latest<\/code><\/pre>\n\n\n\n<p>You can then run it with:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo docker run --cap-add SYS_PTRACE -e 'ACCEPT_EULA=1' -e 'MSSQL_SA_PASSWORD=yourStrong(!)Password' -p 1433:1433 --name azuresqledge -d mcr.microsoft.com\/azure-sql-edge<\/code><\/pre>\n\n\n\n<p>The binaries are statically translated through <em>sbtrans<\/em> by Microsoft to be able to run on 64-bit Arm processors. <\/p>\n\n\n\n<p><em>sbtrans<\/em>&#8216;s runtime library, libsbtrntm.so, doesn&#8217;t have a JIT fallback. As such, this is a fully ahead of time translation.<\/p>\n\n\n\n<p>Those translations are stored at \/opt\/mssql\/lib\/sbt, with a hash of the binary used to lookup translated files. The location for the translations is configurable via the PAL_SBT_SEARCH_PATH environment variable.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Microsoft has an edge SQL Server product that is also available on 64-bit Arm in addition of x86 processors, offering core functionality. However, forget about .NET extensibility, snapshots, replication and other features that are excluded from this product. The Developer edition of Azure SQL Edge is limited to 4 cores and 32GB of RAM. The&hellip;&nbsp;<a href=\"https:\/\/threedots.ovh\/blog\/2021\/04\/sql-server-on-arm\/\" rel=\"bookmark\">Read More &raquo;<span class=\"screen-reader-text\">SQL Server on Arm<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-237","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/threedots.ovh\/blog\/wp-json\/wp\/v2\/posts\/237","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/threedots.ovh\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/threedots.ovh\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/threedots.ovh\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/threedots.ovh\/blog\/wp-json\/wp\/v2\/comments?post=237"}],"version-history":[{"count":5,"href":"https:\/\/threedots.ovh\/blog\/wp-json\/wp\/v2\/posts\/237\/revisions"}],"predecessor-version":[{"id":337,"href":"https:\/\/threedots.ovh\/blog\/wp-json\/wp\/v2\/posts\/237\/revisions\/337"}],"wp:attachment":[{"href":"https:\/\/threedots.ovh\/blog\/wp-json\/wp\/v2\/media?parent=237"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/threedots.ovh\/blog\/wp-json\/wp\/v2\/categories?post=237"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/threedots.ovh\/blog\/wp-json\/wp\/v2\/tags?post=237"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}