Micro Focus Expert
Micro Focus Expert
158 views

(OO) Support Tip: Can MS SQL Server Database Filegroups be used for the OO DB

Operations Orchestration does not reference storage in any way. The product uses simplistic database creation scripts. Database optimization is ok from Support perspective, as long as your dba take full responsibility for it.

The following suggestions, if taken into consideration, should be done before you start using OO – when the database is created without any table present:
• You may use several data and log files
• You may place data files on one file-group, and log files on another file-group
• It is not recommended to place specific tables and objects on non-default file-group. When applying future OO upgrades, new tables or modified tables do not stick to the currently used file-group. OO uses a simplistic “CREATE TABLE FOO (COL_BAR NVARCHAR(50), …)” without any reference to file-groups. Any new table or object will simply be “relocated” to the default file-group.

The information presented here is not in the OO database manual because there are multiple possible  configurations and only the configurations that have been tested are listed.


For performance place the tempdb on a fast filesystem and also the transaction log.

 

 

Labels (2)
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.