{"id":8176,"date":"2019-02-04T07:15:01","date_gmt":"2019-02-04T12:15:01","guid":{"rendered":"https:\/\/www.eginnovations.com\/blog\/?p=8176"},"modified":"2022-08-28T03:40:50","modified_gmt":"2022-08-28T07:40:50","slug":"slow-database-query","status":"publish","type":"post","link":"https:\/\/www.eginnovations.com\/blog\/slow-database-query\/","title":{"rendered":"How to Detect Slow Database Queries <br>Affecting Application Performance"},"content":{"rendered":"<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-8179 alignright\" src=\"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2019\/01\/slow-database-query-monitoring.jpg\" alt=\"Slow Database Query Detection from eG Innovations\" width=\"300\" height=\"200\" border=\"0\" srcset=\"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2019\/01\/slow-database-query-monitoring.jpg 300w, https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2019\/01\/slow-database-query-monitoring-140x93.jpg 140w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/>The biggest challenge when a user complains of slow application is diagnosing why it\u2019s slow: Is it due to a code-level issue or a database issue? Should we call the DBA or the application manager? Performance problems with the database can cause up to 70% of all application performance issues in production, according to consensus among database practitioners and experts. Numerous factors ranging from poor query design to missing indexes to a <a href=\"https:\/\/www.eginnovations.com\/supported-technologies\/database-monitoring\">database performance<\/a> issue in the backend infrastructure can negatively impact application processing.<\/p>\n<p>If there\u2019s a poorly designed database query that is slowing down user transactions during application access, how can you flag it immediately?<\/p>\n<p>eG Enterprise is a <a href=\"https:\/\/www.eginnovations.com\/converged-application-infrastructure-monitoring\" target=\"_self\" rel=\"noopener noreferrer\">converged application and infrastructure monitoring<\/a> and troubleshooting solution that helps you understand how infrastructure issues, including database bottlenecks, are affecting application performance. Using byte-code instrumentation, eG Enterprise traces every user request processed by the application all the way to the database and back. This helps understand which stage of application processing is slow \u2013 whether there\u2019s slowness in the application server or in the database; whether it\u2019s an application code-level issue or database query issue.<\/p>\n<p><a href=\"https:\/\/www.youtube.com\/watch?v=nvroh-P8nIY\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Watch this 3-minute video<\/a> and learn how eG Enterprise uses distributed transaction tracing to isolate slow database queries that are affecting application performance.<\/p>\n<div style=\"margin: 0 auto; max-width: 640px; margin-bottom: 20px;\"><a class=\"video-eg\" href=\"https:\/\/www.youtube.com\/embed\/nvroh-P8nIY\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2019\/02\/Application-Monitoring_-Detect-if-slow-database-queries-are-slowing-your-application-1024x576.jpeg\" alt=\"\" width=\"640\" height=\"360\" class=\"aligncenter size-large wp-image-33586\" srcset=\"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2019\/02\/Application-Monitoring_-Detect-if-slow-database-queries-are-slowing-your-application-1024x576.jpeg 1024w, https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2019\/02\/Application-Monitoring_-Detect-if-slow-database-queries-are-slowing-your-application-300x169.jpeg 300w, https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2019\/02\/Application-Monitoring_-Detect-if-slow-database-queries-are-slowing-your-application-768x432.jpeg 768w, https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2019\/02\/Application-Monitoring_-Detect-if-slow-database-queries-are-slowing-your-application-1536x864.jpeg 1536w, https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2019\/02\/Application-Monitoring_-Detect-if-slow-database-queries-are-slowing-your-application-800x450.jpeg 800w, https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2019\/02\/Application-Monitoring_-Detect-if-slow-database-queries-are-slowing-your-application-310x174.jpeg 310w, https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2019\/02\/Application-Monitoring_-Detect-if-slow-database-queries-are-slowing-your-application-140x79.jpeg 140w, https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2019\/02\/Application-Monitoring_-Detect-if-slow-database-queries-are-slowing-your-application.jpeg 1920w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/a><\/div>\n<p>Slow queries are not the end of it. There could be many other database and other infrastructure issues affecting your application. For example, memory shortage on a VM where the database is running, hotspots in the SAN array, slow network connectivity, cloud infrastructure issues, and so on. Read this white paper by APM expert Larry Dragich and understand the need for a converged application and infrastructure monitoring strategy.<\/p>\n<div class=\"frm-cta mtop30\"><a class=\"frm-cta-link\" href=\"https:\/\/www.eginnovations.com\/white-paper\/converged-monitoring\" target=\"_self\" rel=\"noopener noreferrer\">White Paper: The Case for Converged App &amp; Infra Monitoring<\/a><\/div>\n","protected":false},"excerpt":{"rendered":"<p>The biggest challenge when a user complains of slow application is diagnosing why it\u2019s slow: Is it due to a code-level issue or a database issue? Should we call the DBA or the application manager? Performance problems with the database can cause up to 70% of all application performance issues in production, according to consensus [&hellip;]<\/p>\n","protected":false},"author":15,"featured_media":8182,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"_lmt_disableupdate":"yes","_lmt_disable":"","footnotes":""},"categories":[371,366,382],"tags":[126,171,476],"class_list":["post-8176","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-application-performance-monitoring-apm","category-end-to-end-monitoring-e2e","category-unified-monitoring","tag-database-monitoring","tag-java","tag-microsoft-net"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Slow Database Queries and Application Performance Tuning<\/title>\n<meta name=\"description\" content=\"Is your application slow due to a slow database queries? Find out how to track down long-running queries impacting application transactions.\" \/>\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.eginnovations.com\/blog\/slow-database-query\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Slow Database Query Detection | eG Innovations Blog\" \/>\n<meta property=\"og:description\" content=\"Is the application slow due to a slow query issues to the database? Find out how to track down long-running queries impacting application transactions.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.eginnovations.com\/blog\/slow-database-query\/\" \/>\n<meta property=\"og:site_name\" content=\"eG Innovations\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/eGInnovations\" \/>\n<meta property=\"article:published_time\" content=\"2019-02-04T12:15:01+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-08-28T07:40:50+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2019\/01\/slow-database-queries.jpg\" \/>\n<meta name=\"author\" content=\"Vinod Mohan\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Slow Database Query Detection | eG Innovations Blog\" \/>\n<meta name=\"twitter:description\" content=\"Is the application slow due to a slow query issues to the database? Find out how to track down long-running queries impacting application transactions.\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2019\/01\/queries-performance-slow.jpg\" \/>\n<meta name=\"twitter:creator\" content=\"@eginnovations\" \/>\n<meta name=\"twitter:site\" content=\"@eginnovations\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Vinod Mohan\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Slow Database Queries and Application Performance Tuning","description":"Is your application slow due to a slow database queries? Find out how to track down long-running queries impacting application transactions.","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.eginnovations.com\/blog\/slow-database-query\/","og_locale":"en_US","og_type":"article","og_title":"Slow Database Query Detection | eG Innovations Blog","og_description":"Is the application slow due to a slow query issues to the database? Find out how to track down long-running queries impacting application transactions.","og_url":"https:\/\/www.eginnovations.com\/blog\/slow-database-query\/","og_site_name":"eG Innovations","article_publisher":"https:\/\/www.facebook.com\/eGInnovations","article_published_time":"2019-02-04T12:15:01+00:00","article_modified_time":"2022-08-28T07:40:50+00:00","og_image":[{"url":"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2019\/01\/slow-database-queries.jpg","type":"","width":"","height":""}],"author":"Vinod Mohan","twitter_card":"summary_large_image","twitter_title":"Slow Database Query Detection | eG Innovations Blog","twitter_description":"Is the application slow due to a slow query issues to the database? Find out how to track down long-running queries impacting application transactions.","twitter_image":"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2019\/01\/queries-performance-slow.jpg","twitter_creator":"@eginnovations","twitter_site":"@eginnovations","twitter_misc":{"Written by":"Vinod Mohan","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.eginnovations.com\/blog\/slow-database-query\/#article","isPartOf":{"@id":"https:\/\/www.eginnovations.com\/blog\/slow-database-query\/"},"author":{"name":"Vinod Mohan","@id":"https:\/\/www.eginnovations.com\/blog\/#\/schema\/person\/0b821d650520e5ce664e5073c984e972"},"headline":"How to Detect Slow Database Queries Affecting Application Performance","datePublished":"2019-02-04T12:15:01+00:00","dateModified":"2022-08-28T07:40:50+00:00","mainEntityOfPage":{"@id":"https:\/\/www.eginnovations.com\/blog\/slow-database-query\/"},"wordCount":297,"commentCount":0,"publisher":{"@id":"https:\/\/www.eginnovations.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.eginnovations.com\/blog\/slow-database-query\/#primaryimage"},"thumbnailUrl":"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2019\/01\/slow-queries-detection.jpg","keywords":["Database monitoring","Java","Microsoft .NET"],"articleSection":["Application Performance Monitoring (APM)","End-to-End Monitoring (E2E)","Unified Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.eginnovations.com\/blog\/slow-database-query\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.eginnovations.com\/blog\/slow-database-query\/","url":"https:\/\/www.eginnovations.com\/blog\/slow-database-query\/","name":"Slow Database Queries and Application Performance Tuning","isPartOf":{"@id":"https:\/\/www.eginnovations.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.eginnovations.com\/blog\/slow-database-query\/#primaryimage"},"image":{"@id":"https:\/\/www.eginnovations.com\/blog\/slow-database-query\/#primaryimage"},"thumbnailUrl":"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2019\/01\/slow-queries-detection.jpg","datePublished":"2019-02-04T12:15:01+00:00","dateModified":"2022-08-28T07:40:50+00:00","description":"Is your application slow due to a slow database queries? Find out how to track down long-running queries impacting application transactions.","breadcrumb":{"@id":"https:\/\/www.eginnovations.com\/blog\/slow-database-query\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.eginnovations.com\/blog\/slow-database-query\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.eginnovations.com\/blog\/slow-database-query\/#primaryimage","url":"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2019\/01\/slow-queries-detection.jpg","contentUrl":"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2019\/01\/slow-queries-detection.jpg","width":300,"height":200,"caption":"Slow Database Queries Detection"},{"@type":"BreadcrumbList","@id":"https:\/\/www.eginnovations.com\/blog\/slow-database-query\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.eginnovations.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to Detect Slow Database Queries Affecting Application Performance"}]},{"@type":"WebSite","@id":"https:\/\/www.eginnovations.com\/blog\/#website","url":"https:\/\/www.eginnovations.com\/blog\/","name":"eG Innovations","description":"IT Performance Monitoring Insights","publisher":{"@id":"https:\/\/www.eginnovations.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.eginnovations.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.eginnovations.com\/blog\/#organization","name":"eG Innovations","alternateName":"eg innovations","url":"https:\/\/www.eginnovations.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.eginnovations.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2014\/07\/eg-logo-dark-gray1_new.jpg","contentUrl":"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2014\/07\/eg-logo-dark-gray1_new.jpg","width":362,"height":235,"caption":"eG Innovations"},"image":{"@id":"https:\/\/www.eginnovations.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/eGInnovations","https:\/\/x.com\/eginnovations"]},{"@type":"Person","@id":"https:\/\/www.eginnovations.com\/blog\/#\/schema\/person\/0b821d650520e5ce664e5073c984e972","name":"Vinod Mohan","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.eginnovations.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/1476c17889cb8f3329c5b96d947551af?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1476c17889cb8f3329c5b96d947551af?s=96&d=mm&r=g","caption":"Vinod Mohan"},"sameAs":["https:\/\/www.eginnovations.com","eguser"],"url":"https:\/\/www.eginnovations.com\/blog\/author\/vinodmohan\/"}]}},"modified_by":"eG Innovations","_links":{"self":[{"href":"https:\/\/www.eginnovations.com\/blog\/wp-json\/wp\/v2\/posts\/8176","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.eginnovations.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.eginnovations.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.eginnovations.com\/blog\/wp-json\/wp\/v2\/users\/15"}],"replies":[{"embeddable":true,"href":"https:\/\/www.eginnovations.com\/blog\/wp-json\/wp\/v2\/comments?post=8176"}],"version-history":[{"count":0,"href":"https:\/\/www.eginnovations.com\/blog\/wp-json\/wp\/v2\/posts\/8176\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.eginnovations.com\/blog\/wp-json\/wp\/v2\/media\/8182"}],"wp:attachment":[{"href":"https:\/\/www.eginnovations.com\/blog\/wp-json\/wp\/v2\/media?parent=8176"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.eginnovations.com\/blog\/wp-json\/wp\/v2\/categories?post=8176"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.eginnovations.com\/blog\/wp-json\/wp\/v2\/tags?post=8176"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}