{"id":5103,"date":"2010-05-10T10:32:00","date_gmt":"2010-05-10T17:32:00","guid":{"rendered":""},"modified":"2024-01-22T22:52:08","modified_gmt":"2024-01-23T06:52:08","slug":"make-your-servers-work-harder-consolidate-with-sql-server-2008-r2","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2010\/05\/10\/make-your-servers-work-harder-consolidate-with-sql-server-2008-r2\/","title":{"rendered":"Make your servers work harder: Consolidate with SQL Server 2008 R2!"},"content":{"rendered":"
\nSQL Server 2008 R2 introduces several new features which significantly expand upon existing support for working in, managing, and leveraging a multi-instance SQL Server environment.\u00a0 <\/span>This blog post will focus on three of the new areas to improve your consolidation experience by using SQL Server 2008 R2.<\/span><\/span><\/p>\n
First, we have dramatically increased the number of logical processors we support.\u00a0 <\/span>Gone is the 64 processor limitation; SQL Server 2008 R2 can now scale with Windows Server 2008 R2 up to 256 logical processors!\u00a0 <\/span>This means you can run more workloads, more queries, and have more users accessing your SQL Server instances simply by moving to newer\/larger hardware.<\/span><\/span><\/div>\n
Second, Microsoft\u2019s investment in application and multi-server management will help SQL Server administrators manage database environments more efficiently at scale.\u00a0 A core concept to application and multi-server management is the addition of the Utility Control Point, which enables a centralized view of SQL Server instances and database applications and their utilization across the designated managed server group.\u00a0 And for administrators who use System Center to monitor and manage their SQL Server instances, we are introducing a new SQL Management Pack which removes the DMO dependency, improves the health model (particularly around storage monitoring), and reduces noise and false alerts.<\/span><\/div>\n
\n<\/span>\u00a0<\/div>\n
\nLast but not least, SQL Server 2008 R2 fully leverages the new Live Migration feature delivered as part of the Windows Server 2008 R2 Hyper-V release.\u00a0 <\/span>This provides even greater benefits to virtualizing and running your SQL Server instance in a virtual machine by providing zero planned downtime.\u00a0 <\/span>You can also leverage System Center Virtual Machine Manager Performance and Resource Optimization to dynamically load balance your SQL Server workloads in a multi-machine\/multi-instance environment.\u00a0 <\/span>A great video explaining this is more detail is available here: <\/span>http:\/\/www.microsoft.com\/sqlserver\/tour\/en\/videos\/business-continuity-windows-server-2008-r2-hyper-v-live-migration.aspx<\/span><\/a>\n<\/div>\n
Putting it all together, we ran a test simulating the consolidation of multiple applications onto a new 32 core server running Windows Server 2008 R2 and SQL Server 2008 R2.\u00a0 <\/span>We used three of the most common consolidation methods: virtualization (one machine with multiple VM\u2019s each with one SQL Server instance), instance (one machine with multiple SQL Server instances running natively), and database (one machine with one SQL Server instance and multiple independent databases).\u00a0 <\/span>As this chart shows, we were able to achieve consistent results across each consolidation method even up to 40 applications running simultaneously (and yes, this does mean 40 VM\u2019s running simultaneously)!<\/span><\/span><\/div>\n\n\n\n\n\n\n\n\n\n\n\n\n
\n
Consolidation method<\/span><\/span><\/span><\/b><\/div>\n<\/td>\n
\n
Number of applications<\/span><\/span><\/span><\/b><\/div>\n<\/td>\n
\n
Throughput <\/span><\/span><\/span><\/b><\/div>\n<\/td>\n
\n
Response time <\/span><\/span><\/span><\/b><\/div>\n<\/td>\n
\n
Host system CPU utilization<\/span><\/span><\/span><\/b><\/div>\n<\/td>\n<\/tr>\n
\n
Baseline (old hardware)<\/span><\/span><\/span><\/div>\n<\/td>\n
\n
1<\/span><\/span><\/span><\/div>\n<\/td>\n
\n
100%<\/span><\/span><\/span><\/div>\n<\/td>\n
\n
100%<\/span><\/span><\/span><\/div>\n<\/td>\n
\n
6%<\/span><\/span><\/span><\/div>\n<\/td>\n<\/tr>\n
\n
\u00a0<\/span><\/span><\/div>\n<\/td>\n<\/tr>\n
\n
Virtualization<\/span><\/span><\/span><\/div>\n<\/td>\n
\n
24<\/span><\/span><\/span><\/div>\n<\/td>\n
\n
+0.8%<\/span><\/span><\/span><\/div>\n<\/td>\n
\n
80%<\/span><\/span><\/span><\/div>\n<\/td>\n
\n
24%<\/span><\/span><\/span><\/div>\n<\/td>\n<\/tr>\n
\n
Instance<\/span><\/span><\/span><\/div>\n<\/td>\n
\n
24<\/span><\/span><\/span><\/div>\n<\/td>\n
\n
+0.6%<\/span><\/span><\/span><\/div>\n<\/td>\n
\n
58%<\/span><\/span><\/span><\/div>\n<\/td>\n
\n
20%<\/span><\/span><\/span><\/div>\n<\/td>\n<\/tr>\n
\n
Database<\/span><\/span><\/span><\/div>\n<\/td>\n
\n
24<\/span><\/span><\/span><\/div>\n<\/td>\n
\n
+0.9%<\/span><\/span><\/span><\/div>\n<\/td>\n
\n
53%<\/span><\/span><\/span><\/div>\n<\/td>\n
\n
16%<\/span><\/span><\/span><\/div>\n<\/td>\n<\/tr>\n
\n
\u00a0<\/span><\/span><\/div>\n<\/td>\n<\/tr>\n
\n
Virtualization<\/span><\/span><\/span><\/div>\n<\/td>\n
\n
40<\/span><\/span><\/span><\/div>\n<\/td>\n
\n
+0.6%<\/span><\/span><\/span><\/div>\n<\/td>\n
\n
95%<\/span><\/span><\/span><\/div>\n<\/td>\n
\n
45%<\/span><\/span><\/span><\/div>\n<\/td>\n<\/tr>\n
\n
Instance<\/span><\/span><\/span><\/div>\n<\/td>\n
\n
40<\/span><\/span><\/span><\/div>\n<\/td>\n
\n
+1.1%<\/span><\/span><\/span><\/div>\n<\/td>\n
\n
73%<\/span><\/span><\/span><\/div>\n<\/td>\n
\n
37%<\/span><\/span><\/span><\/div>\n<\/td>\n<\/tr>\n
\n
Database<\/span><\/span><\/span><\/div>\n<\/td>\n
\n
40<\/span><\/span><\/span><\/div>\n<\/td>\n
\n
+1.3%<\/span><\/span><\/span><\/div>\n<\/td>\n
\n
55%<\/span><\/span><\/span><\/div>\n<\/td>\n
\n
34%<\/span><\/span><\/span><\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
\nFor more details on this experiment including how we put it together and learn more about how to effectively consolidation your database workload and choose between different consolidation options, please refer to our newly published whitepaper: <\/span>http:\/\/msdn.microsoft.com\/en-us\/library\/ee819082.aspx<\/span><\/a>\n<\/div>\n

\u00a0<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

SQL Server 2008 R2 introduces several new features which significantly expand upon existing support for working in, managing, and leveraging a multi-instance SQL Server environment.\u00a0 This blog post will focus on three of the new areas to improve your consolidation experience by using SQL Server 2008 R2.<\/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":[2448],"topic":[],"coauthors":[],"class_list":["post-5103","post","type-post","status-publish","format-standard","hentry","content-type-updates"],"yoast_head":"\nMake your servers work harder: Consolidate with SQL Server 2008 R2! - 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\/2010\/05\/10\/make-your-servers-work-harder-consolidate-with-sql-server-2008-r2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Make your servers work harder: Consolidate with SQL Server 2008 R2! - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"SQL Server 2008 R2 introduces several new features which significantly expand upon existing support for working in, managing, and leveraging a multi-instance SQL Server environment.\u00a0 This blog post will focus on three of the new areas to improve your consolidation experience by using SQL Server 2008 R2.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2010\/05\/10\/make-your-servers-work-harder-consolidate-with-sql-server-2008-r2\/\" \/>\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=\"2010-05-10T17:32:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-23T06:52:08+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\/2010\/05\/10\/make-your-servers-work-harder-consolidate-with-sql-server-2008-r2\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2010\/05\/10\/make-your-servers-work-harder-consolidate-with-sql-server-2008-r2\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/\",\"@type\":\"Person\",\"@name\":\"SQL Server Team\"}],\"headline\":\"Make your servers work harder: Consolidate with SQL Server 2008 R2!\",\"datePublished\":\"2010-05-10T17:32:00+00:00\",\"dateModified\":\"2024-01-23T06:52:08+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2010\/05\/10\/make-your-servers-work-harder-consolidate-with-sql-server-2008-r2\/\"},\"wordCount\":473,\"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\/2010\/05\/10\/make-your-servers-work-harder-consolidate-with-sql-server-2008-r2\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2010\/05\/10\/make-your-servers-work-harder-consolidate-with-sql-server-2008-r2\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2010\/05\/10\/make-your-servers-work-harder-consolidate-with-sql-server-2008-r2\/\",\"name\":\"Make your servers work harder: Consolidate with SQL Server 2008 R2! - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\"},\"datePublished\":\"2010-05-10T17:32:00+00:00\",\"dateModified\":\"2024-01-23T06:52:08+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2010\/05\/10\/make-your-servers-work-harder-consolidate-with-sql-server-2008-r2\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2010\/05\/10\/make-your-servers-work-harder-consolidate-with-sql-server-2008-r2\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2010\/05\/10\/make-your-servers-work-harder-consolidate-with-sql-server-2008-r2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Make your servers work harder: Consolidate with SQL Server 2008 R2!\"}]},{\"@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":"Make your servers work harder: Consolidate with SQL Server 2008 R2! - 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\/2010\/05\/10\/make-your-servers-work-harder-consolidate-with-sql-server-2008-r2\/","og_locale":"en_US","og_type":"article","og_title":"Make your servers work harder: Consolidate with SQL Server 2008 R2! - Microsoft SQL Server Blog","og_description":"SQL Server 2008 R2 introduces several new features which significantly expand upon existing support for working in, managing, and leveraging a multi-instance SQL Server environment.\u00a0 This blog post will focus on three of the new areas to improve your consolidation experience by using SQL Server 2008 R2.","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2010\/05\/10\/make-your-servers-work-harder-consolidate-with-sql-server-2008-r2\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2010-05-10T17:32:00+00:00","article_modified_time":"2024-01-23T06:52:08+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\/2010\/05\/10\/make-your-servers-work-harder-consolidate-with-sql-server-2008-r2\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2010\/05\/10\/make-your-servers-work-harder-consolidate-with-sql-server-2008-r2\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/","@type":"Person","@name":"SQL Server Team"}],"headline":"Make your servers work harder: Consolidate with SQL Server 2008 R2!","datePublished":"2010-05-10T17:32:00+00:00","dateModified":"2024-01-23T06:52:08+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2010\/05\/10\/make-your-servers-work-harder-consolidate-with-sql-server-2008-r2\/"},"wordCount":473,"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\/2010\/05\/10\/make-your-servers-work-harder-consolidate-with-sql-server-2008-r2\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2010\/05\/10\/make-your-servers-work-harder-consolidate-with-sql-server-2008-r2\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2010\/05\/10\/make-your-servers-work-harder-consolidate-with-sql-server-2008-r2\/","name":"Make your servers work harder: Consolidate with SQL Server 2008 R2! - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website"},"datePublished":"2010-05-10T17:32:00+00:00","dateModified":"2024-01-23T06:52:08+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2010\/05\/10\/make-your-servers-work-harder-consolidate-with-sql-server-2008-r2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2010\/05\/10\/make-your-servers-work-harder-consolidate-with-sql-server-2008-r2\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2010\/05\/10\/make-your-servers-work-harder-consolidate-with-sql-server-2008-r2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"Make your servers work harder: Consolidate with SQL Server 2008 R2!"}]},{"@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\/5103","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=5103"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/5103\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=5103"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=5103"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=5103"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=5103"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=5103"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=5103"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}