Linux vsftp virtual, physical account simultaneous verification login

  
 

Enterprise customers install SCOM2012 behind the constantly generated alarms, performance, information data, which is stored in the operation database and data warehouse specified when installing SCOM, but as the amount of data continues to grow, we may encounter Until the original planned SQL database space is insufficient or due to insufficient storage space or the data types that need to be reported within our enterprise, we need to adjust the size of each type of data in the operation database. This article describes the modification by using Microsoft official tool: DWDATARP.EXE. The retention time setting of each type of data in the data warehouse of SCOM2012. [Text] When we install System Center Operations Manager 2012, we need to create at least two main databases, including the operation database and the data warehouse database. The Operational Database (OperationManager) is a SQL Server database that contains all the configuration data for the management group and stores all the monitoring data collected and processed by the management group. The operational database retains short-term data and is retained for 7 days by default. The retention settings for this database can be changed through the database settings in the SCOM console management panel. The Data Warehouse Database (OperationManagerDW) is a SQL Server database that stores monitoring and alert data for historical queries. Data written to the operational database is also written to the data warehouse database so that the report always contains current data. The data warehouse database retains long-term data. Different types of data are stored in different data sets in the data warehouse, each representing a different data type (event, alert, performance, etc.) and aggregation type (original, hourly, daily). Different data depends on the type of aggregation, and the reserved time interval is different. For example, the performance raw data is different from the performance daily aggregate data retention time, which ranges from 10 days to 400 days by default. The size of data retention affects the size of the database and the size of the backup database. It also affects the speed and integrity of post-disaster recovery. At the same time, we need to consider the different types of data required by different enterprises for reporting and storage costs and operating costs. You need to configure the save time of different data in the data warehouse. In addition to using the SQL operation management console, administrators who are not familiar with SQL can use Microsoft's official tool DWDATARP.EXE. (http://blogs.technet.com/b/momteam/archive/2008/05/14/data-warehouse-data-retention-policy-dwdatarp-exe.aspx) The following is the use of this tool to modify the data retention time step:

  • Procedure:
      dwdatarp.exe tool to extract the folder, for example, the root directory C:




        Use the command C:\\dwdatarp.exe -s scom -d OperationsManagerDW > c:\\dwoutput.txt to view the data type and retention time of the current data warehouse and output it to the dwoutput.txt text file in the root directory of the C drive. :

        The first column is the type of dataset, including alerts, client monitoring, configuration, events, performance, status, etc. The second column is the aggregation type, including raw data, daily, hourly Aggregation; the third column is the number of days to save, the default is 10 to 400 days; the fourth column is the current size of a certain type of data as a percentage of the total database size;

          can be based on different needs for a certain data Type setting save time by using the command dwdatarp.exe -s SCOM -d OperationsManagerDW - Ds "Alert data set" -a "Raw data" -m 180 Change the data retention time, where SCOM is the server name of the data warehouse database, OperationsManagerDW is the name of the data warehouse database, and Alert data set is the change retention time. The data type, 180 is the retention time that needs to be set:


            Review the modified data warehouse retention time setting again, where the retention time of the Alert data set is successfully set. For 180 days:


  • Copyright © Windows knowledge All Rights Reserved