How do I improve database performance using Filegroups with Security Manager?
How do I move database tables to a new Filegroup?
Security Manager 4.20
Security Manager 4.50
Security Manager 5.X
The OnePoint database contains two sets of tables to store event information: 'EventA and EventParamA' and 'EventB and EventParamB'. To improve performance, you can create a filegroup on another disk and move the 'EventA and EventParamA' tables to the new filegroup. For assistance with this task, please refer to the following Technical Reference document:
This Technical Reference provides guidance on using NetIQ scripts to create a new filegroup for the 'EventA and EventParamA' tables.
For more information about Filegroups, please see the Microsoft SQL Server documentation.