{"id":2883,"date":"2012-12-06T10:00:00","date_gmt":"2012-12-06T18:00:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2012\/12\/06\/the-perfect-combination-sql-server-2012-windows-server-2012-and-system-center-2012\/"},"modified":"2024-01-22T22:49:27","modified_gmt":"2024-01-23T06:49:27","slug":"the-perfect-combination-sql-server-2012-windows-server-2012-and-system-center-2012","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/12\/06\/the-perfect-combination-sql-server-2012-windows-server-2012-and-system-center-2012\/","title":{"rendered":"The Perfect Combination: SQL Server 2012, Windows Server 2012 and System Center 2012"},"content":{"rendered":"<p><em><strong><span style=\"font-size: medium\">Delivering a Complete Data Platform for the Modern Datacenter with Cloud OS<\/span><\/strong><\/em><\/p>\n<p><span style=\"font-size: small\">Today\u2019s organizations need the ability to seamlessly build, deploy and manage applications and services across on-premise and cloud computing environments. The Cloud OS platform with Windows Server\u00ae 2012, Windows Azure, Microsoft\u00ae SQL Server\u00ae 2012, Microsoft System Center 2012 and <a href=\"http:\/\/www.microsoft.com\/visualstudio\/eng\/downloads\">Visual Studio 2012<\/a> work together to provide a consistent platform from on-premises to cloud computing environments.\u00a0 For database applications, we have identified 3 (three) important scenarios where customers will benefit with the Cloud OS platform:<\/span><\/p>\n<ol>\n<li><span style=\"font-size: small\">Tackling mission critical OLTP workload SLAs and performance requirements <\/span><\/li>\n<li><span style=\"font-size: small\">Revolutionizing enterprise data warehousing <\/span><\/li>\n<li><span style=\"font-size: small\">Migrating large mission critical SQL Server workloads into Microsoft private cloud<\/span><\/li>\n<\/ol>\n<p><span style=\"font-size: small\">For non-virtualized environments in an on-premises data center, Windows Server 2012 and <a href=\"http:\/\/www.microsoft.com\/sqlserver\/en\/us\/learning-center\/virtual-labs.aspx\">SQL Server 2012<\/a> provide the best platform for mission-critical workloads in these areas:<\/span><\/p>\n<ul>\n<li style=\"list-style-type: none\">\n<ul>\n<li><span style=\"font-size: small\"><strong>Performance &amp; Scalability:<\/strong>\u00a0 SQL Server 2012 can consume the operating system maximum for both processors and memory.\u00a0 Windows Server 2012 supports logical 640 processors (cores) over a max of 64 sockets and up to 4 TB of RAM, allowing SQL Server applications to scale to meet the demand of most mission critical applications. The new NIC Teaming feature in Windows Server 2012 allows 2 or more network adapters to behave as a single, virtual device.\u00a0 This improves the reliability of the networking subsystem \u2013 if one NIC dies, the other continues to function \u2013 and allows the bandwidth available to each to be pooled for greater total network throughput for SQL Server data. With SMB improvements in Windows Server 2012, SQL Server can store database files on remote (SMB) file shares, providing customers with many more deployment options for their database server storage. The new data de-duplication feature in Windows Server 2012 provides compression on steroids and delivers 30-90% storage savings for FILESTREAM BLOBs and other external files in SQL Server applications.<\/span><\/li>\n<li><span style=\"font-size: small\"><strong>Availability:<\/strong>\u00a0 SQL Server 2012 support for Windows Server Core is expected to eliminate the need for 50-60% of the OS-level patches.\u00a0 With Windows Server 2012, the server admin can configure the SQL Server to run with full support for graphical interfaces and then switch to run in Server Core mode. Cluster Aware Updating automates SQL Server cluster node maintenance, making the process easier, faster, more consistent and more reliable with significantly less downtime. With dynamic quorum management, the cluster can dynamically reconfigure itself to keep running down to the last surviving node to allow a SQL Server AlwaysOn cluster to adjust the number of quorum votes dynamically that are required to keep running, while simplifying set up by as much as 80%.<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><span style=\"font-size: small\">Organizations are also seeking a cloud-optimized IT infrastructure that can span from a private cloud behind your firewall to a public cloud behind a service provider\u2019s firewall.\u00a0 One key element to achieving this is having a common virtualization platform across private and public clouds.\u00a0 This increases efficiency and performance across infrastructures, which is essential for database applications. Windows Server 2012 offers the best virtualization platform for SQL Server 2012. By working together, SQL Server 2012, Windows Server 2012, and System Center 2012 offer a seamlessly integrated, on-premise and cloud-ready information platform to meet the demands of today\u2019s enterprise. <\/span><span style=\"font-size: small\">\u00a0Key benefits include:<\/span><\/p>\n<ul>\n<li style=\"list-style-type: none\">\n<ul>\n<li><span style=\"font-size: small\"><strong>Better Scalability:<\/strong> Higher capacity vCPUs (up to 64), memory (up to 1 TB), and VM density (up to 8,000 per cluster)<\/span><\/li>\n<li><span style=\"font-size: small\"><strong>Better Performance:<\/strong> Hyper-V support on NUMA and fiber channel<\/span><\/li>\n<li><span style=\"font-size: small\"><strong>Better Availability<\/strong>: Faster &amp; simultaneous live migration and dynamic quorum support in SQL Server AlwaysOn cluster<\/span><\/li>\n<li><span style=\"font-size: small\"><strong>Better Manageability<\/strong>: Same management tool (System Center) for SQL Server virtual machines in both private and public cloud<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><span style=\"font-size: small\">We have also published the <\/span><a href=\"http:\/\/download.microsoft.com\/download\/C\/C\/1\/CC16C89A-E289-4217-B2D8-7DD37A4285B8\/ESG-Lab-Validation-WS2012-HyperV-and-SQL2012.pdf\"><span style=\"font-size: small\">latest performance report for SQL Server 2012 running on Windows Server 2012 Hyper-V<\/span><\/a><span style=\"font-size: small\">. Key points from the performance report include:<\/span><\/p>\n<ul>\n<li style=\"list-style-type: none\">\n<ul>\n<li><span style=\"font-size: small\">With Windows Server 2012 Hyper-V\u2019s new support for up to 64 vCPUs, ESG Lab took an existing SQL Server 2012 OLTP workload that was previously vCPU limited and increased the performance by six times, while the average transaction response times improved by five times.<\/span><\/li>\n<li><span style=\"font-size: small\">Manageably-low Hyper-V overhead of 6.3% was recorded when comparing SQL Server 2012 OLTP workload performance of a physical server to a virtual machine configured with the same number of virtual CPU cores and the same amount of RAM.<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><span style=\"font-size: small\">When compared to VMware vSphere 5.1, Windows Server 2012 Hyper-V offers a number of advantages for SQL Server workloads:<\/span><\/p>\n<ul>\n<li style=\"list-style-type: none\">\n<ul>\n<li><span style=\"font-size: small\"><strong>Performance &amp; Scalability:<\/strong> Windows Server 2012 Hyper-V is better equipped to deploy mission critical SQL Server workloads in virtualized environment, allowing up to 64 virtual processors per VM with no SKU-specific restrictions. By contrast, the free vSphere Hypervisor, along with vSphere 5.1 Essentials, Essentials Plus and Standard editions support only 8 vCPUs per VM, with vSphere 5.1 Enterprise supporting 32vCPUs and only the most expensive edition, vSphere 5.1 Enterprise Plus, allows support up to 64 vCPUs. No such SKU-specific restrictions are in place with Hyper-V. Hyper-V offers superior performance for SQL Server virtualization, supporting 320 logical processors per host, whilst vSphere 5.1 supports just half that number, restricting scalability and density. Hyper-V also supports up to 4TB of host physical memory, with an individual VM able to utilize up to 1TB of memory. Compared with VMware, where the vSphere Hypervisor host physical memory is capped at 32GB and 2TB for vSphere 5.1 Enterprise Plus.<\/span><\/li>\n<li><span style=\"font-size: small\"><strong>Storage &amp; High Availability<\/strong>: For the mission critical SQL Server AlwaysOn scenario that makes use of Windows Server Failover Clustering (WSFC), customers retain full Hyper-V functionality, whereas when virtualizing Windows Server based clusters, VMware <\/span><a href=\"http:\/\/pubs.vmware.com\/vsphere-51\/index.jsp?topic=%2Fcom.vmware.vsphere.mscs.doc%2FGUID-6BD834AE-69BB-4D0E-B0B6-7E176907E0C7.html\" target=\"_blank\" rel=\"noopener\"><span style=\"font-size: small\">recommends<\/span><\/a><span style=\"font-size: small\"> turning off key features such as vMotion for VM mobility, DRS for dynamic resource allocation, Memory Overcommit, meaning sacrificed density, and finally, vSphere Fault Tolerance (FT). Also, when using Fiber Channel for Guest Clusters, VMware restrict scale to just 5 nodes. No such restriction applies with Hyper-V, with unmatched scale for failover clustering, with support for up to 64 nodes and 8,000 VMs per cluster. Hyper-V Live Migration also offers unlimited simultaneous Live Migrations and Shared-Nothing Live Migration for seamlessly moving VMs between hosts and clusters. Additionally, Hyper-V <\/span><a href=\"http:\/\/download.microsoft.com\/download\/E\/8\/E\/E8ECBD78-F07A-4A6F-9401-AA1760ED6985\/Competitive-Advantages-of-Windows-Server-Hyper-V-over-VMware-vSphere.pdf\" target=\"_blank\" rel=\"noopener\"><span style=\"font-size: small\">fully supports<\/span><\/a><span style=\"font-size: small\"> Guest Clustering with Live Migration and Dynamic memory, unlike VMware. On storage, Hyper-V is optimized to take advantage of increased capacity of single virtual disks to store huge databases, file repositories or document archives of up to 64TB in size, while vSphere is restricted to only 2TB per virtual disk. Hyper-V also supports the latest hardware innovations such as 4K Advanced Format Disks, which comes with higher capacities, better alignment and resiliency, and ultimately, higher performance. vSphere unfortunately, doesn\u2019t support this new innovation in hardware.<\/span><\/li>\n<li><span style=\"font-size: small\"><strong>Deployment &amp; Management<\/strong>: Hyper-V, combined with System Center, supports VM migration and management from private (behind your firewall) to public cloud (behind service provider\u2019s firewall) through a single pane of glass. This provides organizations with unparalleled levels of flexibility. Additionally, System Center not only supports Hyper-V, but also VMware vSphere and Citrix XenServer based infrastructures. Hyper-V, combined with System Center also provides complete infrastructure monitoring (hardware, hypervisor, operating system, and applications) which is especially useful for deploying, optimizing and monitoring the ongoing performance of workloads such as SQL Server. With VMware, customers are required to purchase expensive additional products to deliver any form of monitoring beyond the standard virtual machine metrics.<\/span><\/li>\n<li><span style=\"font-size: small\"><strong>Lower costs:<\/strong> Hyper-V provides a significantly lower total cost of ownership (TCO) than VMware vSphere for initial licensing and ongoing operations.<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><span style=\"font-size: small\">Hyper-V proves to be the best solution for virtualizing SQL Server databases, with superior capabilities in many areas, whilst offering significantly better TCO than VMware. Many customers understand the benefits outlined in the summary and they have chosen to run their SQL Servers using Hyper-V or have switched their existing SQL Server to Hyper-V from VMware.\u00a0<\/span><\/p>\n<p><span style=\"font-size: small\">Microsoft\u2019s Cloud OS platform consisting of SQL Server 2012, Windows Server 2012, System Center 2012, Windows Azure, and Visual Studio 2012 offer a unique and consistent platform, from on-premises, to cloud computing environments, to help organizations modernize their datacenters by leveraging the CAPEX and OPEX efficiencies that cloud computing environments provide. Customers should consider using this platform by trying <\/span><span style=\"font-size: small\">SQL Server 2012<\/span><span style=\"font-size: small\">, <\/span><span style=\"font-size: small\">Windows Server 2012<\/span><span style=\"font-size: small\">, <\/span><span style=\"font-size: small\">System Center 2012<\/span><span style=\"font-size: small\">, <\/span><a href=\"http:\/\/www.windowsazure.com\/en-us\/pricing\/free-trial\/\"><span style=\"font-size: small\">Windows Azure<\/span><\/a><span style=\"font-size: small\">, and <\/span><span style=\"font-size: small\">Visual Studio 2012<\/span><span style=\"font-size: small\">.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Delivering a Complete Data Platform for the Modern Datacenter with Cloud OS Today\u2019s organizations need the ability to seamlessly build, deploy and manage applications and services across on-premise and cloud computing environments.<\/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":[2445],"topic":[],"coauthors":[2487],"class_list":["post-2883","post","type-post","status-publish","format-standard","hentry","content-type-thought-leadership","review-flag-1593580414-58","review-flag-1593580410-819","review-flag-1-1593580431-15","review-flag-2-1593580436-981","review-flag-3-1593580441-293","review-flag-4-1593580446-456","review-flag-5-1593580452-31","review-flag-6-1593580457-144","review-flag-8-1593580467-480","review-flag-free-1593619513-128","review-flag-new-1593580247-437","review-flag-on-pr-1593580815-813","review-flag-vm-1593580806-223"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>The Perfect Combination: SQL Server 2012, Windows Server 2012 and System Center 2012 - 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\/2012\/12\/06\/the-perfect-combination-sql-server-2012-windows-server-2012-and-system-center-2012\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"The Perfect Combination: SQL Server 2012, Windows Server 2012 and System Center 2012 - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"Delivering a Complete Data Platform for the Modern Datacenter with Cloud OS Today\u2019s organizations need the ability to seamlessly build, deploy and manage applications and services across on-premise and cloud computing environments.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/12\/06\/the-perfect-combination-sql-server-2012-windows-server-2012-and-system-center-2012\/\" \/>\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=\"2012-12-06T18:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-23T06:49:27+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=\"5 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\/2012\/12\/06\/the-perfect-combination-sql-server-2012-windows-server-2012-and-system-center-2012\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/12\/06\/the-perfect-combination-sql-server-2012-windows-server-2012-and-system-center-2012\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/\",\"@type\":\"Person\",\"@name\":\"SQL Server Team\"}],\"headline\":\"The Perfect Combination: SQL Server 2012, Windows Server 2012 and System Center 2012\",\"datePublished\":\"2012-12-06T18:00:00+00:00\",\"dateModified\":\"2024-01-23T06:49:27+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/12\/06\/the-perfect-combination-sql-server-2012-windows-server-2012-and-system-center-2012\/\"},\"wordCount\":1304,\"commentCount\":3,\"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\/2012\/12\/06\/the-perfect-combination-sql-server-2012-windows-server-2012-and-system-center-2012\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/12\/06\/the-perfect-combination-sql-server-2012-windows-server-2012-and-system-center-2012\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/12\/06\/the-perfect-combination-sql-server-2012-windows-server-2012-and-system-center-2012\/\",\"name\":\"The Perfect Combination: SQL Server 2012, Windows Server 2012 and System Center 2012 - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\"},\"datePublished\":\"2012-12-06T18:00:00+00:00\",\"dateModified\":\"2024-01-23T06:49:27+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/12\/06\/the-perfect-combination-sql-server-2012-windows-server-2012-and-system-center-2012\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/12\/06\/the-perfect-combination-sql-server-2012-windows-server-2012-and-system-center-2012\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/12\/06\/the-perfect-combination-sql-server-2012-windows-server-2012-and-system-center-2012\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"The Perfect Combination: SQL Server 2012, Windows Server 2012 and System Center 2012\"}]},{\"@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":"The Perfect Combination: SQL Server 2012, Windows Server 2012 and System Center 2012 - 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\/2012\/12\/06\/the-perfect-combination-sql-server-2012-windows-server-2012-and-system-center-2012\/","og_locale":"en_US","og_type":"article","og_title":"The Perfect Combination: SQL Server 2012, Windows Server 2012 and System Center 2012 - Microsoft SQL Server Blog","og_description":"Delivering a Complete Data Platform for the Modern Datacenter with Cloud OS Today\u2019s organizations need the ability to seamlessly build, deploy and manage applications and services across on-premise and cloud computing environments.","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/12\/06\/the-perfect-combination-sql-server-2012-windows-server-2012-and-system-center-2012\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2012-12-06T18:00:00+00:00","article_modified_time":"2024-01-23T06:49:27+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":"5 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/12\/06\/the-perfect-combination-sql-server-2012-windows-server-2012-and-system-center-2012\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/12\/06\/the-perfect-combination-sql-server-2012-windows-server-2012-and-system-center-2012\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/","@type":"Person","@name":"SQL Server Team"}],"headline":"The Perfect Combination: SQL Server 2012, Windows Server 2012 and System Center 2012","datePublished":"2012-12-06T18:00:00+00:00","dateModified":"2024-01-23T06:49:27+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/12\/06\/the-perfect-combination-sql-server-2012-windows-server-2012-and-system-center-2012\/"},"wordCount":1304,"commentCount":3,"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\/2012\/12\/06\/the-perfect-combination-sql-server-2012-windows-server-2012-and-system-center-2012\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/12\/06\/the-perfect-combination-sql-server-2012-windows-server-2012-and-system-center-2012\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/12\/06\/the-perfect-combination-sql-server-2012-windows-server-2012-and-system-center-2012\/","name":"The Perfect Combination: SQL Server 2012, Windows Server 2012 and System Center 2012 - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website"},"datePublished":"2012-12-06T18:00:00+00:00","dateModified":"2024-01-23T06:49:27+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/12\/06\/the-perfect-combination-sql-server-2012-windows-server-2012-and-system-center-2012\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/12\/06\/the-perfect-combination-sql-server-2012-windows-server-2012-and-system-center-2012\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/12\/06\/the-perfect-combination-sql-server-2012-windows-server-2012-and-system-center-2012\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"The Perfect Combination: SQL Server 2012, Windows Server 2012 and System Center 2012"}]},{"@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\/2883","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=2883"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/2883\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=2883"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=2883"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=2883"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=2883"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=2883"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=2883"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}