{"id":79955,"date":"2022-05-06T06:00:03","date_gmt":"2022-05-06T14:00:03","guid":{"rendered":"https:\/\/sqlrus.com\/?p=11098"},"modified":"2022-05-06T06:00:03","modified_gmt":"2022-05-06T14:00:03","slug":"running-sql-server-on-synology-2","status":"publish","type":"post","link":"https:\/\/www.dcac.com\/2022\/05\/06\/running-sql-server-on-synology-2\/","title":{"rendered":"Running SQL Server on Synology"},"content":{"rendered":"

Last Updated on January 23, 2023 by John Morehouse<\/p>\n

Synology has a wide range of capabilities but sometimes it still falls short.<\/p>\n

In a previous post, I mentioned moving existing virtual machines to my Synology DS920+.\u00a0 The movement of the virtual machines required configuring the virtual machine locally on my laptop and then subsequently moving the “bundle” to the Synology.\u00a0 This effectively meant that I was running the virtual machine across the local area network (LAN).\u00a0 As you might imagine, overall performance tanked.\u00a0 Any CPU related workloads would happen locally on my laptop however any disk I\/O requests would traverse the network, and well, sucked.<\/p>\n

Virtual Machine Manager<\/span><\/h3>\n

Synology offers the ability to create and maintain full blown virtual machines locally.\u00a0 This would be synonymous to having a VMWare ESXi host running somewhere inside your house.\u00a0 Unfortunately, with my model of Synology, it’s lacking severely in the memory department.<\/p>\n

4GB of memory is all she’s got Capt’n!<\/p>\n

\"\"<\/a><\/p>\n

4GB of memory is minimal in order to run a virtual machine on Synology.\u00a0 Operating systems such as Windows require a decent amount of memory to function and it does not even address the need for SQL Server to have all the memory it can.<\/p>\n

Docker<\/span><\/h3>\n

Another possible solution is to run a Docker container.\u00a0 Docker is platform that is designed to run containers and you can run it on a Synology NAS device.\u00a0 Containers is the next evolution within the virtualization space.\u00a0 Effectively, containers further remove layers by abstracting away the operating system entirely.\u00a0 \u00a0Each container allows minimal deployment of applications and services that are needed.\u00a0 The operating system kernel (usually Linux) is an abstraction layer that sits below each container.<\/p>\n

While this is a potential solution, the minimum requirements to run a SQL Server container is 2GB.\u00a0 \u00a0Given that my Synology only has 4GB available, essentially I need to upgrade the hardware.<\/p>\n

Remember, even with virtualization or containers, it still has to run on hardware beneath the hood.<\/p>\n

However, at the moment I am unable to pull the appropriate container image needed so this will be a work in progress.<\/p>\n

Stay tuned!<\/p>\n

© 2022 – 2023, John Morehouse<\/a>. All rights reserved. <\/p>The post Running SQL Server on Synology<\/a> first appeared on John Morehouse<\/a>.","protected":false},"excerpt":{"rendered":"

Last Updated on January 23, 2023 by John Morehouse Synology has a wide range of capabilities but sometimes it still falls short. In a previous post, I mentioned moving existing virtual machines to my Synology DS920+.\u00a0 The movement of the virtual machines required configuring the virtual machine locally on my laptop and then subsequently moving [\u2026]<\/p>\n

The post Running SQL Server on Synology<\/a> first appeared on John Morehouse<\/a>.<\/p>\n","protected":false},"author":196,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[551,589,657,687],"tags":[563],"class_list":["post-79955","post","type-post","status-publish","format-standard","hentry","category-blog","category-docker","category-synology","category-virtualization","tag-donotrepost"],"yoast_head":"\nRunning SQL Server on Synology – Denny Cherry & Associates Consulting<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dcac.com\/2022\/05\/06\/running-sql-server-on-synology-2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Running SQL Server on Synology – Denny Cherry & Associates Consulting\" \/>\n<meta property=\"og:description\" content=\"Last Updated on January 23, 2023 by John Morehouse Synology has a wide range of capabilities but sometimes it still falls short. In a previous post, I mentioned moving existing virtual machines to my Synology DS920+.\u00a0 The movement of the virtual machines required configuring the virtual machine locally on my laptop and then subsequently moving [\u2026] The post Running SQL Server on Synology first appeared on John Morehouse.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dcac.com\/2022\/05\/06\/running-sql-server-on-synology-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Denny Cherry & Associates Consulting\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DennyCherryAssociatesConsulting\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-05-06T14:00:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/i0.wp.com\/sqlrus.com\/wp-content\/uploads\/2023\/01\/synology_memory.png?resize=554%2C161&ssl=1\" \/>\n<meta name=\"author\" content=\"John Morehouse\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@dcacco\" \/>\n<meta name=\"twitter:site\" content=\"@dcacco\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"John Morehouse\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dcac.com\/2022\/05\/06\/running-sql-server-on-synology-2\/\",\"url\":\"https:\/\/www.dcac.com\/2022\/05\/06\/running-sql-server-on-synology-2\/\",\"name\":\"Running SQL Server on Synology – Denny Cherry & Associates Consulting\",\"isPartOf\":{\"@id\":\"https:\/\/www.dcac.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dcac.com\/2022\/05\/06\/running-sql-server-on-synology-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dcac.com\/2022\/05\/06\/running-sql-server-on-synology-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/i0.wp.com\/sqlrus.com\/wp-content\/uploads\/2023\/01\/synology_memory.png?resize=554%2C161&ssl=1\",\"datePublished\":\"2022-05-06T14:00:03+00:00\",\"dateModified\":\"2022-05-06T14:00:03+00:00\",\"author\":{\"@id\":\"https:\/\/www.dcac.com\/#\/schema\/person\/661abeccdb22eb8c20701e08358c91a1\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dcac.com\/2022\/05\/06\/running-sql-server-on-synology-2\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dcac.com\/2022\/05\/06\/running-sql-server-on-synology-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dcac.com\/2022\/05\/06\/running-sql-server-on-synology-2\/#primaryimage\",\"url\":\"https:\/\/i0.wp.com\/sqlrus.com\/wp-content\/uploads\/2023\/01\/synology_memory.png?resize=554%2C161&ssl=1\",\"contentUrl\":\"https:\/\/i0.wp.com\/sqlrus.com\/wp-content\/uploads\/2023\/01\/synology_memory.png?resize=554%2C161&ssl=1\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dcac.com\/2022\/05\/06\/running-sql-server-on-synology-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.dcac.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Running SQL Server on Synology\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dcac.com\/#website\",\"url\":\"https:\/\/www.dcac.com\/\",\"name\":\"Denny Cherry & Associates Consulting\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dcac.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dcac.com\/#\/schema\/person\/661abeccdb22eb8c20701e08358c91a1\",\"name\":\"John Morehouse\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dcac.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/bcf7bc0ca56e9be3234aab4eb91bb8a0?s=96&r=x\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/bcf7bc0ca56e9be3234aab4eb91bb8a0?s=96&r=x\",\"caption\":\"John Morehouse\"},\"url\":\"https:\/\/www.dcac.com\/author\/johndcac-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Running SQL Server on Synology – Denny Cherry & Associates Consulting","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dcac.com\/2022\/05\/06\/running-sql-server-on-synology-2\/","og_locale":"en_US","og_type":"article","og_title":"Running SQL Server on Synology – Denny Cherry & Associates Consulting","og_description":"Last Updated on January 23, 2023 by John Morehouse Synology has a wide range of capabilities but sometimes it still falls short. In a previous post, I mentioned moving existing virtual machines to my Synology DS920+.\u00a0 The movement of the virtual machines required configuring the virtual machine locally on my laptop and then subsequently moving [\u2026] The post Running SQL Server on Synology first appeared on John Morehouse.","og_url":"https:\/\/www.dcac.com\/2022\/05\/06\/running-sql-server-on-synology-2\/","og_site_name":"Denny Cherry & Associates Consulting","article_publisher":"https:\/\/www.facebook.com\/DennyCherryAssociatesConsulting\/","article_published_time":"2022-05-06T14:00:03+00:00","og_image":[{"url":"https:\/\/i0.wp.com\/sqlrus.com\/wp-content\/uploads\/2023\/01\/synology_memory.png?resize=554%2C161&ssl=1","type":"","width":"","height":""}],"author":"John Morehouse","twitter_card":"summary_large_image","twitter_creator":"@dcacco","twitter_site":"@dcacco","twitter_misc":{"Written by":"John Morehouse","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.dcac.com\/2022\/05\/06\/running-sql-server-on-synology-2\/","url":"https:\/\/www.dcac.com\/2022\/05\/06\/running-sql-server-on-synology-2\/","name":"Running SQL Server on Synology – Denny Cherry & Associates Consulting","isPartOf":{"@id":"https:\/\/www.dcac.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dcac.com\/2022\/05\/06\/running-sql-server-on-synology-2\/#primaryimage"},"image":{"@id":"https:\/\/www.dcac.com\/2022\/05\/06\/running-sql-server-on-synology-2\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/sqlrus.com\/wp-content\/uploads\/2023\/01\/synology_memory.png?resize=554%2C161&ssl=1","datePublished":"2022-05-06T14:00:03+00:00","dateModified":"2022-05-06T14:00:03+00:00","author":{"@id":"https:\/\/www.dcac.com\/#\/schema\/person\/661abeccdb22eb8c20701e08358c91a1"},"breadcrumb":{"@id":"https:\/\/www.dcac.com\/2022\/05\/06\/running-sql-server-on-synology-2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dcac.com\/2022\/05\/06\/running-sql-server-on-synology-2\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dcac.com\/2022\/05\/06\/running-sql-server-on-synology-2\/#primaryimage","url":"https:\/\/i0.wp.com\/sqlrus.com\/wp-content\/uploads\/2023\/01\/synology_memory.png?resize=554%2C161&ssl=1","contentUrl":"https:\/\/i0.wp.com\/sqlrus.com\/wp-content\/uploads\/2023\/01\/synology_memory.png?resize=554%2C161&ssl=1"},{"@type":"BreadcrumbList","@id":"https:\/\/www.dcac.com\/2022\/05\/06\/running-sql-server-on-synology-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dcac.com\/"},{"@type":"ListItem","position":2,"name":"Running SQL Server on Synology"}]},{"@type":"WebSite","@id":"https:\/\/www.dcac.com\/#website","url":"https:\/\/www.dcac.com\/","name":"Denny Cherry & Associates Consulting","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dcac.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dcac.com\/#\/schema\/person\/661abeccdb22eb8c20701e08358c91a1","name":"John Morehouse","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dcac.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/bcf7bc0ca56e9be3234aab4eb91bb8a0?s=96&r=x","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/bcf7bc0ca56e9be3234aab4eb91bb8a0?s=96&r=x","caption":"John Morehouse"},"url":"https:\/\/www.dcac.com\/author\/johndcac-com\/"}]}},"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/www.dcac.com\/wp-json\/wp\/v2\/posts\/79955","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dcac.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dcac.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dcac.com\/wp-json\/wp\/v2\/users\/196"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dcac.com\/wp-json\/wp\/v2\/comments?post=79955"}],"version-history":[{"count":2,"href":"https:\/\/www.dcac.com\/wp-json\/wp\/v2\/posts\/79955\/revisions"}],"predecessor-version":[{"id":83175,"href":"https:\/\/www.dcac.com\/wp-json\/wp\/v2\/posts\/79955\/revisions\/83175"}],"wp:attachment":[{"href":"https:\/\/www.dcac.com\/wp-json\/wp\/v2\/media?parent=79955"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dcac.com\/wp-json\/wp\/v2\/categories?post=79955"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dcac.com\/wp-json\/wp\/v2\/tags?post=79955"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}