Maintaining the Directory Services Database

Updated: November 15, 2006

Applies To: Windows Server 2003, Windows Server 2003 R2, Windows Server 2003 with SP1, Windows Server 2003 with SP2

RMS includes a directory services database that your database server hosts, which contains information about users, identifiers (such as e-mail addresses), security IDs (SIDs), group membership, and alternate identifiers. This information is obtained from LDAP queries made to the Active Directory global catalog by the RMS licensing service and then cached locally in this database to improve the response time of the server when users request use licenses.

Fragmentation can occur in this database because the data stored is inserted and deleted often. You should periodically (daily or weekly) perform a database reorganization on indexes of all the DRMS_DirectoryServices database tables. This will rebuild the indexes so that the data is no longer fragmented. Fragmented data can result in poor performance and even server failure if allowed to continue without administrative intervention.

If you are using SQL Server as your database server, database reorganizations can be done using the Maintenance Wizard, or by running your own custom script by using the SQL Server Agent.

If you find that your transaction log grows to an unacceptable size when you reindex your database, you can minimize this growth by switching from the Full recovery mode to the Bulk-Logged mode before you reindex.

Community Additions

ADD
Show: