{"id":4497,"date":"2016-09-06T00:00:00","date_gmt":"2016-09-06T00:00:00","guid":{"rendered":"https:\/\/azure.microsoft.com\/blog\/improved-automated-tuning-sql-database-advisor"},"modified":"2025-06-23T09:23:47","modified_gmt":"2025-06-23T16:23:47","slug":"improved-automated-tuning-sql-database-advisor","status":"publish","type":"post","link":"https:\/\/azure.microsoft.com\/en-us\/blog\/improved-automated-tuning-sql-database-advisor\/","title":{"rendered":"Improved Automatic Tuning boosts your Azure SQL Database performance"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Azure SQL Database is the world\u2019s first intelligent database service that learns and adapts with your application, enabling you to dynamically maximize performance with very little effort on your part.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Today we released an exciting update to <a href=\"https:\/\/azure.microsoft.com\/en-us\/documentation\/articles\/sql-database-index-advisor\/\">Azure SQL Database Advisor<\/a> that <strong>greatly reduces the time (from a week to a day) required to produce and implement index tuning recommendations<\/strong>.&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This brings us one step closer to our vision where developers no longer have to worry about physical database schema management, as the system will self-optimize to provide predictable and optimal performance for every database application.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"about-sql-database-advisor\">About SQL Database Advisor<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Database Advisor provides custom performance tuning recommendations for your databases using machine learning intelligence.&nbsp;It saves you time, automatically tuning your database performance, so you can focus your energy on building great applications.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li class=\"wp-block-list-item\">Database Advisor continuously monitors your database usage and provides recommendations to improve performance (create\/drop indexes, and more)<\/li>\n\n\n\n<li class=\"wp-block-list-item\">You can choose to have the recommendations be automatically applied (via Automatic Tuning option)<\/li>\n\n\n\n<li class=\"wp-block-list-item\">Recommendations applied or rolled back manually (via Azure Portal or REST API)<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image has-custom-border\"><img decoding=\"async\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2016\/09\/a3995dad-b381-4909-9013-93f915d741ce.webp\" alt=\"Improved Automatic Tuning boosts your Azure SQL Database performance\" style=\"border-radius:0px\" title=\"Azure Portal - SQL Database Blade\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"what-s-new-in-this-release\">What\u2019s new in this release?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The following table summarizes the improvements in this release:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Area<\/th><th>Before<\/th><th>Now<\/th><\/tr><\/thead><tbody><tr><td>Time to produce new index recommendations<br>(for a database with daily usage)<\/td><td>~7 days<\/td><td><strong>~18 hours<\/strong><\/td><\/tr><tr><td>Delay before T-SQL statement is executed<br>(CREATE INDEX or DROP INDEX)<\/td><td>~12 hours delay<\/td><td><strong>Immediately<\/strong><br>(starts within minutes)<\/td><\/tr><tr><td>Time to react to any regressions and revert \u201cbad\u201d tuning actions<\/td><td>~12 hours<\/td><td><strong>&lt;=1 hour<\/strong><\/td><\/tr><tr><td>Delay between implementing consecutive index recommendations<\/td><td>~12 hours delay between indexes<\/td><td><strong>Immediately<\/strong><br>(starts within minutes)<\/td><\/tr><\/tbody><tfoot><tr><td>TOTAL TIME TO IMPLEMENT<br>(for a DB with 3 active recommendations)<\/td><td>~9 DAYS<\/td><td><strong>~1 DAY<\/strong><\/td><\/tr><\/tfoot><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"automated-index-tuning-is-now-even-more-powerful\">Automated Index Tuning is now even more powerful<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">All these improvements together make automated index tuning an even more attractive choice for managing the performance of your Azure SQL databases. With the new recommendation models and greatly improved underlying automation, Database Advisor will tirelessly work 24\/7 to make your database applications run blazing fast at all times.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">If you\u2019re not using automated tuning yet, we strongly encourage you to give it a try \u2013 you\u2019ll be pleasantly surprised with the results, as many of our other customers already were.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"summary\">Summary<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">You can now run your production DB workload in SQL DB for a day, and Database Advisor will help you improve your database performance by providing custom tuning recommendations. You can also opt-in to automated tuning mode where the tuning recommendations will be auto-applied to your database for a complete hands-off tuning experience.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Now you can dedicate your energy and attention on building great database applications, while the SQL DB service keeps your databases running and performing great for you.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"next-steps\">Next steps<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">If you\u2019re new to Azure SQL Database, <a href=\"https:\/\/azure.microsoft.com\/en-us\/free\/\">sign up now for a free trial<\/a> and discover how built-in intelligence of Azure SQL DB make it easier and faster than ever to build amazing database applications.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">If you\u2019re already using Azure SQL Database, <a href=\"https:\/\/portal.azure.com\/\">try SQL Database Advisor today<\/a> and share your feedback with us using the built-in feedback mechanism on the Azure Portal, or in the comments section of this post. We\u2019d love to hear back from you!<\/p>\n\n\n<figure class=\"wp-block-image size-full has-custom-border\"><img decoding=\"async\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2016\/09\/aee68940-8006-4e0f-b8e3-cac73e60d244.webp\" alt=\"graphical user interface, application\" class=\"wp-image-9936 webp-format\" style=\"border-radius:0px\" data-orig-src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2016\/09\/aee68940-8006-4e0f-b8e3-cac73e60d244.webp\"><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">For more detailed information, check out the <a href=\"https:\/\/azure.microsoft.com\/en-us\/documentation\/articles\/sql-database-index-advisor\/\">SQL Database Advisor online documentation<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>New update to SQL Database Advisor greatly reduces the time required (from a week to a day) to produce and implement index tuning recommendations, making the performance tuning process much faster.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ms_queue_id":[],"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","_alt_title":"","footnotes":"","msx_community_cta_settings":[]},"categories":[1473,1466],"tags":[],"audience":[3057,3055,3053,3056],"content-type":[],"product":[1539],"tech-community":[],"topic":[],"coauthors":[1211],"class_list":["post-4497","post","type-post","status-publish","format-standard","hentry","category-databases","category-hybrid-multicloud","audience-data-professionals","audience-developers","audience-it-decision-makers","audience-it-implementors","product-azure-sql-database","review-flag-1680286581-295","review-flag-1-1680286581-825","review-flag-24-7-1680286585-656","review-flag-3-1680286581-173","review-flag-7-1680286581-146","review-flag-9-1680286581-259","review-flag-free-1680286579-836","review-flag-machi-1680286585-314","review-flag-new-1680286579-546"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Improved Automatic Tuning boosts your Azure SQL Database performance | Microsoft Azure Blog<\/title>\n<meta name=\"description\" content=\"New update to SQL Database Advisor greatly reduces the time required (from a week to a day) to produce and implement index tuning recommendations, making the performance tuning process much faster.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/azure.microsoft.com\/en-us\/blog\/improved-automated-tuning-sql-database-advisor\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Improved Automatic Tuning boosts your Azure SQL Database performance | Microsoft Azure Blog\" \/>\n<meta property=\"og:description\" content=\"New update to SQL Database Advisor greatly reduces the time required (from a week to a day) to produce and implement index tuning recommendations, making the performance tuning process much faster.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/azure.microsoft.com\/en-us\/blog\/improved-automated-tuning-sql-database-advisor\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft Azure Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/microsoftazure\" \/>\n<meta property=\"article:published_time\" content=\"2016-09-06T00:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-23T16:23:47+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2016\/09\/a3995dad-b381-4909-9013-93f915d741ce.webp\" \/>\n<meta name=\"author\" content=\"Vladimir Ivanovic\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@azure\" \/>\n<meta name=\"twitter:site\" content=\"@azure\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Vladimir Ivanovic\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/improved-automated-tuning-sql-database-advisor\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/improved-automated-tuning-sql-database-advisor\/\"},\"author\":[{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/vladimir-ivanovic\/\",\"@type\":\"Person\",\"@name\":\"Vladimir Ivanovic\"}],\"headline\":\"Improved Automatic Tuning boosts your Azure SQL Database performance\",\"datePublished\":\"2016-09-06T00:00:00+00:00\",\"dateModified\":\"2025-06-23T16:23:47+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/improved-automated-tuning-sql-database-advisor\/\"},\"wordCount\":542,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/improved-automated-tuning-sql-database-advisor\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2016\/09\/a3995dad-b381-4909-9013-93f915d741ce.webp\",\"articleSection\":[\"Databases\",\"Hybrid + multicloud\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/azure.microsoft.com\/en-us\/blog\/improved-automated-tuning-sql-database-advisor\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/improved-automated-tuning-sql-database-advisor\/\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/improved-automated-tuning-sql-database-advisor\/\",\"name\":\"Improved Automatic Tuning boosts your Azure SQL Database performance | Microsoft Azure Blog\",\"isPartOf\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/improved-automated-tuning-sql-database-advisor\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/improved-automated-tuning-sql-database-advisor\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2016\/09\/a3995dad-b381-4909-9013-93f915d741ce.webp\",\"datePublished\":\"2016-09-06T00:00:00+00:00\",\"dateModified\":\"2025-06-23T16:23:47+00:00\",\"description\":\"New update to SQL Database Advisor greatly reduces the time required (from a week to a day) to produce and implement index tuning recommendations, making the performance tuning process much faster.\",\"breadcrumb\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/improved-automated-tuning-sql-database-advisor\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/azure.microsoft.com\/en-us\/blog\/improved-automated-tuning-sql-database-advisor\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/improved-automated-tuning-sql-database-advisor\/#primaryimage\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2016\/09\/a3995dad-b381-4909-9013-93f915d741ce.webp\",\"contentUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2016\/09\/a3995dad-b381-4909-9013-93f915d741ce.webp\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/improved-automated-tuning-sql-database-advisor\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Blog home\",\"item\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Databases\",\"item\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/category\/databases\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Improved Automatic Tuning boosts your Azure SQL Database performance\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#website\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/\",\"name\":\"Microsoft Azure Blog\",\"description\":\"Get the latest Azure news, updates, and announcements from the Azure blog. From product updates to hot topics, hear from the Azure experts.\",\"publisher\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization\",\"name\":\"Microsoft Azure Blog\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2024\/06\/microsoft_logo.webp\",\"contentUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2024\/06\/microsoft_logo.webp\",\"width\":512,\"height\":512,\"caption\":\"Microsoft Azure Blog\"},\"image\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/microsoftazure\",\"https:\/\/x.com\/azure\",\"https:\/\/www.instagram.com\/microsoftdeveloper\/\",\"https:\/\/www.linkedin.com\/company\/16188386\",\"https:\/\/www.youtube.com\/user\/windowsazure\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/person\/c702e5edd662b328b49b7e1180cab117\",\"name\":\"shakir\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g7664e653ea371ce16eaf75e9fa8952c4\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g\",\"caption\":\"shakir\"},\"sameAs\":[\"https:\/\/azure.microsoft.com\"],\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/shakir\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Improved Automatic Tuning boosts your Azure SQL Database performance | Microsoft Azure Blog","description":"New update to SQL Database Advisor greatly reduces the time required (from a week to a day) to produce and implement index tuning recommendations, making the performance tuning process much faster.","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:\/\/azure.microsoft.com\/en-us\/blog\/improved-automated-tuning-sql-database-advisor\/","og_locale":"en_US","og_type":"article","og_title":"Improved Automatic Tuning boosts your Azure SQL Database performance | Microsoft Azure Blog","og_description":"New update to SQL Database Advisor greatly reduces the time required (from a week to a day) to produce and implement index tuning recommendations, making the performance tuning process much faster.","og_url":"https:\/\/azure.microsoft.com\/en-us\/blog\/improved-automated-tuning-sql-database-advisor\/","og_site_name":"Microsoft Azure Blog","article_publisher":"https:\/\/www.facebook.com\/microsoftazure","article_published_time":"2016-09-06T00:00:00+00:00","article_modified_time":"2025-06-23T16:23:47+00:00","og_image":[{"url":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2016\/09\/a3995dad-b381-4909-9013-93f915d741ce.webp","type":"","width":"","height":""}],"author":"Vladimir Ivanovic","twitter_card":"summary_large_image","twitter_creator":"@azure","twitter_site":"@azure","twitter_misc":{"Written by":"Vladimir Ivanovic","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/improved-automated-tuning-sql-database-advisor\/#article","isPartOf":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/improved-automated-tuning-sql-database-advisor\/"},"author":[{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/vladimir-ivanovic\/","@type":"Person","@name":"Vladimir Ivanovic"}],"headline":"Improved Automatic Tuning boosts your Azure SQL Database performance","datePublished":"2016-09-06T00:00:00+00:00","dateModified":"2025-06-23T16:23:47+00:00","mainEntityOfPage":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/improved-automated-tuning-sql-database-advisor\/"},"wordCount":542,"commentCount":0,"publisher":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization"},"image":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/improved-automated-tuning-sql-database-advisor\/#primaryimage"},"thumbnailUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2016\/09\/a3995dad-b381-4909-9013-93f915d741ce.webp","articleSection":["Databases","Hybrid + multicloud"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/azure.microsoft.com\/en-us\/blog\/improved-automated-tuning-sql-database-advisor\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/improved-automated-tuning-sql-database-advisor\/","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/improved-automated-tuning-sql-database-advisor\/","name":"Improved Automatic Tuning boosts your Azure SQL Database performance | Microsoft Azure Blog","isPartOf":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/improved-automated-tuning-sql-database-advisor\/#primaryimage"},"image":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/improved-automated-tuning-sql-database-advisor\/#primaryimage"},"thumbnailUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2016\/09\/a3995dad-b381-4909-9013-93f915d741ce.webp","datePublished":"2016-09-06T00:00:00+00:00","dateModified":"2025-06-23T16:23:47+00:00","description":"New update to SQL Database Advisor greatly reduces the time required (from a week to a day) to produce and implement index tuning recommendations, making the performance tuning process much faster.","breadcrumb":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/improved-automated-tuning-sql-database-advisor\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/azure.microsoft.com\/en-us\/blog\/improved-automated-tuning-sql-database-advisor\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/improved-automated-tuning-sql-database-advisor\/#primaryimage","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2016\/09\/a3995dad-b381-4909-9013-93f915d741ce.webp","contentUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2016\/09\/a3995dad-b381-4909-9013-93f915d741ce.webp"},{"@type":"BreadcrumbList","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/improved-automated-tuning-sql-database-advisor\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog home","item":"https:\/\/azure.microsoft.com\/en-us\/blog\/"},{"@type":"ListItem","position":2,"name":"Databases","item":"https:\/\/azure.microsoft.com\/en-us\/blog\/category\/databases\/"},{"@type":"ListItem","position":3,"name":"Improved Automatic Tuning boosts your Azure SQL Database performance"}]},{"@type":"WebSite","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#website","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/","name":"Microsoft Azure Blog","description":"Get the latest Azure news, updates, and announcements from the Azure blog. From product updates to hot topics, hear from the Azure experts.","publisher":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/azure.microsoft.com\/en-us\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization","name":"Microsoft Azure Blog","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2024\/06\/microsoft_logo.webp","contentUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2024\/06\/microsoft_logo.webp","width":512,"height":512,"caption":"Microsoft Azure Blog"},"image":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/microsoftazure","https:\/\/x.com\/azure","https:\/\/www.instagram.com\/microsoftdeveloper\/","https:\/\/www.linkedin.com\/company\/16188386","https:\/\/www.youtube.com\/user\/windowsazure"]},{"@type":"Person","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/person\/c702e5edd662b328b49b7e1180cab117","name":"shakir","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g7664e653ea371ce16eaf75e9fa8952c4","url":"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g","caption":"shakir"},"sameAs":["https:\/\/azure.microsoft.com"],"url":"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/shakir\/"}]}},"msxcm_display_generated_audio":false,"msxcm_animated_featured_image":null,"distributor_meta":false,"distributor_terms":false,"distributor_media":false,"distributor_original_site_name":"Microsoft Azure Blog","distributor_original_site_url":"https:\/\/azure.microsoft.com\/en-us\/blog","push-errors":false,"_links":{"self":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts\/4497","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/comments?post=4497"}],"version-history":[{"count":1,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts\/4497\/revisions"}],"predecessor-version":[{"id":42875,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts\/4497\/revisions\/42875"}],"wp:attachment":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/media?parent=4497"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/categories?post=4497"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/tags?post=4497"},{"taxonomy":"audience","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/audience?post=4497"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/content-type?post=4497"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/product?post=4497"},{"taxonomy":"tech-community","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/tech-community?post=4497"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/topic?post=4497"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/coauthors?post=4497"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}