Installation guide

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.