VMware VCENTER CONFIGURATION MANAGER FOUNDATION CHECKER 3.0 Guia de Instalação descarregar pdf (Página 218)

Appendix C How to Estimate Database Usage

System Monitor - Performance Monitoring

Services

System Monitor - Performance Monitoring Services collects performance data and

accumulates them in the database. Depending on operation forms, the database might

exceed the maximum capacity of SQL Server. For example, the maximum capacity of

SQL Server 2008 R2 Express is 10 GB.

There are two ways to avoid the above case:

1. Upgrade SQL Server 2008 R2 Express to SQL Server 2008.

2. Control the amount of performance data which are stored in the database from the

System Monitor - Performance Monitoring Services setting.

System Monitor - Performance Monitoring Services classifies performance data into

database tables according to periods of the performance data.

Under the following conditions, an estimate can be made as the table below.

• 1 machine to be monitored

• 1 items of performance information

• Data collection period is 1 minute

• Data storage period is the default value

1 minutes collection data : 3 (days) * 60 KB = 180 KB

5 minutes collection data : 7 (days) * 30 KB = 210 KB

15 minutes collection data : 30 (days) * 7 KB = 210 KB

1 hour collection data : 3* 30 (days) *2 KB= 180 KB

1 day collection data : 5 * 365 (days) * 0.1 KB = 182.5 KB

The size of total amount = (180 + 210 + 210 + 180 + 182.5) KB

= 962.5 KB ≒ 1 MB

* Performance data that exceeds the data retention period will be deleted regularly.

Necessary database capacity for the performance data can be configured by adjusting

the number of monitoring performance information items, data storage period, and data

collection period.

1 2 ... 213 214 215 216 217 218 219 220 221 222 223 ... 228 229

Sem comentários

VMware VCENTER CONFIGURATION MANAGER FOUNDATION CHECKER 3.0 Guia de Instalação Página 218