如何設定報表資料倉儲資料庫的清理設定How to configure grooming settings for the Reporting data warehouse database

重要

已不再支援此版本的 Operations Manager,建議升級至 Operations Manager 2019This version of Operations Manager has reached the end of support, we recommend you to upgrade to Operations Manager 2019.

報表資料倉儲會依據資料 (警示、事件、AEM 或效能) 和彙總類型 (原始資料、每小時彙總、每日彙總),儲存資料一段指定的時間。The Reporting data warehouse stores data for a specified length of time, depending on the data (Alert, State, Event, Aem, or Performance) and the aggregation type (raw data, hourly aggregations, daily aggregations). 資料庫可設定刪除較舊的資料,藉由管理其大小以維持效能。The database is set up to delete older data in order to maintain performance by managing its size. 這種刪除舊資料的動作稱為「 grooming」。Deleting the older data is called grooming.

下表會反白顯示預設資料類型,以及最初設定資料倉儲資料庫之後的保留期間。The following table highlights the default data types and retention period after initial setup of the data warehouse database.

資料集Dataset 彙總類型Aggregation Type 保留期間 (以天為單位)Retention Period (in days)
警示Alert RawRaw 400400
用戶端監視Client Monitoring RawRaw 3030
用戶端監視Client Monitoring 每日Daily 400400
事件Events RawRaw 100100
效能Performance RawRaw 1010
效能Performance 每小時Hourly 400400
效能Performance 每日Daily 400400
StateState RawRaw 180180
StateState 每小時Hourly 400400
StateState 每日Daily 400400

清理資料倉儲的設定可透過 Microsoft SQL Server Management Studio 來加以變更。Settings for grooming the data warehouse can be changed through Microsoft SQL Server Management Studio.

變更報表資料倉儲中的清理設定To change grooming settings in the Reporting data warehouse

  1. 使用屬於 SQL Server 系統管理員固定伺服器角色成員的帳戶登入電腦。Log on to the computer with an account that is a member of the SQL Server sysadmin fixed server role.

  2. 在 [啟動] 頁面上,輸入 SQL Server Management Studio,程式將會出現。On the Start Page, type SQL Server Management Studio and the program will appear. 按一下程式以開啟 SQL Server Management Studio。Click the program to open SQL Server Management Studio. 您可能想要以滑鼠右鍵按一下程式,並釘選到 [啟動] 頁面。You might want to right-click the program and pin it to the Start Page.

  3. 在 [連線至伺服器] 對話方塊中,從 [伺服器類型] 清單中選取 [Database Engine] ;在 [伺服器名稱] 清單中選取用於執行報表資料倉儲的伺服器和執行個體 (例如 computer\INSTANCE1);在 [驗證] 清單中選取 [Windows 驗證] ;然後按一下 [連接] 。In the Connect to Server dialog box, in the Server Type list, select Database Engine; in the Server Name list, select the server and instance for your Reporting data warehouse (for example, computer\INSTANCE1); in Authentication list, select Windows Authentication; and then click Connect.

  4. 在 [物件總管] 窗格中,展開 [資料庫] ,展開 [OperationsManagerDW] ,然後再展開 [表格] 。In the Object Explorer pane, expand Databases, expand OperationsManagerDW, and then expand Tables.

  5. 在 [dbo.Dataset] 上按一下滑鼠右鍵,然後按一下 [開啟表格] 。Right-click dbo.Dataset, and then click Open Table.

  6. 在 [DatasetDefaultName] 欄位中找出您要變更清理設定的資料集,並在 [DatasetId] 欄位中記錄其 GUID。Locate the dataset for which you want to change the grooming setting in the DatasetDefaultName column and make note of its GUID in the DatasetId column.

  7. 在 [物件總管] 窗格中,在 [dbo.StandardDatasetAggregation] 上按一下滑鼠右鍵,然後按一下 [開啟表格] 。In the Object Explorer pane, right-click dbo.StandardDatasetAggregation and then click Open Table.

  8. 在 [DatasetId] 資料行中,找出您在步驟 5 中記下的資料集 GUID。In the DatasetId column, locate the dataset GUID you noted in step 5. 可能會顯示多個相同 GUID 的項目。Multiple entries of the same GUID might display.

  9. 使用下列值從 [AggregationTypeId] 欄的清單中找出彙總類型:Locate the aggregation type from the list in the AggregationTypeId column by using the following values:

    • 0 = 原始,非彙總資料0 = raw, nonaggregated data

    • 10 = 每半小時10 = subhourly

    • 20 = 每小時20 = hourly

    • 30 = 每日30 = daily

當您找出資料集及其彙總類型後,捲動到 [MaxDataAgeDays] 欄位,然後編輯其中的值以設定清理間隔。After you have located the dataset and its aggregation type, scroll to the MaxDataAgeDays column, and then edit the value there to set the grooming interval.

後續步驟Next steps

若要深入了解儲存在 Operations Manager 操作資料庫中的不同資料類型的預設保留期限,以及要如何修改這些設定,請參閱如何設定 Operations Manager 資料庫的清理設定To learn more about the default retention period for the different data types stored in the Operations Manager operational database and how to modify those settings, please see How to configure grooming settings for the Operations Manager database.