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:
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;
The repo file is the configuration file of the yum source (software repository) in Fedora. Usually a
According to statcounter statistics, the global operating system market share in March is still Win7
Installing VMware in Linux System Due to the project needs, you need to virtuali
Requirement Description Set SNAT policy using iptables Make hosts on 192.168.100.0/24 network segmen
Solve the problem of mounting lvm under Linux
Linux using soft links to solve the problem of directory transfer
Introduction to the configuration method of VPN server under Linux operating system
Arista Networks is a little different
Solve ntp error no server suitable for synchronization found
Introduction to libraries under Windows and Linux
Memcacheq service installation and principle overview
Visudo precise user empowerment (sudo)
How to solve the problem that CentOS Linux can't mount the CD-ROM drive
Linux system management and maintenance - cpio command
Win10 installation problem solution summary Win10 installation problem
What should I do if the memory usage of svchost.exe is too high under Win7?
Let Nero Burning ROM display the current burning speed in real time
Set tips to share! xp hidden account how to set
Win8 picture password setting tutorial
How is the USB disk generally encrypted?
Win7cnf login does not prompt CF File Watcher how to do?
How to solve the Win10 preview version 9879 installation card in 18% problem
Win10 system windows security center service can not start how to do?