{"id":14059,"date":"2020-07-29T10:48:34","date_gmt":"2020-07-29T10:48:34","guid":{"rendered":"https:\/\/www.testpreptraining.com\/tutorial\/?page_id=14059"},"modified":"2020-08-07T03:53:58","modified_gmt":"2020-08-07T03:53:58","slug":"how-to-monitor-workload","status":"publish","type":"page","link":"https:\/\/www.testpreptraining.ai\/tutorial\/how-to-monitor-workload\/","title":{"rendered":"Monitor Workload in Azure Portal"},"content":{"rendered":"\n<p>This tutorial will guide you on how to use the Azure portal to monitor your workload. This includes setting up Azure Monitor Logs to investigate query execution and workload trends using log analytics for&nbsp;Synapse SQL and creating workspace. You will need an Azure subscription: If you don&#8217;t have an Azure subscription, create a&nbsp;free account&nbsp;before you begin. And, SQL pool: We will be collecting logs for a SQL pool. <\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"create-a-log-analytics-workspace\"><strong>Create a Log Analytics workspace<\/strong><\/h3>\n\n\n\n<p>You can Navigate to the browse blade for Log Analytics workspaces and create a workspace.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"230\" height=\"311\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/07\/add_analytics_workspace_2.png\" alt=\"How to monitor workload?\" class=\"wp-image-14062\"\/><figcaption>Image Source &#8211; Microsoft<\/figcaption><\/figure><\/div>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"turn-on-resource-logs\"><strong>Monitor workload by Turn on Resource logs<\/strong><\/h3>\n\n\n\n<p>Also, Configure diagnostic settings to emit logs from your SQL pool. Logs consist of telemetry views equivalent to the most commonly used performance troubleshooting DMVs. Currently the following views are supported:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>sys.dm_pdw_exec_requests<\/li><li>sys.dm_pdw_request_steps<\/li><li>sys.dm_pdw_dms_workers<\/li><li>sys.dm_pdw_waits<\/li><li>sys.dm_pdw_sql_requests<\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"439\" height=\"471\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/07\/enable_diagnostic_logs.png\" alt=\"How to monitor workload?\" class=\"wp-image-14063\" srcset=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/07\/enable_diagnostic_logs.png 439w, https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/07\/enable_diagnostic_logs-373x400.png 373w\" sizes=\"auto, (max-width: 439px) 100vw, 439px\" \/><figcaption>Image Source &#8211; Microsoft<\/figcaption><\/figure><\/div>\n\n\n\n<p>Azure Monitor logs are built on Azure Data Explorer, and Azure Monitor log queries use a version of the same Kusto query language. The&nbsp;Kusto query language documentation&nbsp;has all of the details for the language and should be your primary resource for writing Azure Monitor log queries.<\/p>\n\n\n\n<p>Each action is made up of the following properties:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Type<\/strong>: The notification or action performed. Examples include sending a voice call, SMS, email; or triggering various types of automated actions. See types later in this article.<\/li><li><strong>Name<\/strong>: A unique identifier within the action group.<\/li><li><strong>Details<\/strong>: The corresponding details that vary by&nbsp;<em>type<\/em>.<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"run-queries-against-log-analytics\"><strong>Run queries against Log Analytics<\/strong><\/h3>\n\n\n\n<p>Furthermore, you can Navigate to your Log Analytics workspace where you can do the following:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Analyze logs using log queries and save queries for reuse<\/li><li>Save queries for reuse<\/li><li>Create log alerts<\/li><li>Pin query results to a dashboard<\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"664\" height=\"472\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/07\/log_analytics_workspace_queries.png\" alt=\"How to monitor workload?\" class=\"wp-image-14064\" srcset=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/07\/log_analytics_workspace_queries.png 664w, https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/07\/log_analytics_workspace_queries-563x400.png 563w\" sizes=\"auto, (max-width: 664px) 100vw, 664px\" \/><figcaption>Image Source &#8211; Microsoft<\/figcaption><\/figure><\/div>\n\n\n\n<figure class=\"wp-block-image is-resized\"><a href=\"https:\/\/www.testpreptraining.ai\/microsoft-azure-architect-technologies-az-303-free-practice-test\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/07\/Untitled-design-5.png\" alt=\"free practice test for AZ- 303\" width=\"952\" height=\"148\"\/><\/a><\/figure>\n\n\n\n<p><a rel=\"noreferrer noopener\" href=\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-az-303-microsoft-azure-architect-technologies\/\" target=\"_blank\"><strong>Go back to home page<\/strong><\/a><\/p>\n\n\n\n<p class=\"has-text-align-right\"><strong>Reference documentation &#8211;<\/strong> <a rel=\"noreferrer noopener\" href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/synapse-analytics\/sql-data-warehouse\/sql-data-warehouse-monitor-workload-portal\" target=\"_blank\">Monitor workload &#8211; Azure portal<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>This tutorial will guide you on how to use the Azure portal to monitor your workload. This includes setting up Azure Monitor Logs to investigate query execution and workload trends using log analytics for&nbsp;Synapse SQL and creating workspace. You will need an Azure subscription: If you don&#8217;t have an Azure subscription, create a&nbsp;free account&nbsp;before you&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"footnotes":""},"categories":[],"tags":[],"class_list":["post-14059","page","type-page","status-publish","hentry"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Monitor Workload in Azure Portal - Testprep Training Tutorials<\/title>\n<meta name=\"description\" content=\"Enhance and upgrade your Azure Architect skills by preparing from tutorial - How to monitor workload and workspace? and passing AZ-303 Exam Now!\" \/>\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.testpreptraining.ai\/tutorial\/how-to-monitor-workload\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Monitor Workload in Azure Portal - Testprep Training Tutorials\" \/>\n<meta property=\"og:description\" content=\"Enhance and upgrade your Azure Architect skills by preparing from tutorial - How to monitor workload and workspace? and passing AZ-303 Exam Now!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.testpreptraining.ai\/tutorial\/how-to-monitor-workload\/\" \/>\n<meta property=\"og:site_name\" content=\"Testprep Training Tutorials\" \/>\n<meta property=\"article:modified_time\" content=\"2020-08-07T03:53:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/07\/add_analytics_workspace_2.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/how-to-monitor-workload\/\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/how-to-monitor-workload\/\",\"name\":\"Monitor Workload in Azure Portal - Testprep Training Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#website\"},\"datePublished\":\"2020-07-29T10:48:34+00:00\",\"dateModified\":\"2020-08-07T03:53:58+00:00\",\"description\":\"Enhance and upgrade your Azure Architect skills by preparing from tutorial - How to monitor workload and workspace? and passing AZ-303 Exam Now!\",\"breadcrumb\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/how-to-monitor-workload\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.testpreptraining.ai\/tutorial\/how-to-monitor-workload\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/how-to-monitor-workload\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Monitor Workload in Azure Portal\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#website\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\",\"name\":\"Testprep Training Tutorials\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.testpreptraining.ai\/tutorial\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#organization\",\"name\":\"Testprep Training\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png\",\"contentUrl\":\"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png\",\"width\":583,\"height\":153,\"caption\":\"Testprep Training\"},\"image\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Monitor Workload in Azure Portal - Testprep Training Tutorials","description":"Enhance and upgrade your Azure Architect skills by preparing from tutorial - How to monitor workload and workspace? and passing AZ-303 Exam Now!","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.testpreptraining.ai\/tutorial\/how-to-monitor-workload\/","og_locale":"en_US","og_type":"article","og_title":"Monitor Workload in Azure Portal - Testprep Training Tutorials","og_description":"Enhance and upgrade your Azure Architect skills by preparing from tutorial - How to monitor workload and workspace? and passing AZ-303 Exam Now!","og_url":"https:\/\/www.testpreptraining.ai\/tutorial\/how-to-monitor-workload\/","og_site_name":"Testprep Training Tutorials","article_modified_time":"2020-08-07T03:53:58+00:00","og_image":[{"url":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/07\/add_analytics_workspace_2.png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/how-to-monitor-workload\/","url":"https:\/\/www.testpreptraining.ai\/tutorial\/how-to-monitor-workload\/","name":"Monitor Workload in Azure Portal - Testprep Training Tutorials","isPartOf":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#website"},"datePublished":"2020-07-29T10:48:34+00:00","dateModified":"2020-08-07T03:53:58+00:00","description":"Enhance and upgrade your Azure Architect skills by preparing from tutorial - How to monitor workload and workspace? and passing AZ-303 Exam Now!","breadcrumb":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/how-to-monitor-workload\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.testpreptraining.ai\/tutorial\/how-to-monitor-workload\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/how-to-monitor-workload\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.testpreptraining.ai\/tutorial\/"},{"@type":"ListItem","position":2,"name":"Monitor Workload in Azure Portal"}]},{"@type":"WebSite","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#website","url":"https:\/\/www.testpreptraining.ai\/tutorial\/","name":"Testprep Training Tutorials","description":"","publisher":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.testpreptraining.ai\/tutorial\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#organization","name":"Testprep Training","url":"https:\/\/www.testpreptraining.ai\/tutorial\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/","url":"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png","contentUrl":"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png","width":583,"height":153,"caption":"Testprep Training"},"image":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/14059","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/comments?post=14059"}],"version-history":[{"count":3,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/14059\/revisions"}],"predecessor-version":[{"id":15641,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/14059\/revisions\/15641"}],"wp:attachment":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/media?parent=14059"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/categories?post=14059"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/tags?post=14059"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}