監視並改善效能Monitor and improve performance

Azure SQL Database 可找出資料庫中的潛在問題,並透過提供智慧型微調動作和建議來建議可以改善工作負載效能的動作。Azure SQL Database identifies potential problems in your database and recommends actions that can improve performance of your workload by providing intelligent tuning actions and recommendations.

若要檢閱您的資料庫效能,請使用 [概觀] 頁面上的 [效能] 圖格,或往下瀏覽到 [支援 + 疑難排解] 區段:To review your database performance, use the Performance tile on the Overview page, or navigate down to "Support + troubleshooting" section:

檢視效能

在 [支援 + 疑難排解] 區段中,您可以使用下列頁面:In the "Support + troubleshooting" section, you can use the following pages:

  1. 效能概觀可以監視資料庫的效能。Performance overview to monitor performance of your database.
  2. 效能建議可以找到能改善工作負載效能的效能建議。Performance recommendations to find performance recommendations that can improve performance of your workload.
  3. 查詢效能深入解析可以找到排名最前面的資源取用查詢。Query Performance Insight to find top resource consuming queries.
  4. 自動調整可以讓 Azure SQL Database 自動將資料庫最佳化。Automatic tuning to let Azure SQL Database automatically optimize your database.

效能概觀Performance Overview

此檢視會提供您的資料庫效能的摘要,並可協助您進行效能調整和疑難排解。This view provides a summary of your database performance, and helps you with performance tuning and troubleshooting.

效能

  • [建議] 圖格會提供適用於資料庫的微調建議分解 (如果有多個建議,則會顯示前三個)。The Recommendations tile provides a breakdown of tuning recommendations for your database (top three recommendations are shown if there are more). 按一下此圖格,即會帶您前往 [效能建議] 。Clicking this tile takes you to Performance recommendations.
  • [微調活動] 圖格會提供資料庫進行中和已完成微調動作的摘要,讓您快速檢視調整活動的歷程記錄。The Tuning activity tile provides a summary of the ongoing and completed tuning actions for your database, giving you a quick view into the history of tuning activity. 按一下此圖格會帶您前往您的資料庫的完整微調記錄檢視。Clicking this tile takes you to the full tuning history view for your database.
  • [自動調整] 圖格會顯示資料庫的自動調整設定 (自動套用至資料庫的微調選項)。The Auto-tuning tile shows the auto-tuning configuration for your database (tuning options that are automatically applied to your database). 按一下此圖格會開啟 [自動化組態] 對話方塊。Clicking this tile opens the automation configuration dialog.
  • [資料庫查詢] 圖格會顯示資料庫的查詢效能摘要 (整體 DTU 使用量和排名最前面的資源取用查詢)。The Database queries tile shows the summary of the query performance for your database (overall DTU usage and top resource consuming queries). 按一下此圖格,即會帶您前往 [查詢效能深入解析] 。Clicking this tile takes you to Query Performance Insight.

效能建議Performance recommendations

此頁面提供可改善資料庫效能的智慧型微調建議This page provides intelligent tuning recommendations that can improve your database's performance. 此頁面上顯示的建議類型如下:The following types of recommendations are shown on this page:

  • 要建立或卸除哪些索引的建議。Recommendations on which indexes to create or drop.
  • 在資料庫中發現結構描述問題時的建議。Recommendations when schema issues are identified in the database.
  • 當查詢可以受益於參數化查詢時的建議。Recommendations when queries can benefit from parameterized queries.

效能

您也可以找到過去所套用微調動作的完整歷程記錄。You can also find complete history of tuning actions that were applied in the past.

尋找和套用效能建議文章中,了解如何找到和套用效能建議。Learn how to find an apply performance recommendations in Find and apply performance recommendations article.

自動微調Automatic tuning

Azure SQL 資料庫能透過套用效能建議來自動調整資料庫效能。Azure SQL databases can automatically tune database performance by applying performance recommendations. 若要深入了解,請參閱自動調整文章To learn more, read Automatic tuning article. 若要啟用它,請參閱如何啟用自動調整To enable it, read how to enable automatic tuning.

查詢效能深入解析Query Performance Insight

查詢效能深入解析 提供了下列各項,讓您得以花費較少的時間來針對資料庫效能進行疑難排解:Query Performance Insight allows you to spend less time troubleshooting database performance by providing:

  • 更深入的資料庫資源 (DTU) 取用分析。Deeper insight into your databases resource (DTU) consumption.

  • 排名最前面的 CPU 取用查詢,進行微調有可能會改善效能。The top CPU consuming queries, which can potentially be tuned for improved performance.

  • 向下鑽研查詢詳細資料的功能。The ability to drill down into the details of a query.

    效能儀表板

如需此頁面的詳細資訊,可在 如何使用查詢效能深入解析 一文中找到。Find more information about this page in the article How to use Query Performance Insight.

其他資源Additional resources