The following applies to upgrades starting on
schema versions prior to 7.4.0.3.
To accommodate the uptime creation of the new filtered indexes on the IN_INSTANCE_PROP table, additional storage will need to be allocated to the respective database filegroup. The new filtered indexes will be created in addition to the existing indexes to ensure proper index coverage. Once all the new indexes have been created, the existing non-filtered indexes will be automatically dropped.
You can use SQL Server Management Studio (SSMS) to get the current size of the IN_INSTANCE_PROP indexes (Index space) by completing the following steps.
Within SSMS, follow these steps to find the minimum amount of storage required for the upgrade.
- Within the Object Explorer window, navigate to the IN_INSTANCE_PROP table.
- Right click on the IN_INSTANCE_PROP table and select Properties.
- Select the Storage page.
- Under the General section, you will find the current size in MB.
- Index space will reflect total size of all the non-clustered indexes on the IN_INSTANCE_PROP table.
- For additional storage considerations, the Index space collected above represents the current size of the indexes. Consideration should also be given for storage to accommodate the expected volume of new documents or custom properties created during the period of time when the new indexes are being created and before the existing indexes are dropped.
- In a default implementation, all the non-clustered indexes are located in the SECONDARY filegroup.