How do I improve database performance using Filegroups with Security Manager? (NETIQKB33152)

  • Document ID:7733152
  • Creation Date:02-Feb-2007
  • Modified Date:06-Sep-2007
    • Micro Focus Products:
      Security Manager

Resolution

goal
How do I improve database performance using Filegroups with Security Manager?

goal
How do I move database tables to a new Filegroup?

fact
Security Manager 4.20

fact
Security Manager 4.50

fact
Security Manager 5.X

fix

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.



note
For more information about Filegroups, please see the Microsoft SQL Server documentation.

Additional Information

Formerly known as NETIQKB33152