Create filegroups for Data Validator staging/landing tables and indexes - HxGN SDx - Update 32 - Installation & Upgrade

Installation and Setup for HxGN SDx Application Server

Language
English (United States)
Product
HxGN SDx
Search by Category
Installation & Upgrade
SmartPlant Foundation / SDx Version
10

If you are using Data Validator for loading data into your system, we recommend having dedicated filegroups for Data Validator staging/landing tables and indexes, to avoid disk contention and fragmentation.

You can create a new filegroup using the sample script below or interactively using the SQL Server Management Studio (SSMS). For more information on filegroups, refer to the Microsoft SQL Server documentation. For example, see https://docs.microsoft.com/en-us/sql/relational-databases/databases/database-files-and-filegroups?view=sql-server-ver15.

Sample script:

USE [master]

GO

GO

ALTER DATABASE <databasename> ADD FILEGROUP [<filegroupname>]

GO

GO

ALTER DATABASE <databasename> ADD FILE ( NAME = N'<filegroupname>', FILENAME = N' [drive]:\<filegroupname>.ndf', SIZE = 1024000KB, FILEGROWTH = 102400KB) TO FILEGROUP [<filegroupname>]

GO

When you are creating a new site in the Sever Manager using an existing user and database, or updating an existing site, you can select the filegroup for Data Validator to use during job processing. If you have not created a dedicated filegroup for Data Validator tables, the default filegroup will be used for storing the Data Validator tables and indexes.