Native Archive database partitioning is only available if the EMC SourceOne database is installed on the Enterprise edition of Microsoft SQL Server. If the Native Archive database is installed on the Standard edition of Microsoft SQL Server, the Properties menu item is not available.
To create additional partitions in the Native Archive database, perform the following: 1. In the EMC SourceOne console, select the Native Archive node, right-click on that node
and select Properties. The Native Archive Global Properties dialog displays. 2. Select the Partitioning tab.
Native Archive database partitioning is only available if the EMC SourceOne database is installed on the Enterprise edition of Microsoft SQL Server. If the Native Archive database is installed on the Standard edition of Microsoft SQL Server, the Properties menu item is not available.
3. Select the Enable partitioning option to enable the use of the rest of the tab, except for the Based on area. The Based on area is only enabled when you have selected automatic partitioning.
4. Select whether to enable the automatic or manual creation of partitions:
◆ Select the Manual option to enable the manual creation of partitions. This is the default.
◆ Select the Automatic option to enable the automatic creation of partitions based on selected criteria.
5. If automatic partitioning was selected, select one of the automatic partitioning criteria in the Based on area. These criteria are described in the following table.
Refer to “Selecting which automatic partitioning method to use” on page 126 for more information on when to use each method for automatically creating partitions. When an administrator sets the system to automatically create partitions, the partitions are typically not created immediately since usually it takes time for the automatic criteria to be met. In addition, the partition will not be created at all unless the minimum size for a partition criteria are met as described in“Partition creation criteria and status messages” on page 124.
Table 21 Automatic partitioning criteria
Partitioning
criteria Description Partition
size (GB) Specifies how large the current partition can be before creating a new partition is attempted. This value is entered as a whole number which represents the size of the partition in gigabytes. The default value is 100, indicating 100 gigabytes.
Refer to “Selecting which automatic partitioning method to use” on page 126 for more information on when to use each method for automatically creating partitions.
Item count
(millions) Specifies how many rows must be in the current partition before creating a new partition is attempted. This value is entered as a whole number where the number represents that many million rows in the partition. The range in values is from 50 -200. The default value is 50, indicating 50 million rows.
Refer to “Selecting which automatic partitioning method to use” on page 126 for more information on when to use each method for automatically creating partitions.
Processing
date Specifies whether creating a new partition should be attempted each month or each year: • Select the Yearly option to attempt to create a new partition whenever a new year begins, assuming the current partition. An attempt to create a new partition will occur when the first content is inserted into the Native Archive after the new year begins according to the time on the SQL Server computer.
• Select the Monthly option to attempt to create a new partition whenever a new month begins. An attempt to create the new partition will occur when the first content is inserted into the Native Archive after the new month begins according to the time on the SQL Server computer.
Refer to “Selecting which automatic partitioning method to use” on page 126 for more information on when to use each method for automatically creating partitions.
6. For either type of partitioning, select the attributes for the partition data files using the fields in the New partition data files attributes area. These data files are the underlying physical data base for the partition. Refer to “Understanding partition data file attributes” on page 127 for background information on partition data file attributes. The partition data file attribute fields are described in the following table.
7. If you are creating partitions manually, click Create Partition. The values on the Partitioning tab are saved and EMC SourceOne immediately attempts to create the partition.
The partition will not be created if it does not meet the minimum criteria described in “Partition creation criteria and status messages” on page 124.
8. Select whether to save your changes.
• Click OK to save your changes to the Partitioning tab. Note that this does not cause a partition to be created, it only saves the changes you have made to fields on this tab.
• Click Cancel to not save your changes to the Partitioning tab. The Native Archive Global Properties dialog closes.
Table 22 New partition data file attribute fields
attribute field Description
Location Specifies the location of the data files on the SQL Server computer for the new partition. By default, EMC SourceOne assumes that the location for the partition should be the same directory as the directory used by the primary data file which has a file extension of .mdf.
When you specify a location for a partition, manually verify that it is correct since EMC SourceOne cannot validate that location. If the location is not valid, the partition will not be created.
After a new location is specified and you click either the Create Partition or OK button on the Partitioning tab, a warning dialog is displayed indicating that you must be specifying a valid data location path.
Count Specifies the number of data files to be created for the new partition. Valid values are the whole numbers 1 to 8.
The default number of data files is 1. Typically, this value is correct for most installations.
Size (GB) Specifies the size of the underlying physical data files in gigabytes (GB) created for the new partition. This value is specified as a whole number from 1 to 50. Growth (GB) Specifies how much each of the partition data files can increase in size from their initial size in gigabytes (GB). This value is specified as a whole number from 1 to 10.
For example, if the Size field value is set to 25 and the Growth field value is set to 5, that means that when each data file needs to grow it can grow in increments of 5 GB; the first time each data file will grow to 30 GB, the second time each data file will grow to 35 GB and so on.
9. After attempting to create a partition, either manually or automatically, validate that it was created by doing either or both of the following:
• Review the status line at the bottom of the Native Archive Global Properties dialog to see if the partition was recently successfully created. This status line would appear as follows:
Last attempt to create a partition succeeded on date-and-time
• Verify that a new partition was created by seeing if it exists in the directory specified in the Location field on the Partitioning tab. Within this directory, the new partition will have a name formed as follows:
DatabaseName$PartitionNumber_FileNumber.ndf
For example, a file named ES1Archive$1_2.ndf would have this form.
If the partition was not created, verify that the existing partition meets the minimum criteria for a new partition to be created and review the appropriate event logs as described in “Partition creation criteria and status messages” on page 124.