{"id":27721,"date":"2022-11-30T07:30:38","date_gmt":"2022-11-30T12:30:38","guid":{"rendered":"https:\/\/www.eginnovations.com\/blog\/?p=27721"},"modified":"2023-04-14T09:45:34","modified_gmt":"2023-04-14T13:45:34","slug":"troubleshooting-azure-sql-database-performance-issues","status":"publish","type":"post","link":"https:\/\/www.eginnovations.com\/blog\/troubleshooting-azure-sql-database-performance-issues\/","title":{"rendered":"Troubleshooting Azure SQL Database Performance Issues"},"content":{"rendered":"<div class=\"inner_content\">\n<p>When applications suffer performance degradation often the root cause of the issue is a database problem. In this guide we&#8217;ll show you 7 ways of troubleshooting Azure SQL database performance issues using metrics and insights from the eG Enterprise monitoring solution.<\/p>\n<p style=\"margin-bottom: 15px;\">We recently published an article on the three <a href=\"https:\/\/www.eginnovations.com\/blog\/3-azure-sql-deployment-options\/\">Azure SQL deployment options<\/a> and how to choose between:<\/p>\n<ul>\n<li>Azure SQL Database<\/li>\n<li>Azure SQL Managed Instance<\/li>\n<li>SQL Server on Azure Virtual Machines (VMs)<\/li>\n<\/ul>\n<p>Regardless of which option you chose, eG Enterprise can proactively monitor and alert the database administrator to issues that could eventually impact performance and availability of the database and eventually impact end users and the applications that they rely on.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Troubleshooting_Azure_SQL_Database_Performance\"><\/span>Troubleshooting Azure SQL Database Performance<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>This guide will focus on 7 key ways in which you can ensure <a href=\"https:\/\/www.eginnovations.com\/supported-technologies\/microsoft-sql-server-performance-monitoring\">SQL database health<\/a> when using Azure SQL Database, including the key metrics, errors and logs to track and watch, troubleshooting tips, and how dashboards and reporting can be leveraged to communicate and track KPIs and SLAs.<\/p>\n<p>Although focused on Azure SQL Database, the interfaces and the advice in this article also applies to monitoring Azure SQL Managed Instance.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"7_Key_Ways_to_Troubleshoot_Monitor_and_Optimize_your_Azure_SQL_Deployments\"><\/span>7 Key Ways to Troubleshoot, Monitor and Optimize your Azure SQL Deployments<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"1_Monitoring_Azure_SQL_DTU_Usage_Against_the_Provisioned_Limit_and_its_Impact\"><\/span>1) Monitoring Azure SQL DTU Usage Against the Provisioned Limit and its Impact<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>A Database Transaction Unit (DTU) represents a blended measure of CPU, memory, reads, and writes on your database or elastic pool as a percentage. DTUs can be used within certain pricing models, a full definition and explanation of DTUs can be found in: <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/azure-sql\/database\/service-tiers-dtu?view=azuresql\" target=\"blank\" rel=\"noopener\">DTU-based purchasing model &#8211; Azure SQL Database | Microsoft Docs.<\/a><\/p>\n<p>DTU usage can be an indicator that access patterns have changed in the application, slow queries or that the database is near its capacity limits. Running at consistently high DTU usage, especially near 100% usage will be detrimental to the performance of your database and should be investigated as soon as possible.<\/p>\n<p>The resulting impact could be longer query times and rejected transactions due to timeouts.<\/p>\n<p><a href=\"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/SQL-DTU-Usage-view.jpg\" data-rel=\"lightbox-image-0\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27806\" src=\"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/SQL-DTU-Usage.webp\" alt=\"\" width=\"750\" height=\"149\" srcset=\"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/SQL-DTU-Usage.webp 750w, https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/SQL-DTU-Usage-300x60.webp 300w, https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/SQL-DTU-Usage-310x62.webp 310w, https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/SQL-DTU-Usage-140x28.webp 140w\" sizes=\"auto, (max-width: 750px) 100vw, 750px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/SQL-Azure-Statistics-view.jpg\" data-rel=\"lightbox-image-1\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27808\" src=\"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/SQL-Azure-Statistics.webp\" alt=\"\" width=\"750\" height=\"313\" srcset=\"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/SQL-Azure-Statistics.webp 750w, https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/SQL-Azure-Statistics-300x125.webp 300w, https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/SQL-Azure-Statistics-310x129.webp 310w, https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/SQL-Azure-Statistics-140x58.webp 140w\" sizes=\"auto, (max-width: 750px) 100vw, 750px\" \/><\/a><\/p>\n<p>To aid with troubleshooting, eG Enterprise monitors the DTU usage percentage levels as well as resource usage related to CPU, Memory, and IO.<\/p>\n<p><a href=\"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/SQL-DTU-Resources-view.jpg\" data-rel=\"lightbox-image-2\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27810\" src=\"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/SQL-DTU-Resources.webp\" alt=\"\" width=\"750\" height=\"250\" srcset=\"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/SQL-DTU-Resources.webp 750w, https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/SQL-DTU-Resources-300x100.webp 300w, https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/SQL-DTU-Resources-310x103.webp 310w, https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/SQL-DTU-Resources-140x47.webp 140w\" sizes=\"auto, (max-width: 750px) 100vw, 750px\" \/><\/a><\/p>\n<p>The eG Enterprise monitoring platform identifies the top queries by I\/O activities, CPU usage, memory usage and queries that are executing for excessive times. eG Enterprise also highlights details of the username, application, and query responsible for poor performance.<\/p>\n<p><a href=\"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/CPU-Intensive-view.jpg\" data-rel=\"lightbox-image-3\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27812\" src=\"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/CPU-Intensive.webp\" alt=\"\" width=\"750\" height=\"186\" srcset=\"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/CPU-Intensive.webp 750w, https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/CPU-Intensive-300x74.webp 300w, https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/CPU-Intensive-310x77.webp 310w, https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/CPU-Intensive-140x35.webp 140w\" sizes=\"auto, (max-width: 750px) 100vw, 750px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/Intensive-view.jpg\" data-rel=\"lightbox-image-4\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27814\" src=\"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/Intensive.webp\" alt=\"\" width=\"750\" height=\"227\" srcset=\"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/Intensive.webp 750w, https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/Intensive-300x91.webp 300w, https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/Intensive-310x94.webp 310w, https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/Intensive-140x42.webp 140w\" sizes=\"auto, (max-width: 750px) 100vw, 750px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/Memory-Intensive-view.jpg\" data-rel=\"lightbox-image-5\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27816\" src=\"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/Memory-Intensive.webp\" alt=\"\" width=\"750\" height=\"224\" srcset=\"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/Memory-Intensive.webp 750w, https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/Memory-Intensive-300x90.webp 300w, https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/Memory-Intensive-310x93.webp 310w, https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/Memory-Intensive-140x42.webp 140w\" sizes=\"auto, (max-width: 750px) 100vw, 750px\" \/><\/a><\/p>\n<p>The platform also provides drill downs for the execution plan details of the poorly performing queries and thereby helps to optimize queries and help with troubleshooting your Azure SQL database for better performance.<\/p>\n<p><a href=\"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/SQL-execution-plan-view.jpg\" data-rel=\"lightbox-image-6\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27819\" src=\"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/SQL-execution-plan.webp\" alt=\"\" width=\"750\" height=\"441\" srcset=\"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/SQL-execution-plan.webp 750w, https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/SQL-execution-plan-300x176.webp 300w, https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/SQL-execution-plan-310x182.webp 310w, https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/SQL-execution-plan-140x82.webp 140w\" sizes=\"auto, (max-width: 750px) 100vw, 750px\" \/><\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"2_Monitor_for_Slowness_or_Slowdowns_of_the_Database_Impacting_User_Sessions_and_Identify_Connection_Leaks_in_the_Database\"><\/span>2) Monitor for Slowness or Slowdowns of the Database Impacting User Sessions and Identify Connection Leaks in the Database<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>To ensure database and application availability for end-users you need to monitor the session activity to identify connection leaks and get proactive notifications if there are a growing number of connections due to resource contention in the database.<\/p>\n<p>The <a href=\"https:\/\/www.eginnovations.com\/blog\/aiops-tools-capabilities\/\">AIOps (Artificial Intelligence for IT Operations) engine<\/a> within the eG Enterprise platform will learn about normal connection patterns and apply dynamic thresholds that automatically alert the administrator to anomalous and abnormal behavior, allowing you to troubleshoot before end-users are impacted.<\/p>\n<p><a href=\"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/SQL-Response-Time-view.jpg\" data-rel=\"lightbox-image-7\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27840\" src=\"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/SQL-Response-Time.webp\" alt=\"\" width=\"750\" height=\"238\" srcset=\"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/SQL-Response-Time.webp 750w, https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/SQL-Response-Time-300x95.webp 300w, https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/SQL-Response-Time-310x98.webp 310w, https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/SQL-Response-Time-140x44.webp 140w\" sizes=\"auto, (max-width: 750px) 100vw, 750px\" \/><\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"3_Monitor_Session_Waits_and_Identify_the_Queries_that_are_Waiting_for_Excessive_times_for_a_Specific_wait_Resource\"><\/span>3) Monitor Session Waits and Identify the Queries that are Waiting for Excessive times for a Specific wait Resource<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>SQL Server Wait time can be described as the elapsed time until the worker thread suspended status returns to the running status. The wait times are captured and recorded by the SQL Server and bundled into a metric called wait statistics. This provides assistance to resolve problems that are related to the SQL Server performance and helps identify and optimize the queries which consume high resources of the system.<\/p>\n<p><a href=\"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/SQL-Wait-Activity-view.jpg\" data-rel=\"lightbox-image-8\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27842\" src=\"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/SQL-Wait-Activity.webp\" alt=\"\" width=\"750\" height=\"152\" srcset=\"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/SQL-Wait-Activity.webp 750w, https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/SQL-Wait-Activity-300x61.webp 300w, https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/SQL-Wait-Activity-310x63.webp 310w, https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/SQL-Wait-Activity-140x28.webp 140w\" sizes=\"auto, (max-width: 750px) 100vw, 750px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/SQL-Session-Waits-view.jpg\" data-rel=\"lightbox-image-9\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27846\" src=\"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/SQL-Session-Waits.webp\" alt=\"\" width=\"750\" height=\"170\" srcset=\"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/SQL-Session-Waits.webp 750w, https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/SQL-Session-Waits-300x68.webp 300w, https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/SQL-Session-Waits-310x70.webp 310w, https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/SQL-Session-Waits-140x32.webp 140w\" sizes=\"auto, (max-width: 750px) 100vw, 750px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/SQL-Wait-Types-view.jpg\" data-rel=\"lightbox-image-10\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27844\" src=\"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/SQL-Wait-Types.webp\" alt=\"\" width=\"750\" height=\"211\" srcset=\"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/SQL-Wait-Types.webp 750w, https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/SQL-Wait-Types-300x84.webp 300w, https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/SQL-Wait-Types-310x87.webp 310w, https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/SQL-Wait-Types-140x39.webp 140w\" sizes=\"auto, (max-width: 750px) 100vw, 750px\" \/><\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"4_Track_all_Connections_to_the_Database_Server_by_State_and_Identify_Connections_that_are_Waiting_for_other_Connections\"><\/span>4) Track all Connections to the Database Server by State and Identify Connections that are Waiting for other Connections<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>eG Enterprise will report on root-blockers &#8211; i.e., queries that are blocking other queries and provide historical insights which are a key part of Azure SQL performance troubleshooting. Administrators can trace back in time and determine if inefficient queries are causing unnecessary locks. Detailed information is provided to identify root-blockers by SPID, programs running them, and queries issued.<\/p>\n<p><a href=\"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/SQL-database-process-view.jpg\" data-rel=\"lightbox-image-11\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27847\" src=\"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/SQL-database-process.webp\" alt=\"\" width=\"750\" height=\"438\" srcset=\"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/SQL-database-process.webp 750w, https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/SQL-database-process-300x175.webp 300w, https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/SQL-database-process-310x181.webp 310w, https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/SQL-database-process-140x82.webp 140w\" sizes=\"auto, (max-width: 750px) 100vw, 750px\" \/><\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"5_Leverage_Dashboards\"><\/span>5) Leverage Dashboards<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Out-of-the-box customizable dashboards are available for all major Azure databases including Azure SQL options. Providing actionable insights and detailed analytics to help with troubleshooting Azure SQL performance issues. In addition, role-based personalized dashboards can be made available to different stakeholders.<\/p>\n<p><a href=\"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/SQL-Dashboard-view.jpg\" data-rel=\"lightbox-image-12\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-27850 size-full\" src=\"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/SQL-Dashboard.webp\" alt=\"Troubleshooting Azure SQL database dashboard\" width=\"750\" height=\"359\" srcset=\"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/SQL-Dashboard.webp 750w, https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/SQL-Dashboard-300x144.webp 300w, https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/SQL-Dashboard-310x148.webp 310w, https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/SQL-Dashboard-140x67.webp 140w\" sizes=\"auto, (max-width: 750px) 100vw, 750px\" \/><\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"6_Monitor_Database_Indexing\"><\/span>6) Monitor Database Indexing<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Monitoring indexes is critical for Azure SQL database troubleshooting because the performance of the database impacts the applications depending on them. Over time, index fragmentation will cause a degradation in database performance and eventually poor application performance. eG Enterprise will automatically raise alerts if indexing issues start to occur allowing the database administrator to rectify issues long before end users experience issues with application performance. The platform provides detailed information on fragmented indexes and tables,<\/p>\n<p><a href=\"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/Database-indexing-view.jpg\" data-rel=\"lightbox-image-13\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27931\" src=\"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/Database-indexing.webp\" alt=\"\" width=\"750\" height=\"491\" srcset=\"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/Database-indexing.webp 750w, https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/Database-indexing-300x196.webp 300w, https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/Database-indexing-310x203.webp 310w, https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/Database-indexing-140x92.webp 140w\" sizes=\"auto, (max-width: 750px) 100vw, 750px\" \/><\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"7_Continually_Monitor_SQL_Log_Files\"><\/span>7) Continually Monitor SQL Log Files<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>eG Enterprise will continually monitor the SQL logs and provides detailed log analytics of SQL Server ensuring detailed information on critical errors such as deadlocks, query causing deadlock and details of the victim sessions, is always available. When performance problems happen, these metrics are critical when it comes to troubleshooting the root-cause of the slow down. Proactive alerts are configured out-of-the-box and can be tuned and customized by the administrator as required.<\/p>\n<p><a href=\"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/SQL-deadlock-view.jpg\" data-rel=\"lightbox-image-14\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27933\" src=\"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/SQL-deadlock.webp\" alt=\"\" width=\"750\" height=\"419\" srcset=\"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/SQL-deadlock.webp 750w, https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/SQL-deadlock-300x168.webp 300w, https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/SQL-deadlock-310x173.webp 310w, https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/SQL-deadlock-140x78.webp 140w\" sizes=\"auto, (max-width: 750px) 100vw, 750px\" \/><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Further_Information\"><\/span>Further Information:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li>For more information on eG Innovations wider portfolio of monitoring support for Azure services, please see: <a href=\"https:\/\/www.eginnovations.com\/supported-technologies\/azure-monitoring\">Azure Cloud Monitoring Tools &amp; Solutions | eG Innovations<\/a><\/li>\n<li>For information on eG Enterprise\u2019s support for on-premises Microsoft SQL Server deployments, see: <a href=\"https:\/\/www.eginnovations.com\/supported-technologies\/microsoft-sql-server-performance-monitoring\">Microsoft SQL Server Performance Monitoring | eG Innovations<\/a><\/li>\n<li><a href=\"https:\/\/cloudblogs.microsoft.com\/sqlserver\/2020\/03\/17\/tips-to-select-the-best-azure-sql-deployment-option\/\" target=\"blank\" rel=\"noopener\">Tips to select the best Azure SQL deployment option &#8211; Microsoft SQL Server Blog<\/a><\/li>\n<li><a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/azure-sql\/database\/features-comparison?view=azuresql\" target=\"blank\" rel=\"noopener\">Compare the database engine features of SQL Database and SQL Managed Instance &#8211; Azure SQL Database &amp; SQL Managed Instance | Microsoft Docs<\/a><\/li>\n<li>Recent announcements (Nov 2022) around feature parity between SQL Server and Azure SQL services from Microsoft point to a serious commitment to hybrid solutions and the benefits of using a solution such as eG Enterprise equally able to support migration between the two seamlessly, see: <a href=\"https:\/\/venturebeat.com\/data-infrastructure\/microsoft-releases-sql-server-2022-flagship-database-to-general-availability\/\">Microsoft releases SQL Server 2022 flagship database, unites on-premises and cloud services | VentureBeat<\/a><\/li>\n<\/ul>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>When applications suffer performance degradation often the root cause of the issue is a database problem. In this guide we&#8217;ll show you 7 ways of troubleshooting Azure SQL database performance issues using metrics and insights from the eG Enterprise monitoring solution. We recently published an article on the three Azure SQL deployment options and how [&hellip;]<\/p>\n","protected":false},"author":67,"featured_media":27980,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"_lmt_disableupdate":"no","_lmt_disable":"","footnotes":""},"categories":[404,1733],"tags":[405,415,1430,1866,1612,1869,1871,1868,1870,1728,183,184,240,1865,1867],"class_list":["post-27721","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-azure-monitoring","category-database-monitoring","tag-azure","tag-azure-monitoring","tag-azure-monitoring-tools","tag-azure-slow","tag-azure-sql","tag-azure-sql-bottleneck","tag-azure-sql-monitoring","tag-azure-sql-troubleshooting","tag-azure-sql-tuning","tag-microsoft-sql","tag-microsoft-sql-server","tag-microsoft-sql-server-performance","tag-sql-monitoring","tag-sql-slow","tag-sql-troubleshooting"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Troubleshoot Azure SQL Database Performance | eG Innovations<\/title>\n<meta name=\"description\" content=\"Learn how to troubleshoot your Azure SQL database performance using metrics and Azure SQL monitoring insights from eG Enterprise.\" \/>\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\/troubleshooting-azure-sql-database-performance-issues\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Troubleshoot Azure SQL Database Performance | eG Innovations\" \/>\n<meta property=\"og:description\" content=\"Learn how to troubleshoot your Azure SQL database performance using metrics and Azure SQL monitoring insights from eG Enterprise.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.eginnovations.com\/blog\/troubleshooting-azure-sql-database-performance-issues\/\" \/>\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=\"2022-11-30T12:30:38+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-04-14T13:45:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/Azure-SQL-Database-Social-Banner.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Srihari Avar\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/Azure-SQL-Database-Social-Banner.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=\"Srihari Avar\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Troubleshoot Azure SQL Database Performance | eG Innovations","description":"Learn how to troubleshoot your Azure SQL database performance using metrics and Azure SQL monitoring insights from eG Enterprise.","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\/troubleshooting-azure-sql-database-performance-issues\/","og_locale":"en_US","og_type":"article","og_title":"Troubleshoot Azure SQL Database Performance | eG Innovations","og_description":"Learn how to troubleshoot your Azure SQL database performance using metrics and Azure SQL monitoring insights from eG Enterprise.","og_url":"https:\/\/www.eginnovations.com\/blog\/troubleshooting-azure-sql-database-performance-issues\/","og_site_name":"eG Innovations","article_publisher":"https:\/\/www.facebook.com\/eGInnovations","article_published_time":"2022-11-30T12:30:38+00:00","article_modified_time":"2023-04-14T13:45:34+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/Azure-SQL-Database-Social-Banner.jpg","type":"image\/jpeg"}],"author":"Srihari Avar","twitter_card":"summary_large_image","twitter_image":"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/Azure-SQL-Database-Social-Banner.jpg","twitter_creator":"@eginnovations","twitter_site":"@eginnovations","twitter_misc":{"Written by":"Srihari Avar","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.eginnovations.com\/blog\/troubleshooting-azure-sql-database-performance-issues\/#article","isPartOf":{"@id":"https:\/\/www.eginnovations.com\/blog\/troubleshooting-azure-sql-database-performance-issues\/"},"author":{"name":"Srihari Avar","@id":"https:\/\/www.eginnovations.com\/blog\/#\/schema\/person\/7eb97ff09436590c6d8a6dc454502eb2"},"headline":"Troubleshooting Azure SQL Database Performance Issues","datePublished":"2022-11-30T12:30:38+00:00","dateModified":"2023-04-14T13:45:34+00:00","mainEntityOfPage":{"@id":"https:\/\/www.eginnovations.com\/blog\/troubleshooting-azure-sql-database-performance-issues\/"},"wordCount":1025,"publisher":{"@id":"https:\/\/www.eginnovations.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.eginnovations.com\/blog\/troubleshooting-azure-sql-database-performance-issues\/#primaryimage"},"thumbnailUrl":"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/Azure-SQL-Database-Thumbnail.jpg","keywords":["Azure","Azure Monitoring","Azure monitoring tools","Azure Slow","Azure SQL","Azure SQL bottleneck","Azure SQL monitoring","Azure SQL troubleshooting","Azure SQL tuning","Microsoft SQL","Microsoft SQL Server","Microsoft SQL server performance","SQL monitoring","SQL slow","SQL troubleshooting"],"articleSection":["Azure Monitoring","Database Monitoring"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.eginnovations.com\/blog\/troubleshooting-azure-sql-database-performance-issues\/","url":"https:\/\/www.eginnovations.com\/blog\/troubleshooting-azure-sql-database-performance-issues\/","name":"Troubleshoot Azure SQL Database Performance | eG Innovations","isPartOf":{"@id":"https:\/\/www.eginnovations.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.eginnovations.com\/blog\/troubleshooting-azure-sql-database-performance-issues\/#primaryimage"},"image":{"@id":"https:\/\/www.eginnovations.com\/blog\/troubleshooting-azure-sql-database-performance-issues\/#primaryimage"},"thumbnailUrl":"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/Azure-SQL-Database-Thumbnail.jpg","datePublished":"2022-11-30T12:30:38+00:00","dateModified":"2023-04-14T13:45:34+00:00","description":"Learn how to troubleshoot your Azure SQL database performance using metrics and Azure SQL monitoring insights from eG Enterprise.","breadcrumb":{"@id":"https:\/\/www.eginnovations.com\/blog\/troubleshooting-azure-sql-database-performance-issues\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.eginnovations.com\/blog\/troubleshooting-azure-sql-database-performance-issues\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.eginnovations.com\/blog\/troubleshooting-azure-sql-database-performance-issues\/#primaryimage","url":"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/Azure-SQL-Database-Thumbnail.jpg","contentUrl":"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2022\/11\/Azure-SQL-Database-Thumbnail.jpg","width":362,"height":235},{"@type":"BreadcrumbList","@id":"https:\/\/www.eginnovations.com\/blog\/troubleshooting-azure-sql-database-performance-issues\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.eginnovations.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Troubleshooting Azure SQL Database Performance Issues"}]},{"@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\/7eb97ff09436590c6d8a6dc454502eb2","name":"Srihari Avar","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.eginnovations.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/bcbea6588eefdebc6566f8725aa178ca?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/bcbea6588eefdebc6566f8725aa178ca?s=96&d=mm&r=g","caption":"Srihari Avar"},"url":"https:\/\/www.eginnovations.com\/blog\/author\/srihari-avar\/"}]}},"modified_by":"Review eG","_links":{"self":[{"href":"https:\/\/www.eginnovations.com\/blog\/wp-json\/wp\/v2\/posts\/27721","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\/67"}],"replies":[{"embeddable":true,"href":"https:\/\/www.eginnovations.com\/blog\/wp-json\/wp\/v2\/comments?post=27721"}],"version-history":[{"count":0,"href":"https:\/\/www.eginnovations.com\/blog\/wp-json\/wp\/v2\/posts\/27721\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.eginnovations.com\/blog\/wp-json\/wp\/v2\/media\/27980"}],"wp:attachment":[{"href":"https:\/\/www.eginnovations.com\/blog\/wp-json\/wp\/v2\/media?parent=27721"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.eginnovations.com\/blog\/wp-json\/wp\/v2\/categories?post=27721"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.eginnovations.com\/blog\/wp-json\/wp\/v2\/tags?post=27721"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}