{"id":2025,"date":"2018-11-07T00:00:00","date_gmt":"2018-11-07T00:00:00","guid":{"rendered":"https:\/\/azure.microsoft.com\/blog\/automatically-discover-workload-insights-for-advanced-performance-tuning-directly-in-the-azure-portal"},"modified":"2023-05-12T12:16:35","modified_gmt":"2023-05-12T19:16:35","slug":"automatically-discover-workload-insights-for-advanced-performance-tuning-directly-in-the-azure-portal","status":"publish","type":"post","link":"https:\/\/azure.microsoft.com\/en-us\/blog\/automatically-discover-workload-insights-for-advanced-performance-tuning-directly-in-the-azure-portal\/","title":{"rendered":"Automatically discover workload insights for advanced performance tuning directly in Azure portal"},"content":{"rendered":"<p>Advanced tuning for Azure SQL Data Warehouse (SQL DW) just got simpler with additional data warehouse recommendations and metrics. SQL DW is a flexible, secure, and fully managed analytics platform for enterprises optimized for running complex queries quickly across petabytes of data.<\/p>\n<p>Often times advanced tuning scenarios with SQL DW can be a challenge without the proper tools to seamlessly uncover performance insights into your data warehouse workload. This can lead to hours of troubleshooting efforts where you must ensure proper monitoring practices are continuously followed. SQL DW provides a built-in holistic management experience by having a tight integration within the Microsoft Azure ecosystem, specifically Azure Advisor and Azure Monitor. These two services are immediately configured by default for SQL Data Warehouse to automatically deliver you workload insights at no additional cost.<\/p>\n<p>There are additional advanced performance recommendations through Azure Advisor at your disposal, including:<\/p>\n<ul>\n<li>Adaptive cache \u2013 Be advised when to scale to optimize cache utilization.<\/li>\n<li>Table distribution \u2013 Determine when to replicate tables to reduce data movement and increase workload performance.<\/li>\n<li>Tempdb \u2013 Understand when to scale and configure resource classes to reduce tempdb contention.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"New SQL DW Recommendations\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2018\/11\/af4d2d5f-2166-4f38-9175-06761daf45e3.webp\" alt=\"New SQL DW Recommendations\" width=\"1415\" height=\"700\" \/><\/p>\n<p>There is a deeper integration of data warehouse metrics with <a href=\"https:\/\/azure.microsoft.com\/blog\/enhanced-capabilities-to-monitor-manage-and-integrate-sql-data-warehouse-in-the-azure-portal\/\" target=\"_blank\" rel=\"noopener\">Azure Monitor<\/a> including an enhanced customizable monitoring chart for near real-time metrics in the overview blade. You no longer must leave the data warehouse overview blade to access Azure Monitor metrics when monitoring usage, or validating and applying data warehouse recommendations.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Azure Monitor Integration\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2018\/11\/7aa27c7f-0685-4332-89bc-dd39f7b28518.webp\" alt=\"Azure Monitor Integration\" width=\"1298\" height=\"419\" \/><\/p>\n<p>There are new metrics available, such as tempdb and adaptive cache utilization to complement your performance recommendations.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Metrics\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2018\/11\/b1961886-2797-41aa-8e2b-bd215fb7bc3f.webp\" alt=\"Metrics\" width=\"1227\" height=\"638\" \/><\/p>\n<h2>Next steps<\/h2>\n<ul>\n<li>Check if you have <a href=\"https:\/\/aka.ms\/Azureadvisor\">Advisor recommendations<\/a>!<\/li>\n<li>Visit our <a href=\"https:\/\/docs.microsoft.com\/azure\/advisor\/advisor-performance-recommendations\">online documentation<\/a> for more details on recommendations with SQL DW.<\/li>\n<li>For feature requests, please vote on our <a href=\"https:\/\/feedback.azure.com\/forums\/307516-sql-data-warehouse\">UserVoice<\/a>.<\/li>\n<li><a href=\"https:\/\/docs.microsoft.com\/azure\/sql-data-warehouse\/create-data-warehouse-portal\">Create an Azure SQL Data Warehouse<\/a> to get started today.<\/li>\n<li>Stay up-to-date on the latest Azure SQL Data Warehouse news and features by following us on Twitter <a href=\"https:\/\/twitter.com\/AzureSQLDW\">@AzureSQLDW<\/a>.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Advanced tuning for Azure SQL Data Warehouse (SQL DW) just got simpler with additional data warehouse recommendations and metrics. SQL DW is a flexible, secure, and fully managed analytics platform for the enterprise optimized for running complex queries quickly across petabytes of data.<\/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":[1482],"tags":[],"audience":[3054,3053],"content-type":[],"product":[1535],"tech-community":[],"topic":[],"coauthors":[731],"class_list":["post-2025","post","type-post","status-publish","format-standard","hentry","category-management-and-governance","audience-business-decision-makers","audience-it-decision-makers","product-microsoft-azure-portal","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>Automatically discover workload insights for advanced performance tuning directly in Azure portal | Microsoft Azure Blog<\/title>\n<meta name=\"description\" content=\"Advanced tuning for Azure SQL Data Warehouse (SQL DW) just got simpler with additional data warehouse recommendations and metrics. SQL DW is a flexible, secure, and fully managed analytics platform for the enterprise optimized for running complex queries quickly across petabytes of data.\" \/>\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\/automatically-discover-workload-insights-for-advanced-performance-tuning-directly-in-the-azure-portal\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Automatically discover workload insights for advanced performance tuning directly in Azure portal | Microsoft Azure Blog\" \/>\n<meta property=\"og:description\" content=\"Advanced tuning for Azure SQL Data Warehouse (SQL DW) just got simpler with additional data warehouse recommendations and metrics. SQL DW is a flexible, secure, and fully managed analytics platform for the enterprise optimized for running complex queries quickly across petabytes of data.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/azure.microsoft.com\/en-us\/blog\/automatically-discover-workload-insights-for-advanced-performance-tuning-directly-in-the-azure-portal\/\" \/>\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=\"2018-11-07T00:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-05-12T19:16:35+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2018\/11\/af4d2d5f-2166-4f38-9175-06761daf45e3.webp\" \/>\n<meta name=\"author\" content=\"Kevin Ngo\" \/>\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=\"Kevin Ngo\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 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\/automatically-discover-workload-insights-for-advanced-performance-tuning-directly-in-the-azure-portal\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/automatically-discover-workload-insights-for-advanced-performance-tuning-directly-in-the-azure-portal\/\"},\"author\":[{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/kevin-ngo\/\",\"@type\":\"Person\",\"@name\":\"Kevin Ngo\"}],\"headline\":\"Automatically discover workload insights for advanced performance tuning directly in Azure portal\",\"datePublished\":\"2018-11-07T00:00:00+00:00\",\"dateModified\":\"2023-05-12T19:16:35+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/automatically-discover-workload-insights-for-advanced-performance-tuning-directly-in-the-azure-portal\/\"},\"wordCount\":320,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/automatically-discover-workload-insights-for-advanced-performance-tuning-directly-in-the-azure-portal\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2018\/11\/af4d2d5f-2166-4f38-9175-06761daf45e3.webp\",\"articleSection\":[\"Management and governance\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/azure.microsoft.com\/en-us\/blog\/automatically-discover-workload-insights-for-advanced-performance-tuning-directly-in-the-azure-portal\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/automatically-discover-workload-insights-for-advanced-performance-tuning-directly-in-the-azure-portal\/\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/automatically-discover-workload-insights-for-advanced-performance-tuning-directly-in-the-azure-portal\/\",\"name\":\"Automatically discover workload insights for advanced performance tuning directly in Azure portal | Microsoft Azure Blog\",\"isPartOf\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/automatically-discover-workload-insights-for-advanced-performance-tuning-directly-in-the-azure-portal\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/automatically-discover-workload-insights-for-advanced-performance-tuning-directly-in-the-azure-portal\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2018\/11\/af4d2d5f-2166-4f38-9175-06761daf45e3.webp\",\"datePublished\":\"2018-11-07T00:00:00+00:00\",\"dateModified\":\"2023-05-12T19:16:35+00:00\",\"description\":\"Advanced tuning for Azure SQL Data Warehouse (SQL DW) just got simpler with additional data warehouse recommendations and metrics. SQL DW is a flexible, secure, and fully managed analytics platform for the enterprise optimized for running complex queries quickly across petabytes of data.\",\"breadcrumb\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/automatically-discover-workload-insights-for-advanced-performance-tuning-directly-in-the-azure-portal\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/azure.microsoft.com\/en-us\/blog\/automatically-discover-workload-insights-for-advanced-performance-tuning-directly-in-the-azure-portal\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/automatically-discover-workload-insights-for-advanced-performance-tuning-directly-in-the-azure-portal\/#primaryimage\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2018\/11\/af4d2d5f-2166-4f38-9175-06761daf45e3.webp\",\"contentUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2018\/11\/af4d2d5f-2166-4f38-9175-06761daf45e3.webp\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/automatically-discover-workload-insights-for-advanced-performance-tuning-directly-in-the-azure-portal\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Blog home\",\"item\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Management and governance\",\"item\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/category\/management-and-governance\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Automatically discover workload insights for advanced performance tuning directly in Azure portal\"}]},{\"@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":"Automatically discover workload insights for advanced performance tuning directly in Azure portal | Microsoft Azure Blog","description":"Advanced tuning for Azure SQL Data Warehouse (SQL DW) just got simpler with additional data warehouse recommendations and metrics. SQL DW is a flexible, secure, and fully managed analytics platform for the enterprise optimized for running complex queries quickly across petabytes of data.","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\/automatically-discover-workload-insights-for-advanced-performance-tuning-directly-in-the-azure-portal\/","og_locale":"en_US","og_type":"article","og_title":"Automatically discover workload insights for advanced performance tuning directly in Azure portal | Microsoft Azure Blog","og_description":"Advanced tuning for Azure SQL Data Warehouse (SQL DW) just got simpler with additional data warehouse recommendations and metrics. SQL DW is a flexible, secure, and fully managed analytics platform for the enterprise optimized for running complex queries quickly across petabytes of data.","og_url":"https:\/\/azure.microsoft.com\/en-us\/blog\/automatically-discover-workload-insights-for-advanced-performance-tuning-directly-in-the-azure-portal\/","og_site_name":"Microsoft Azure Blog","article_publisher":"https:\/\/www.facebook.com\/microsoftazure","article_published_time":"2018-11-07T00:00:00+00:00","article_modified_time":"2023-05-12T19:16:35+00:00","og_image":[{"url":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2018\/11\/af4d2d5f-2166-4f38-9175-06761daf45e3.webp","type":"","width":"","height":""}],"author":"Kevin Ngo","twitter_card":"summary_large_image","twitter_creator":"@azure","twitter_site":"@azure","twitter_misc":{"Written by":"Kevin Ngo","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/automatically-discover-workload-insights-for-advanced-performance-tuning-directly-in-the-azure-portal\/#article","isPartOf":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/automatically-discover-workload-insights-for-advanced-performance-tuning-directly-in-the-azure-portal\/"},"author":[{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/kevin-ngo\/","@type":"Person","@name":"Kevin Ngo"}],"headline":"Automatically discover workload insights for advanced performance tuning directly in Azure portal","datePublished":"2018-11-07T00:00:00+00:00","dateModified":"2023-05-12T19:16:35+00:00","mainEntityOfPage":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/automatically-discover-workload-insights-for-advanced-performance-tuning-directly-in-the-azure-portal\/"},"wordCount":320,"commentCount":0,"publisher":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization"},"image":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/automatically-discover-workload-insights-for-advanced-performance-tuning-directly-in-the-azure-portal\/#primaryimage"},"thumbnailUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2018\/11\/af4d2d5f-2166-4f38-9175-06761daf45e3.webp","articleSection":["Management and governance"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/azure.microsoft.com\/en-us\/blog\/automatically-discover-workload-insights-for-advanced-performance-tuning-directly-in-the-azure-portal\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/automatically-discover-workload-insights-for-advanced-performance-tuning-directly-in-the-azure-portal\/","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/automatically-discover-workload-insights-for-advanced-performance-tuning-directly-in-the-azure-portal\/","name":"Automatically discover workload insights for advanced performance tuning directly in Azure portal | Microsoft Azure Blog","isPartOf":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/automatically-discover-workload-insights-for-advanced-performance-tuning-directly-in-the-azure-portal\/#primaryimage"},"image":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/automatically-discover-workload-insights-for-advanced-performance-tuning-directly-in-the-azure-portal\/#primaryimage"},"thumbnailUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2018\/11\/af4d2d5f-2166-4f38-9175-06761daf45e3.webp","datePublished":"2018-11-07T00:00:00+00:00","dateModified":"2023-05-12T19:16:35+00:00","description":"Advanced tuning for Azure SQL Data Warehouse (SQL DW) just got simpler with additional data warehouse recommendations and metrics. SQL DW is a flexible, secure, and fully managed analytics platform for the enterprise optimized for running complex queries quickly across petabytes of data.","breadcrumb":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/automatically-discover-workload-insights-for-advanced-performance-tuning-directly-in-the-azure-portal\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/azure.microsoft.com\/en-us\/blog\/automatically-discover-workload-insights-for-advanced-performance-tuning-directly-in-the-azure-portal\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/automatically-discover-workload-insights-for-advanced-performance-tuning-directly-in-the-azure-portal\/#primaryimage","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2018\/11\/af4d2d5f-2166-4f38-9175-06761daf45e3.webp","contentUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2018\/11\/af4d2d5f-2166-4f38-9175-06761daf45e3.webp"},{"@type":"BreadcrumbList","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/automatically-discover-workload-insights-for-advanced-performance-tuning-directly-in-the-azure-portal\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog home","item":"https:\/\/azure.microsoft.com\/en-us\/blog\/"},{"@type":"ListItem","position":2,"name":"Management and governance","item":"https:\/\/azure.microsoft.com\/en-us\/blog\/category\/management-and-governance\/"},{"@type":"ListItem","position":3,"name":"Automatically discover workload insights for advanced performance tuning directly in Azure portal"}]},{"@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\/2025","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=2025"}],"version-history":[{"count":0,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts\/2025\/revisions"}],"wp:attachment":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/media?parent=2025"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/categories?post=2025"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/tags?post=2025"},{"taxonomy":"audience","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/audience?post=2025"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/content-type?post=2025"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/product?post=2025"},{"taxonomy":"tech-community","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/tech-community?post=2025"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/topic?post=2025"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/coauthors?post=2025"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}