{"id":2763,"date":"2013-02-05T09:00:00","date_gmt":"2013-02-05T17:00:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2013\/02\/05\/windows-azure-sql-database-and-sql-server-performance-and-scalability-compared-and-contrasted\/"},"modified":"2024-01-22T22:49:24","modified_gmt":"2024-01-23T06:49:24","slug":"windows-azure-sql-database-and-sql-server-performance-and-scalability-compared-and-contrasted","status":"publish","type":"post","link":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/sql-server\/blog\/2013\/02\/05\/windows-azure-sql-database-and-sql-server-performance-and-scalability-compared-and-contrasted\/","title":{"rendered":"Windows Azure SQL Database and SQL Server &#8212; Performance and Scalability Compared and Contrasted"},"content":{"rendered":"<p><span style=\"font-size:small;\">Curious about the differences in approaching performance and scalability in SQL Server vs. Windows Azure SQL Database (formerly SQL Azure)? Check out this new paper that brings together insights from the Microsoft SQL Engineering and Customer Advisory Teams (CAT) to detail the differences between on-premises SQL Server and Azure SQL Database tuning and monitoring techniques and best practices for database performance testing. If you\u2019re an on-premises SQL Server whiz and currently integrating the cloud or considering a move to Platform as a Service, this paper is a must read!<\/span><\/p>\n<p><strong><span style=\"font-size:small;\">Paper Overview<\/span><\/strong><\/p>\n<p><span style=\"font-size:small;\">While SQL Server and Windows Azure SQL Databases have large and important similarities, they are not identical, and while the differences are relatively small, they affect the way that applications perform on SQL Database compared to SQL Server. As a result, the application architecture and performance evaluation techniques for each platform also differ.<\/span><\/p>\n<p><span style=\"font-size:small;\">This document explains these performance differences and their causes and includes real-world customer wisdom from experience troubleshooting performance on production customer SQL Databases. This document also examines common SQL Server performance evaluation techniques that do not work on SQL Database. <\/span><\/p>\n<p><b><span style=\"font-size:small;\">Read the full <\/span><a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/windowsazure\/jj879332.aspx\"><span style=\"font-size:small;\">paper<\/span><\/a><span style=\"font-size:small;\">.<\/span><\/b><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Curious about the differences in approaching performance and scalability in SQL Server vs.<\/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":[2451],"coauthors":[2487],"class_list":["post-2763","post","type-post","status-publish","format-standard","hentry","content-type-thought-leadership","topic-big-data"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Windows Azure SQL Database and SQL Server - Performance and Scalability Compared and Contrasted - 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:\/\/new-cm-edgedigital.pages.dev\/en-us\/sql-server\/blog\/2013\/02\/05\/windows-azure-sql-database-and-sql-server-performance-and-scalability-compared-and-contrasted\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Windows Azure SQL Database and SQL Server - Performance and Scalability Compared and Contrasted - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"Curious about the differences in approaching performance and scalability in SQL Server vs.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/sql-server\/blog\/2013\/02\/05\/windows-azure-sql-database-and-sql-server-performance-and-scalability-compared-and-contrasted\/\" \/>\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=\"2013-02-05T17:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-23T06:49:24+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/new-cm-edgedigital.pages.dev\/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=\"1 min read\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/new-cm-edgedigital.pages.dev\\\/en-us\\\/sql-server\\\/blog\\\/2013\\\/02\\\/05\\\/windows-azure-sql-database-and-sql-server-performance-and-scalability-compared-and-contrasted\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/new-cm-edgedigital.pages.dev\\\/en-us\\\/sql-server\\\/blog\\\/2013\\\/02\\\/05\\\/windows-azure-sql-database-and-sql-server-performance-and-scalability-compared-and-contrasted\\\/\"},\"author\":[{\"@id\":\"https:\\\/\\\/new-cm-edgedigital.pages.dev\\\/en-us\\\/sql-server\\\/blog\\\/author\\\/sql-server-team\\\/\",\"@type\":\"Person\",\"@name\":\"SQL Server Team\"}],\"headline\":\"Windows Azure SQL Database and SQL Server &#8212; Performance and Scalability Compared and Contrasted\",\"datePublished\":\"2013-02-05T17:00:00+00:00\",\"dateModified\":\"2024-01-23T06:49:24+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/new-cm-edgedigital.pages.dev\\\/en-us\\\/sql-server\\\/blog\\\/2013\\\/02\\\/05\\\/windows-azure-sql-database-and-sql-server-performance-and-scalability-compared-and-contrasted\\\/\"},\"wordCount\":203,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/new-cm-edgedigital.pages.dev\\\/en-us\\\/sql-server\\\/blog\\\/#organization\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/new-cm-edgedigital.pages.dev\\\/en-us\\\/sql-server\\\/blog\\\/2013\\\/02\\\/05\\\/windows-azure-sql-database-and-sql-server-performance-and-scalability-compared-and-contrasted\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/new-cm-edgedigital.pages.dev\\\/en-us\\\/sql-server\\\/blog\\\/2013\\\/02\\\/05\\\/windows-azure-sql-database-and-sql-server-performance-and-scalability-compared-and-contrasted\\\/\",\"url\":\"https:\\\/\\\/new-cm-edgedigital.pages.dev\\\/en-us\\\/sql-server\\\/blog\\\/2013\\\/02\\\/05\\\/windows-azure-sql-database-and-sql-server-performance-and-scalability-compared-and-contrasted\\\/\",\"name\":\"Windows Azure SQL Database and SQL Server - Performance and Scalability Compared and Contrasted - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/new-cm-edgedigital.pages.dev\\\/en-us\\\/sql-server\\\/blog\\\/#website\"},\"datePublished\":\"2013-02-05T17:00:00+00:00\",\"dateModified\":\"2024-01-23T06:49:24+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/new-cm-edgedigital.pages.dev\\\/en-us\\\/sql-server\\\/blog\\\/2013\\\/02\\\/05\\\/windows-azure-sql-database-and-sql-server-performance-and-scalability-compared-and-contrasted\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/new-cm-edgedigital.pages.dev\\\/en-us\\\/sql-server\\\/blog\\\/2013\\\/02\\\/05\\\/windows-azure-sql-database-and-sql-server-performance-and-scalability-compared-and-contrasted\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/new-cm-edgedigital.pages.dev\\\/en-us\\\/sql-server\\\/blog\\\/2013\\\/02\\\/05\\\/windows-azure-sql-database-and-sql-server-performance-and-scalability-compared-and-contrasted\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/new-cm-edgedigital.pages.dev\\\/en-us\\\/sql-server\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Windows Azure SQL Database and SQL Server &#8212; Performance and Scalability Compared and Contrasted\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/new-cm-edgedigital.pages.dev\\\/en-us\\\/sql-server\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/new-cm-edgedigital.pages.dev\\\/en-us\\\/sql-server\\\/blog\\\/\",\"name\":\"Microsoft SQL Server Blog\",\"description\":\"Official News from Microsoft\u2019s Information Platform\",\"publisher\":{\"@id\":\"https:\\\/\\\/new-cm-edgedigital.pages.dev\\\/en-us\\\/sql-server\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/new-cm-edgedigital.pages.dev\\\/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:\\\/\\\/new-cm-edgedigital.pages.dev\\\/en-us\\\/sql-server\\\/blog\\\/#organization\",\"name\":\"Microsoft SQL Server Blog\",\"url\":\"https:\\\/\\\/new-cm-edgedigital.pages.dev\\\/en-us\\\/sql-server\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/new-cm-edgedigital.pages.dev\\\/en-us\\\/sql-server\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/new-cm-edgedigital.pages.dev\\\/en-us\\\/sql-server\\\/blog\\\/wp-content\\\/uploads\\\/2019\\\/08\\\/Microsoft-Logo.png\",\"contentUrl\":\"https:\\\/\\\/new-cm-edgedigital.pages.dev\\\/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:\\\/\\\/new-cm-edgedigital.pages.dev\\\/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":"Windows Azure SQL Database and SQL Server - Performance and Scalability Compared and Contrasted - 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:\/\/new-cm-edgedigital.pages.dev\/en-us\/sql-server\/blog\/2013\/02\/05\/windows-azure-sql-database-and-sql-server-performance-and-scalability-compared-and-contrasted\/","og_locale":"en_US","og_type":"article","og_title":"Windows Azure SQL Database and SQL Server - Performance and Scalability Compared and Contrasted - Microsoft SQL Server Blog","og_description":"Curious about the differences in approaching performance and scalability in SQL Server vs.","og_url":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/sql-server\/blog\/2013\/02\/05\/windows-azure-sql-database-and-sql-server-performance-and-scalability-compared-and-contrasted\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2013-02-05T17:00:00+00:00","article_modified_time":"2024-01-23T06:49:24+00:00","og_image":[{"width":512,"height":512,"url":"https:\/\/new-cm-edgedigital.pages.dev\/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":"1 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/sql-server\/blog\/2013\/02\/05\/windows-azure-sql-database-and-sql-server-performance-and-scalability-compared-and-contrasted\/#article","isPartOf":{"@id":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/sql-server\/blog\/2013\/02\/05\/windows-azure-sql-database-and-sql-server-performance-and-scalability-compared-and-contrasted\/"},"author":[{"@id":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/sql-server\/blog\/author\/sql-server-team\/","@type":"Person","@name":"SQL Server Team"}],"headline":"Windows Azure SQL Database and SQL Server &#8212; Performance and Scalability Compared and Contrasted","datePublished":"2013-02-05T17:00:00+00:00","dateModified":"2024-01-23T06:49:24+00:00","mainEntityOfPage":{"@id":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/sql-server\/blog\/2013\/02\/05\/windows-azure-sql-database-and-sql-server-performance-and-scalability-compared-and-contrasted\/"},"wordCount":203,"commentCount":0,"publisher":{"@id":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/sql-server\/blog\/#organization"},"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/new-cm-edgedigital.pages.dev\/en-us\/sql-server\/blog\/2013\/02\/05\/windows-azure-sql-database-and-sql-server-performance-and-scalability-compared-and-contrasted\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/sql-server\/blog\/2013\/02\/05\/windows-azure-sql-database-and-sql-server-performance-and-scalability-compared-and-contrasted\/","url":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/sql-server\/blog\/2013\/02\/05\/windows-azure-sql-database-and-sql-server-performance-and-scalability-compared-and-contrasted\/","name":"Windows Azure SQL Database and SQL Server - Performance and Scalability Compared and Contrasted - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/sql-server\/blog\/#website"},"datePublished":"2013-02-05T17:00:00+00:00","dateModified":"2024-01-23T06:49:24+00:00","breadcrumb":{"@id":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/sql-server\/blog\/2013\/02\/05\/windows-azure-sql-database-and-sql-server-performance-and-scalability-compared-and-contrasted\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/new-cm-edgedigital.pages.dev\/en-us\/sql-server\/blog\/2013\/02\/05\/windows-azure-sql-database-and-sql-server-performance-and-scalability-compared-and-contrasted\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/sql-server\/blog\/2013\/02\/05\/windows-azure-sql-database-and-sql-server-performance-and-scalability-compared-and-contrasted\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"Windows Azure SQL Database and SQL Server &#8212; Performance and Scalability Compared and Contrasted"}]},{"@type":"WebSite","@id":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/sql-server\/blog\/#website","url":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/sql-server\/blog\/","name":"Microsoft SQL Server Blog","description":"Official News from Microsoft\u2019s Information Platform","publisher":{"@id":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/sql-server\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/new-cm-edgedigital.pages.dev\/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:\/\/new-cm-edgedigital.pages.dev\/en-us\/sql-server\/blog\/#organization","name":"Microsoft SQL Server Blog","url":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/sql-server\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","contentUrl":"https:\/\/new-cm-edgedigital.pages.dev\/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:\/\/new-cm-edgedigital.pages.dev\/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_animated_featured_image":null,"bloginabox_display_generated_audio":false,"_links":{"self":[{"href":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/2763","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/users\/1457"}],"replies":[{"embeddable":true,"href":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/comments?post=2763"}],"version-history":[{"count":0,"href":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/2763\/revisions"}],"wp:attachment":[{"href":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=2763"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=2763"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=2763"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=2763"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=2763"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=2763"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}