{"id":5663,"date":"2009-09-02T11:57:00","date_gmt":"2009-09-02T18:57:00","guid":{"rendered":""},"modified":"2024-01-22T22:52:06","modified_gmt":"2024-01-23T06:52:06","slug":"microsoft-virtualization-best-choices-for-sql-server","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2009\/09\/02\/microsoft-virtualization-best-choices-for-sql-server\/","title":{"rendered":"Microsoft Virtualization: Best Choices for SQL Server"},"content":{"rendered":"<p>Should I virtualize SQL Server? What benefits will I see?\u00a0 What do I need to consider when making this decision?\u00a0 These are some of the questions we are frequently asked as <a href=\"http:\/\/www.microsoft.com\/sqlserver\/2008\/en\/us\/virtualization.aspx\">Virtualization<\/a> continues to be a hot topic.\u00a0 The short answer is yes \u2013 <a href=\"http:\/\/www.microsoft.com\/virtualization\/solutions\/business-critical-applications\/default.mspx\">Microsoft Virtualization<\/a> (Windows Server 2008 R2 Hyper-V + Microsoft System Center) delivers significant benefits including reduced costs through server consolidation and power and space savings, improved server utilization, greater agility for responding to dynamic business needs, rapid server provisioning, reduced management complexity and reduced downtime during failover with Hyper-V Live Migration.\u00a0 By choosing Microsoft Virtualization with SQL Server, customers benefit from a lower cost solution that is already part of Windows Server and an integrated end to end management solution for both physical and virtual environments.<\/p>\n<p>Companies looking at virtualizing SQL Server should first consider the deployment scenario. In many cases we see data centers with a mix of physical and virtual instances.\u00a0 Some scenarios that are ripe for virtualization include: consolidating underutilized servers, BI components such as Analysis Services and Reporting Services, managing high availability with Hyper-V Live Migration for hardware maintenance, remote site consolidation with Database Mirroring, and development and test environments.\u00a0 Windows 2008 R2 and Hyper-V effectively exploit recent hardware virtualization advances by the processor vendors.\u00a0 As a result, the performance overhead for virtualized workloads is reduced dramatically. That said, there are a set of workloads with a demanding set of requirements (high-volume transactional databases with thousands of concurrent users or high utilization scenarios like large data warehouse SQL Server instances supporting many Analysis Services cubes and Reporting Servers) that may not be good candidates for virtualization.\u201d Whether you install on physical hardware or virtual machines, SQL Server, Windows Server and System Center will provide the right solution for your needs.<\/p>\n<p>Companies using virtualization with SQL Server can take advantage of some of the licensing benefits of SQL Server Enterprise.\u00a0 For example, you can create deploy an unlimited number of virtual machines on a server if all the physical processors are licensed for SQL Server Enterprise.\u00a0 Also, with SQL Server Enterprise, you can increase the mobility of your deployments to better optimize existing investments, as SQL Server Enterprise enables you to re-assign licenses in a server farm as often as needed for load distribution and maintenance operations.\u00a0 Finally, if you are using SQL Server Enterprise you will see additional benefits from reduced storage through Data and Backup Compression, as well as benefits from the highest levels of security, scalability and high availability.<\/p>\n<p>At TechEd 2009, Microsoft announced SQL Server support for Guest Clustering on Hyper-V with SQL Server 2008, providing greater high availability support for Microsoft Virtualization.\u00a0 As we prepare for upcoming product\u00a0 releases, such as SQL Server R2, we will look for even more opportunities for SQL Server , Windows Server and System Center to take advantage of hardware advances and continue to enhance the virtualization experience.<\/p>\n<p>For information on SQL Server including best practices with virtualization, visit the <a href=\"http:\/\/www.microsoft.com\/sqlserver\/2008\/en\/us\/virtualization.aspx\">SQL Server Virtualization<\/a> home page. For detailed information on SQL Server Virtualization Licensing, review the \u201cVirtualization and License Mobility\u201d section of the <a href=\"http:\/\/download.microsoft.com\/download\/6\/F\/8\/6F84A9FE-1E5C-44CC-87BB-C236BFCBA4DF\/SQLServer2008_LicensingGuide.pdf\">SQL Server Licensing Guide<\/a>. For more information on Microsoft Virtualization, visit\u00a0 <a href=\"http:\/\/www.microsoft.com\/virtualization\/solutions\/business-critical-applications\/default.mspx\">Virtualizing Microsoft Server Applications<\/a>.\u00a0 Finally, to learn about Microsoft\u2019s Consolidation efforts using Microsoft Virtualization, visit <a href=\"http:\/\/msdn.microsoft.com\/en-us\/architecture\/dd393309.aspx\">Green IT in Practice: SQL Server Consolidation in Microsoft IT<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Should I virtualize SQL Server? What benefits will I see?\u00a0 What do I need to consider when making this decision?\u00a0 These are some of the questions we are frequently asked as Virtualization continues to be a hot topic.<\/p>\n","protected":false},"author":1457,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","footnotes":""},"post_tag":[],"product":[],"content-type":[2424],"topic":[],"coauthors":[],"class_list":["post-5663","post","type-post","status-publish","format-standard","hentry","content-type-best-practices","review-flag-1593580419-556"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Microsoft Virtualization: Best Choices for SQL Server - Microsoft SQL Server Blog<\/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.microsoft.com\/en-us\/sql-server\/blog\/2009\/09\/02\/microsoft-virtualization-best-choices-for-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Microsoft Virtualization: Best Choices for SQL Server - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"Should I virtualize SQL Server? What benefits will I see?\u00a0 What do I need to consider when making this decision?\u00a0 These are some of the questions we are frequently asked as Virtualization continues to be a hot topic.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2009\/09\/02\/microsoft-virtualization-best-choices-for-sql-server\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft SQL Server Blog\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/sqlserver\" \/>\n<meta property=\"article:published_time\" content=\"2009-09-02T18:57:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-23T06:52:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/08\/cropped-microsoft_logo_element.png\" \/>\n\t<meta property=\"og:image:width\" content=\"512\" \/>\n\t<meta property=\"og:image:height\" content=\"512\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"SQL Server Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:site\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"SQL Server Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 min read\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2009\/09\/02\/microsoft-virtualization-best-choices-for-sql-server\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2009\/09\/02\/microsoft-virtualization-best-choices-for-sql-server\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/\",\"@type\":\"Person\",\"@name\":\"SQL Server Team\"}],\"headline\":\"Microsoft Virtualization: Best Choices for SQL Server\",\"datePublished\":\"2009-09-02T18:57:00+00:00\",\"dateModified\":\"2024-01-23T06:52:06+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2009\/09\/02\/microsoft-virtualization-best-choices-for-sql-server\/\"},\"wordCount\":556,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2009\/09\/02\/microsoft-virtualization-best-choices-for-sql-server\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2009\/09\/02\/microsoft-virtualization-best-choices-for-sql-server\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2009\/09\/02\/microsoft-virtualization-best-choices-for-sql-server\/\",\"name\":\"Microsoft Virtualization: Best Choices for SQL Server - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\"},\"datePublished\":\"2009-09-02T18:57:00+00:00\",\"dateModified\":\"2024-01-23T06:52:06+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2009\/09\/02\/microsoft-virtualization-best-choices-for-sql-server\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2009\/09\/02\/microsoft-virtualization-best-choices-for-sql-server\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2009\/09\/02\/microsoft-virtualization-best-choices-for-sql-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Microsoft Virtualization: Best Choices for SQL Server\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"name\":\"Microsoft SQL Server Blog\",\"description\":\"Official News from Microsoft\u2019s Information Platform\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\",\"name\":\"Microsoft SQL Server Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"width\":259,\"height\":194,\"caption\":\"Microsoft SQL Server Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"http:\/\/www.facebook.com\/sqlserver\",\"https:\/\/x.com\/SQLServer\",\"https:\/\/www.youtube.com\/user\/MSCloudOS\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Microsoft Virtualization: Best Choices for SQL Server - Microsoft SQL Server Blog","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.microsoft.com\/en-us\/sql-server\/blog\/2009\/09\/02\/microsoft-virtualization-best-choices-for-sql-server\/","og_locale":"en_US","og_type":"article","og_title":"Microsoft Virtualization: Best Choices for SQL Server - Microsoft SQL Server Blog","og_description":"Should I virtualize SQL Server? What benefits will I see?\u00a0 What do I need to consider when making this decision?\u00a0 These are some of the questions we are frequently asked as Virtualization continues to be a hot topic.","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2009\/09\/02\/microsoft-virtualization-best-choices-for-sql-server\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2009-09-02T18:57:00+00:00","article_modified_time":"2024-01-23T06:52:06+00:00","og_image":[{"width":512,"height":512,"url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/08\/cropped-microsoft_logo_element.png","type":"image\/png"}],"author":"SQL Server Team","twitter_card":"summary_large_image","twitter_creator":"@SQLServer","twitter_site":"@SQLServer","twitter_misc":{"Written by":"SQL Server Team","Est. reading time":"2 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2009\/09\/02\/microsoft-virtualization-best-choices-for-sql-server\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2009\/09\/02\/microsoft-virtualization-best-choices-for-sql-server\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/","@type":"Person","@name":"SQL Server Team"}],"headline":"Microsoft Virtualization: Best Choices for SQL Server","datePublished":"2009-09-02T18:57:00+00:00","dateModified":"2024-01-23T06:52:06+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2009\/09\/02\/microsoft-virtualization-best-choices-for-sql-server\/"},"wordCount":556,"commentCount":0,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2009\/09\/02\/microsoft-virtualization-best-choices-for-sql-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2009\/09\/02\/microsoft-virtualization-best-choices-for-sql-server\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2009\/09\/02\/microsoft-virtualization-best-choices-for-sql-server\/","name":"Microsoft Virtualization: Best Choices for SQL Server - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website"},"datePublished":"2009-09-02T18:57:00+00:00","dateModified":"2024-01-23T06:52:06+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2009\/09\/02\/microsoft-virtualization-best-choices-for-sql-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2009\/09\/02\/microsoft-virtualization-best-choices-for-sql-server\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2009\/09\/02\/microsoft-virtualization-best-choices-for-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"Microsoft Virtualization: Best Choices for SQL Server"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","name":"Microsoft SQL Server Blog","description":"Official News from Microsoft\u2019s Information Platform","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization","name":"Microsoft SQL Server Blog","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","width":259,"height":194,"caption":"Microsoft SQL Server Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/"},"sameAs":["http:\/\/www.facebook.com\/sqlserver","https:\/\/x.com\/SQLServer","https:\/\/www.youtube.com\/user\/MSCloudOS"]}]}},"msxcm_display_generated_audio":false,"msxcm_animated_featured_image":null,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/5663","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/users\/1457"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/comments?post=5663"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/5663\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=5663"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=5663"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=5663"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=5663"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=5663"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=5663"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}