If you are manually storing operation information, you can use data partitions to store the operation monitoring history.

This section describes storing the operation monitoring history using data partitions. This is a Microsoft SQL Server 2012, Microsoft SQL Server 2008 or Microsoft SQL Server 2005 facility.

Large users

If the number of operation information items that occur in a day exceeds 10 million, we recommend creating and storing data partitions in daily units.

Medium-sized users

If the number of operation information items that occur in a month exceeds 10 million, we recommend creating and storing data partitions in monthly units.

Small users

In the following cases data partitions are not necessary:

• User for whom only a few types of operating logs are kept, and only a few million administered operating log items are acquired per month
• User for whom the number of administered users is low, and only a few million administered operating log items are acquired per month
• Users who do not administer an operating log

Data partitions must be created separately using SQL Server Management Studio. They can only be created after a new relational database is created with Database Manager, or after an upgrade. The following subsections describe how to create and utilize data partitions.

Organization of this section

7.6.1 Procedure for creating data partitions

7.6.2 Procedure for adding data partitions

7.6.3 Procedure for reassigning data partitions

7.6.4 For large users