Microsoft SQL Server Database Configuration and Tuning

This chapter describes how to manage the data in the database and create individual data files for large tables.

Data Files Configuration

TIBCO MDM manages the master data of the enterprises across different tables in the database. To manage the data in the database, create individual data files for all the large tables and their indexes.

Create all the indexes including unique and primary keys for each large table in a separate data file.

Create separate data files for the following tables and their associated indexes.

• Master Catalog Table (MCT)
• MV_SHARED Tables for different data types
• MV Non Shared Tables (MVT)
• Relationship Attribute Tables (RCT)
• GOLDENCOPY
• PRINCIPALKEY
• PROCESSLOG
• PRODUCTKEY
• PRODUCTLOG
• RELATIONSHIP

Out-of-the-box scripts are used for the following actions:

• Create filegroups
• Add data files in filegroups
• Move tables or indexes
• Delete data files