監視資料層應用程式Monitor Data-tier Applications

適用於: 是SQL Server 是Azure SQL Database 否Azure SQL 資料倉儲 否平行處理資料倉儲 APPLIES TO: yesSQL Server yesAzure SQL Database noAzure SQL Data Warehouse noParallel Data Warehouse

您可以從 SQL Server Management StudioSQL Server Management Studio (SSMS) 中的 [公用程式總管] 與 [物件總管] 以及系統檢視表和資料表中監視資料層應用程式 (DAC)。A data-tier application (DAC) can be monitored from the Utility Explorer and Object Explorer in SQL Server Management StudioSQL Server Management Studio (SSMS), along with system views and tables. 此外,包含在 DAC 中之資料庫內的所有物件都可以使用標準資料庫與 Database EngineDatabase Engine 監視技術進行監視。In addition, all objects in the database contained in the DAC can be monitored using standard database and Database EngineDatabase Engine monitoring techniques.

開始之前Before You Begin

如果您將 DAC 部署至 Database EngineDatabase Engine 執行個體,下次從執行個體將公用程式收集組傳送到公用程式控制點時,部署的 DAC 相關資訊就會合併至 SQL Server 公用程式。If you deploy a DAC to an instance of the Database EngineDatabase Engine, information about the deployed DAC is incorporated into the SQL Server Utility the next time the utility collection set is sent from the instance to the utility control point. 然後,您可以使用 Management StudioManagement Studio [公用程式總管] ,檢視 DAC 的基本健全狀況資訊。You can then view basic health information about the DAC by using the Management StudioManagement Studio Utility Explorer.

SSMS 的 [物件總管] 會顯示部署至 Database EngineDatabase Engine執行個體之每個 DAC 的基本組態資訊,而不論是否在 SQL Server 公用程式中管理執行個體。The SSMS Object Explorer displays basic configuration information about each DAC deployed to an instance of the Database EngineDatabase Engine, regardless of whether the instance is managed in the SQL Server Utility. 而且,可以使用監視任何資料庫的相同程序,來監視與部署 DAC 相關聯的資料庫。Also, the database associated with a deployed DAC can be monitored using the same procedures for monitoring any database.

使用 SQL Server 公用程式Using the SQL Server Utility

Management StudioManagement Studio [公用程式總管] 中的 [部署的資料層應用程式] 詳細資料頁面會顯示一個儀表板,這個儀表板會報告已部署至 Database EngineDatabase Engine 執行個體的所有 DAC 資源使用率。The Deployed Data-tier Applications detail page in the Management StudioManagement Studio Utility Explorer displays a dashboard that reports the resource utilization of all DACs that have been deployed to instances of the Database EngineDatabase Engine. 詳細資料頁面的上方窗格會列出每個已部署的 DAC 以及視覺指標,顯示其 CPU 的使用量與檔案資源是否超出針對 SQL ServerSQL Server 公用程式所定義的原則之外。The top pane of the details page lists each deployed DAC with visual indicators showing whether their utilization of CPU and file resources are outside the policies defined for the SQL ServerSQL Server Utility. 如果您選取清單檢視中的任何 DAC,在頁面下方窗格的索引標籤中會顯示其他詳細資料。If you select any DAC in the list view, further details are displayed in tabs in the bottom pane of the page. 如需詳細資料頁面上所呈現之資訊的詳細資訊,請參閱部署的資料層應用程式詳細資料 (SQL Server 公用程式)For more information about the information presented on the details page, see Deployed Data-tier Application Details (SQL Server Utility).

使用 [部署的資料層應用程式] 詳細資料頁面快速識別使用不足或其硬體資源負荷過重的 DAC 之後,您可以做出處理所有問題的計畫。After using the Deployed Data-tier Applications detail page to quickly identify any DACs that are either under-utilizing or stressing their hardware resource, you can make plans to address any problems. 未充分使用其目前硬體資源的多個 DAC 可以合併到單一伺服器,釋出部分伺服器做為其他用途使用。Multiple DACs that are not fully utilizing their current hardware resources could be consolidated to a single server, freeing some of the servers for other uses. 如果 DAC 在目前伺服器上的資源負荷過重,可以將 DAC 移到更大的伺服器,或者將額外的資源加入至目前的伺服器。If a DAC is stressing the resources on its current server, the DAC can be moved to a larger server, or additional resources can be added to the current server.

資源使用量的上下限是由 [公用程式管理] 詳細資料頁面中所定義的應用程式監視原則定義的。The minimum and maximum limits for resource usage are defined by application monitoring policies defined in the Utility Administration details page. 資料庫管理員可以量身訂作這些原則,以符合其組織所設立的限制。Database administrators can tailor the policies to match the limits established by their organizations. 例如,某家公司可能會設定 75% 做為 DAC 的 CPU 使用量上限,而另一家公司則可能將上限設定為 80%。For example, one company might set 75% as the maximum CPU utilization for a DAC, while another company might set the maximum at 80%. 如需有關設定應用程式監視原則的詳細資訊,請參閱公用程式管理 (SQL Server 公用程式)For more information about setting application monitoring policies, see Utility Administration (SQL Server Utility).

若要檢視 [部署的資料層應用程式] 詳細資料頁面:To view the Deployed Data-tier Applications detail page:

  1. 選取 [檢視/公用程式總管] 功能表。Select the View/Utility Explorer menu.

  2. 將 [公用程式總管] 連接至公用程式控制點 (UCP)。Connect the Utility Explorer to the utility control point (UCP).

  3. 選取 [檢視/公用程式總管詳細資料] 功能表。Select the View/Utility Explorer Details menu.

  4. 選取 [公用程式總管] 中的 [部署的資料層應用程式] 節點。Select the Deployed Data-tier Applications node in the Utility Explorer.

我們會持續聽取您的意見: 如果您發現本文中有過時或不正確的內容 (例如步驟或程式碼範例),請告訴我們。We are listening: If you find something outdated or incorrect in this article, such as a step or a code example, please tell us. 您可以按一下此頁面底部 [意見反應] 區段中的 [本頁] 按鈕。You can click the This page button in the Feedback section at the bottom of this page. 我們通常會在隔天閱讀有關 SQL 的每一個意見反應。We read every item of feedback about SQL, typically the next day. 謝謝。Thanks.

[部署的資料層應用程式] 詳細資料頁面中的資訊來自公用程式管理資料倉儲中的資料,此資料倉儲預設每 15 分鐘收集資料一次。The information in the Deployed Data-tier Applications detail page comes from the data in the utility management data warehouse, which defaults to collecting the data every 15 minutes. 其間隔可以使用 [公用程式管理] 詳細資料頁面自訂。The interval can also be tailored using the Utility Administration details page.

使用物件總管Using Object Explorer

SSMS 的 [物件總管] 會顯示有關部署至 Database EngineDatabase Engine執行個體之每個 DAC 的基本組態資訊。The SSMS Object Explorer displays basic configuration information about each DAC deployed to an instance of the Database EngineDatabase Engine. 這同時包括已經在 SQL ServerSQL Server 公用程式中註冊的執行個體,以及無法在 [公用程式總管] 中檢視的獨立執行個體。This includes both instances that have been enrolled in the SQL ServerSQL Server Utility, and stand-alone instances that cannot be viewed in the Utility Explorer.

若要檢視部署至 Database EngineDatabase Engine執行個體之 DAC 的詳細資料:To view the details of a DAC deployed to an instance of the Database EngineDatabase Engine:

  1. 選取 [檢視/物件總管] 功能表。Select the View/Object Explorer menu.

  2. 從 [物件總管] 窗格連接至 Database EngineDatabase Engine的執行個體。Connect to the instance of the Database EngineDatabase Enginefrom the Object Explorer pane.

  3. 選取 [檢視/物件總管詳細資料] 功能表。Select the View/Object Explorer Details menu.

  4. 在 [物件總管] 中,選取對應至執行個體的伺服器節點,然後導覽至 [管理\資料層應用程式] 節點。Select the server node in Object Explorer that maps to the instance, and then navigate to the Management\Data-tier Applications node.

  5. 在詳細資料頁面上方窗格中的清單檢視會列出部署至 Database EngineDatabase Engine 執行個體的每個 DAC。The list view in the top pane of the details page lists each DAC deployed to the instance of the Database EngineDatabase Engine. 選取 DAC 以便在頁面底部的詳細資料窗格中顯示資訊。Select a DAC to display the information in the detail pane at the bottom of the page.

[資料層應用程式] 節點的滑鼠右鍵功能表也會用來部署新的 DAC 或刪除現有的 DAC。The right-click menu of the Data-tier Applications node is also used to deploy a new DAC or delete an existing DAC.

使用 DAC 系統檢視表與資料表Using the DAC System Views and Tables

msdb.dbo.sysdac_history_internal 系統資料表會記錄針對 Database EngineDatabase Engine執行個體執行的所有 DAC 管理動作成功或失敗。The msdb.dbo.sysdac_history_internal system table records the success or failure of all DAC management actions performed on an instance of the Database EngineDatabase Engine. 資料表會記錄每個動作發生的時間,以及起始動作的登入。The table records the time each action occurred, and which login initiated the action. 如需詳細資訊,請參閱 sysdac_history_internal (Transact-SQL)For more information, see sysdac_history_internal (Transact-SQL).

DAC 系統檢視表會報告基本目錄資訊。The DAC system views report basic catalog information. 如需詳細資訊,請參閱資料層應用程式檢視表 (Transact-SQL)For more information, see Data-tier Application Views (Transact-SQL).

監視 DAC 資料庫Monitoring DAC Databases

成功部署 DAC 之後,包含在 DAC 中的資料庫會與其他任何資料庫的運作方式相同。After a DAC has been successfully deployed, the database contained in the DAC operates the same as any other database. 使用標準 Database EngineDatabase Engine 技術與工具來監視資料庫的效能、記錄、事件與資源使用情況。Use standard Database EngineDatabase Engine techniques and tools for monitoring the performance, log, events, and resource utilization of the database.

另請參閱See Also

資料層應用程式 Data-tier Applications
部署資料層應用程式Deploy a Data-tier Application