{"id":15189,"date":"2013-07-11T13:00:00","date_gmt":"2013-07-11T12:00:00","guid":{"rendered":"https:\/\/aidanfinn.com\/?p=15189"},"modified":"2013-07-11T13:00:00","modified_gmt":"2013-07-11T12:00:00","slug":"best-practices-for-virtualizing-managing-sql-server-on-hyper-v","status":"publish","type":"post","link":"https:\/\/aidanfinn.com\/?p=15189","title":{"rendered":"Best Practices for Virtualizing &#038; Managing SQL Server On Hyper-V"},"content":{"rendered":"<p>This Microsoft-written <a href=\"http:\/\/download.microsoft.com\/download\/6\/1\/D\/61DDE9B6-AB46-48CA-8380-D7714C9CB1AB\/Best_Practices_for_Virtualizing_and_Managing_SQL_Server_2012.pdf\" target=\"_blank\">guide<\/a> provides high-level best practices and considerations for deploying and managing SQL Server 2012 on a Microsoft virtualization infrastructure. The recommendations and guidance in this document aim to: <\/p>\n<ul>\n<li>Complement the architectural design of an organization\u2019s specific environment.<\/li>\n<li>Help organizations take advantage of the key platform features in SQL Server 2012 to deliver the highest levels of performance and availability.<\/li>\n<\/ul>\n<p>There are lots of tips, requirements, and recommendations, such as this one for SQL Server VMs that are replicated using Hyper-V Replica.&#160; Yes, Hyper-V Replica is supported by SQL Server \u2013 ya hear that Exchange!?!?!<\/p>\n<p><a href=\"https:\/\/aidanfinn.com\/wp-content\/uploads\/2013\/07\/image3.png\"><img loading=\"lazy\" decoding=\"async\" title=\"image\" style=\"border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; float: none; padding-top: 0px; padding-left: 0px; margin-left: auto; border-left: 0px; display: block; padding-right: 0px; margin-right: auto\" border=\"0\" alt=\"image\" src=\"https:\/\/aidanfinn.com\/wp-content\/uploads\/2013\/07\/image_thumb3.png\" width=\"604\" height=\"212\" \/><\/a><\/p>\n<p>The setting in question can be found <a href=\"http:\/\/technet.microsoft.com\/en-us\/library\/hh848543.aspx\" target=\"_blank\">here<\/a> and can be enabled when <em>modifying<\/em> the replication of a VM using PowerShell.&#160; It:<\/p>\n<blockquote>\n<p>Determines whether all virtual hard disks selected for replication are replicated to the same point in time. This is useful if the virtual machine runs an application that saves data across virtual hard disks (for example, one virtual hard disk dedicated for application data, and another virtual hard disk dedicated for application log files).<\/p>\n<\/blockquote>\n<p>Long story short: it maintains consistency of an application across disks.<\/p>\n<div id=\"scid:0767317B-992E-4b12-91E0-4F059A8CECA8:d6f855b4-c2d7-4074-ab9d-577b4ca84423\" class=\"wlWriterEditableSmartContent\" style=\"float: none; padding-bottom: 0px; padding-top: 0px; padding-left: 0px; margin: 0px; display: inline; padding-right: 0px\">Technorati Tags: <a href=\"http:\/\/technorati.com\/tags\/Windows+Server+2012\" rel=\"tag\">Windows Server 2012<\/a>,<a href=\"http:\/\/technorati.com\/tags\/Hyper-V\" rel=\"tag\">Hyper-V<\/a>,<a href=\"http:\/\/technorati.com\/tags\/DR\" rel=\"tag\">DR<\/a>,<a href=\"http:\/\/technorati.com\/tags\/SQL\" rel=\"tag\">SQL<\/a>,<a href=\"http:\/\/technorati.com\/tags\/Virtualisation\" rel=\"tag\">Virtualisation<\/a><\/div>\n","protected":false},"excerpt":{"rendered":"<p>This Microsoft-written guide provides high-level best practices and considerations for deploying and managing SQL Server 2012 on a Microsoft virtualization infrastructure. The recommendations and guidance in this document aim to: Complement the architectural design of an organization\u2019s specific environment. Help organizations take advantage of the key platform features in SQL Server 2012 to deliver the &hellip; <a href=\"https:\/\/aidanfinn.com\/?p=15189\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Best Practices for Virtualizing &#038; Managing SQL Server On Hyper-V&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[20],"tags":[61,181,192,195,118],"class_list":["post-15189","post","type-post","status-publish","format-standard","hentry","category-hyper-v","tag-dr","tag-hyper-v","tag-sql","tag-virtualisation","tag-windows-server-2012"],"aioseo_notices":[],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"https:\/\/aidanfinn.com\/index.php?rest_route=\/wp\/v2\/posts\/15189","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/aidanfinn.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/aidanfinn.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/aidanfinn.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/aidanfinn.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=15189"}],"version-history":[{"count":0,"href":"https:\/\/aidanfinn.com\/index.php?rest_route=\/wp\/v2\/posts\/15189\/revisions"}],"wp:attachment":[{"href":"https:\/\/aidanfinn.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=15189"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/aidanfinn.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=15189"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/aidanfinn.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=15189"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}