(SM) Support Tip: Enable replicated database.

Generating the reports from the server will consume additional system resources (memory and CPU). Service Manager provides the database replication to preserve Production Database performance.

Before you enable Replicated Database for Service Manager Reports, prepare a database with the same database type and version as the Production Database. For example, if your Service Manager uses an SQL database, the replicated database should be an SQL database of the same version. Perform database synchronization periodically by using the standard database synchronization mechanism.

To enable Replicated Database, follow these steps:

  1. Open the sm.ini file. By default, the file is located on the Service Manager server in the C:\Program Files (x86)\HP\HP Service Manager 9.40\Server\RUN folder.
  2. Add the Replicated Database parameter and value to the file. For example:

[your database type_replicate]

sqldb:sm940db

sqllogin:username/password

dashboardonreplicatedb

Note: The three parameter lines of Replicated Database should be in one block in the sm.ini file.

3. Save the sm.ini file.

The reports can now be run in the replicated database instead of the production database.

NOTE: More information on how to setup this reporting can be found in SM online help.