{"id":7654,"date":"2022-08-16T00:00:00","date_gmt":"2022-08-16T00:00:00","guid":{"rendered":"https:\/\/azure.microsoft.com\/blog\/azure-data-explorer-log-and-telemetry-analytics-benchmark"},"modified":"2025-06-12T05:14:20","modified_gmt":"2025-06-12T12:14:20","slug":"azure-data-explorer-log-and-telemetry-analytics-benchmark","status":"publish","type":"post","link":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-explorer-log-and-telemetry-analytics-benchmark\/","title":{"rendered":"Azure Data Explorer: Log and telemetry analytics benchmark"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/azuredataexplorer.com\">Azure Data Explorer<\/a> (ADX), a component of Azure Synapse Analytics, is a highly scalable analytics service optimized for structured, semi-structured, and unstructured data. It provides users with an interactive query experience that unlocks insights from the ocean of ever-growing log and telemetry data. It is the perfect service to analyze high volumes of fresh and historical data in the cloud by using SQL or the Kusto Query Language (KQL), a powerful and user-friendly query language.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Azure Data Explorer is a key enabler for <a href=\"https:\/\/www.youtube.com\/watch?v=oBYNl2WWYx0\" target=\"_blank\" rel=\"noopener\">Microsoft\u2019s own digital transformation<\/a>. Virtually all Microsoft products and services use ADX in one way or another; this includes troubleshooting, diagnosis, monitoring, machine learning, and as a data platform for Azure services such as Azure Monitor, PlayFab, Sentinel, Microsoft 365 Defender, and many others. Microsoft\u2019s <a href=\"https:\/\/aka.ms\/adx.kustomers\" target=\"_blank\" rel=\"noopener\">customers and partners<\/a> are using ADX for a large variety of scenarios from fleet management, manufacturing, security analytics solutions, package tracking and logistics, IoT device monitoring, financial transaction monitoring, and many other scenarios. Over the last years, the service has seen phenomenal growth and is now running on millions of Azure virtual machine cores.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Last year, the third generation of the Kusto engine (<a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/data-explorer\/engine-v3\" target=\"_blank\" rel=\"noopener\">EngineV3<\/a>) was released and is currently offered as a transparent, in-place upgrade to all users not already using the latest version. The new engine features a completely new implementation of the storage, cache, and query execution layers. As a result, performance has doubled or more in many mission-critical workloads.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"superior-performance-and-cost-efficiency-with-azure-data-explorer\">Superior performance and cost-efficiency with Azure Data Explorer<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">To better help our users assess the performance of the new engine and cost advantages of ADX, we looked for an existing telemetry and logs benchmark that has the workload characteristics common to what we see with our users:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li class=\"wp-block-list-item\">Telemetry tables that contain structured, semi-structured, and unstructured data types.<\/li>\n\n\n\n<li class=\"wp-block-list-item\">Records in the hundreds of billions to test massive scale.<\/li>\n\n\n\n<li class=\"wp-block-list-item\">Queries that represent common diagnostic and monitoring scenarios.<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">As we did not find an existing benchmark to meet these needs, we collaborated with and sponsored <a href=\"https:\/\/gigaom.com\/\" target=\"_blank\" rel=\"noopener\">GigaOm<\/a> to create and run one. The new logs and telemetry benchmark is publicly available in this <a href=\"https:\/\/github.com\/microsoft\/TelemetryLogsGeneratorAndBenchmark\" target=\"_blank\" rel=\"noopener\">GitHub repo<\/a>. This repository includes a data generator to generate datasets of 1GB, 1TB, and 100TB, as well as a set of 19 queries and a test driver to execute the benchmark.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The results, now available in the <a href=\"https:\/\/research.gigaom.com\/report\/log-data-analytics-testing\/\" target=\"_blank\" rel=\"noopener\">GigaOm report<\/a><b>,<\/b> show that Azure Data Explorer provides superior performance at a significantly lower cost in both single and high-concurrency scenarios. For example, the following chart taken from the report displays the results of executing the benchmark while simulating 50 concurrent users:&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2022\/08\/546b1a46-3783-4110-a2d9-d5dae825e6f9.webp\" alt=\"A column chart comparing Google BigQuery, Snowflake, and Azure Data Explorer query execution times. The measurement is the sum of average query runs for all 19 queries by 50 concurrent users. The chart shows the following measurements: Google BigQuery 1159.15 Seconds, Snowflake 1238.47 seconds, and Azure Data Explorer 54.52 seconds.\" title=\"\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"learn-more\">Learn more<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">For further insights, we highly recommend reading the <a href=\"https:\/\/research.gigaom.com\/report\/log-data-analytics-testing\/\" target=\"_blank\" rel=\"noopener\">full report<\/a>. And don\u2019t just take our word for it. Use the Azure Data Explorer <a href=\"https:\/\/docs.microsoft.com\/azure\/data-explorer\/start-for-free-web-ui\">free offering<\/a> to load your data and analyze it at extreme speed and unmatched productivity.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Check out our documentation to <a href=\"https:\/\/docs.microsoft.com\/azure\/data-explorer\/data-explorer-overview\" target=\"_blank\" rel=\"noopener\">find out more about Azure Data Explorer<\/a> and <a href=\"https:\/\/docs.microsoft.com\/azure\/synapse-analytics\/overview-what-is\" target=\"_blank\" rel=\"noopener\">learn more about Azure Synapse Analytics<\/a>. For deeper technical information, check out the new book <em><a href=\"https:\/\/www.amazon.com\/Scalable-Data-Analytics-Azure-Explorer\/dp\/1801078548\" target=\"_blank\" rel=\"noopener\">Scalable Data Analytics with Azure Data Explorer<\/a><\/em> by Jason Myerscough.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Azure Data Explorer, a component of Azure Synapse Analytics, is a highly scalable analytics service optimized for structured, semi-structured, and unstructured data. It provides users with an interactive query experience that unlocks insights from the ocean of ever-growing log and telemetry data. It is the perfect service to analyze high volumes of fresh and historical data in the cloud by using SQL or the Kusto Query Language (KQL), a powerful and user-friendly query language. The GigaOm report shows that Azure Data Explorer provides superior performance at a significantly lower cost than both Snowflake and Google BigQuery.<\/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":[1474],"tags":[],"audience":[3054,3057,3053],"content-type":[1465],"product":[1522,1477],"tech-community":[],"topic":[],"coauthors":[1752],"class_list":["post-7654","post","type-post","status-publish","format-standard","hentry","category-analytics","audience-business-decision-makers","audience-data-professionals","audience-it-decision-makers","content-type-announcements","product-azure-data-explorer","product-azure-synapse-analytics","review-flag-free-1680286579-836","review-flag-iot-1680286585-835","review-flag-machi-1680286585-314","review-flag-microsofts","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>Azure Data Explorer: Log and telemetry analytics benchmark | Microsoft Azure Blog<\/title>\n<meta name=\"description\" content=\"Azure Data Explorer, a component of Azure Synapse Analytics, is a highly scalable analytics service optimized for structured, semi-structured, and unstructured data. It provides users with an interactive query experience that unlocks insights from the ocean of ever-growing log and telemetry data. It is the perfect service to analyze high volumes of fresh and historical data in the cloud by using SQL or the Kusto Query Language (KQL), a powerful and user-friendly query language. The GigaOm report shows that Azure Data Explorer provides superior performance at a significantly lower cost than both Snowflake and Google BigQuery.\" \/>\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\/azure-data-explorer-log-and-telemetry-analytics-benchmark\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Azure Data Explorer: Log and telemetry analytics benchmark | Microsoft Azure Blog\" \/>\n<meta property=\"og:description\" content=\"Azure Data Explorer, a component of Azure Synapse Analytics, is a highly scalable analytics service optimized for structured, semi-structured, and unstructured data. It provides users with an interactive query experience that unlocks insights from the ocean of ever-growing log and telemetry data. It is the perfect service to analyze high volumes of fresh and historical data in the cloud by using SQL or the Kusto Query Language (KQL), a powerful and user-friendly query language. The GigaOm report shows that Azure Data Explorer provides superior performance at a significantly lower cost than both Snowflake and Google BigQuery.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-explorer-log-and-telemetry-analytics-benchmark\/\" \/>\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=\"2022-08-16T00:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-12T12:14:20+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2022\/08\/546b1a46-3783-4110-a2d9-d5dae825e6f9.webp\" \/>\n<meta name=\"author\" content=\"Arun Ulag\" \/>\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=\"Arun Ulag\" \/>\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\/azure-data-explorer-log-and-telemetry-analytics-benchmark\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-explorer-log-and-telemetry-analytics-benchmark\/\"},\"author\":[{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/arun-ulagaratchagan\/\",\"@type\":\"Person\",\"@name\":\"Arun Ulag\"}],\"headline\":\"Azure Data Explorer: Log and telemetry analytics benchmark\",\"datePublished\":\"2022-08-16T00:00:00+00:00\",\"dateModified\":\"2025-06-12T12:14:20+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-explorer-log-and-telemetry-analytics-benchmark\/\"},\"wordCount\":516,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-explorer-log-and-telemetry-analytics-benchmark\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2022\/08\/546b1a46-3783-4110-a2d9-d5dae825e6f9.webp\",\"articleSection\":[\"Analytics\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-explorer-log-and-telemetry-analytics-benchmark\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-explorer-log-and-telemetry-analytics-benchmark\/\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-explorer-log-and-telemetry-analytics-benchmark\/\",\"name\":\"Azure Data Explorer: Log and telemetry analytics benchmark | Microsoft Azure Blog\",\"isPartOf\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-explorer-log-and-telemetry-analytics-benchmark\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-explorer-log-and-telemetry-analytics-benchmark\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2022\/08\/546b1a46-3783-4110-a2d9-d5dae825e6f9.webp\",\"datePublished\":\"2022-08-16T00:00:00+00:00\",\"dateModified\":\"2025-06-12T12:14:20+00:00\",\"description\":\"Azure Data Explorer, a component of Azure Synapse Analytics, is a highly scalable analytics service optimized for structured, semi-structured, and unstructured data. It provides users with an interactive query experience that unlocks insights from the ocean of ever-growing log and telemetry data. It is the perfect service to analyze high volumes of fresh and historical data in the cloud by using SQL or the Kusto Query Language (KQL), a powerful and user-friendly query language. The GigaOm report shows that Azure Data Explorer provides superior performance at a significantly lower cost than both Snowflake and Google BigQuery.\",\"breadcrumb\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-explorer-log-and-telemetry-analytics-benchmark\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-explorer-log-and-telemetry-analytics-benchmark\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-explorer-log-and-telemetry-analytics-benchmark\/#primaryimage\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2022\/08\/546b1a46-3783-4110-a2d9-d5dae825e6f9.webp\",\"contentUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2022\/08\/546b1a46-3783-4110-a2d9-d5dae825e6f9.webp\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-explorer-log-and-telemetry-analytics-benchmark\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Blog home\",\"item\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Analytics\",\"item\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/category\/analytics\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Azure Data Explorer: Log and telemetry analytics benchmark\"}]},{\"@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":"Azure Data Explorer: Log and telemetry analytics benchmark | Microsoft Azure Blog","description":"Azure Data Explorer, a component of Azure Synapse Analytics, is a highly scalable analytics service optimized for structured, semi-structured, and unstructured data. It provides users with an interactive query experience that unlocks insights from the ocean of ever-growing log and telemetry data. It is the perfect service to analyze high volumes of fresh and historical data in the cloud by using SQL or the Kusto Query Language (KQL), a powerful and user-friendly query language. The GigaOm report shows that Azure Data Explorer provides superior performance at a significantly lower cost than both Snowflake and Google BigQuery.","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\/azure-data-explorer-log-and-telemetry-analytics-benchmark\/","og_locale":"en_US","og_type":"article","og_title":"Azure Data Explorer: Log and telemetry analytics benchmark | Microsoft Azure Blog","og_description":"Azure Data Explorer, a component of Azure Synapse Analytics, is a highly scalable analytics service optimized for structured, semi-structured, and unstructured data. It provides users with an interactive query experience that unlocks insights from the ocean of ever-growing log and telemetry data. It is the perfect service to analyze high volumes of fresh and historical data in the cloud by using SQL or the Kusto Query Language (KQL), a powerful and user-friendly query language. The GigaOm report shows that Azure Data Explorer provides superior performance at a significantly lower cost than both Snowflake and Google BigQuery.","og_url":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-explorer-log-and-telemetry-analytics-benchmark\/","og_site_name":"Microsoft Azure Blog","article_publisher":"https:\/\/www.facebook.com\/microsoftazure","article_published_time":"2022-08-16T00:00:00+00:00","article_modified_time":"2025-06-12T12:14:20+00:00","og_image":[{"url":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2022\/08\/546b1a46-3783-4110-a2d9-d5dae825e6f9.webp","type":"","width":"","height":""}],"author":"Arun Ulag","twitter_card":"summary_large_image","twitter_creator":"@azure","twitter_site":"@azure","twitter_misc":{"Written by":"Arun Ulag","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-explorer-log-and-telemetry-analytics-benchmark\/#article","isPartOf":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-explorer-log-and-telemetry-analytics-benchmark\/"},"author":[{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/arun-ulagaratchagan\/","@type":"Person","@name":"Arun Ulag"}],"headline":"Azure Data Explorer: Log and telemetry analytics benchmark","datePublished":"2022-08-16T00:00:00+00:00","dateModified":"2025-06-12T12:14:20+00:00","mainEntityOfPage":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-explorer-log-and-telemetry-analytics-benchmark\/"},"wordCount":516,"commentCount":0,"publisher":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization"},"image":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-explorer-log-and-telemetry-analytics-benchmark\/#primaryimage"},"thumbnailUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2022\/08\/546b1a46-3783-4110-a2d9-d5dae825e6f9.webp","articleSection":["Analytics"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-explorer-log-and-telemetry-analytics-benchmark\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-explorer-log-and-telemetry-analytics-benchmark\/","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-explorer-log-and-telemetry-analytics-benchmark\/","name":"Azure Data Explorer: Log and telemetry analytics benchmark | Microsoft Azure Blog","isPartOf":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-explorer-log-and-telemetry-analytics-benchmark\/#primaryimage"},"image":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-explorer-log-and-telemetry-analytics-benchmark\/#primaryimage"},"thumbnailUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2022\/08\/546b1a46-3783-4110-a2d9-d5dae825e6f9.webp","datePublished":"2022-08-16T00:00:00+00:00","dateModified":"2025-06-12T12:14:20+00:00","description":"Azure Data Explorer, a component of Azure Synapse Analytics, is a highly scalable analytics service optimized for structured, semi-structured, and unstructured data. It provides users with an interactive query experience that unlocks insights from the ocean of ever-growing log and telemetry data. It is the perfect service to analyze high volumes of fresh and historical data in the cloud by using SQL or the Kusto Query Language (KQL), a powerful and user-friendly query language. The GigaOm report shows that Azure Data Explorer provides superior performance at a significantly lower cost than both Snowflake and Google BigQuery.","breadcrumb":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-explorer-log-and-telemetry-analytics-benchmark\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-explorer-log-and-telemetry-analytics-benchmark\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-explorer-log-and-telemetry-analytics-benchmark\/#primaryimage","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2022\/08\/546b1a46-3783-4110-a2d9-d5dae825e6f9.webp","contentUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2022\/08\/546b1a46-3783-4110-a2d9-d5dae825e6f9.webp"},{"@type":"BreadcrumbList","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-explorer-log-and-telemetry-analytics-benchmark\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog home","item":"https:\/\/azure.microsoft.com\/en-us\/blog\/"},{"@type":"ListItem","position":2,"name":"Analytics","item":"https:\/\/azure.microsoft.com\/en-us\/blog\/category\/analytics\/"},{"@type":"ListItem","position":3,"name":"Azure Data Explorer: Log and telemetry analytics benchmark"}]},{"@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\/7654","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=7654"}],"version-history":[{"count":1,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts\/7654\/revisions"}],"predecessor-version":[{"id":41598,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts\/7654\/revisions\/41598"}],"wp:attachment":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/media?parent=7654"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/categories?post=7654"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/tags?post=7654"},{"taxonomy":"audience","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/audience?post=7654"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/content-type?post=7654"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/product?post=7654"},{"taxonomy":"tech-community","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/tech-community?post=7654"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/topic?post=7654"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/coauthors?post=7654"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}