Configuring the database

To ensure that the SQL Server delivers optimum performance when working with BMC Client Management , you need to specifically configure some parameters.

1. Run the following query on the Client Management - database :

   SELECT
   is_parameterization_forced as 'Parameterization Forced',
   is_read_committed_snapshot_on as 'Read Committed Snapshot On' ,
   snapshot_isolation_state as 'Snapshot Isolation State On'  
   FROM sys.databases
   WHERE name LIKE '<BCM_DB_NAME>'
   

   InformationReplace <BCM_DB_NAME> with the Client Management - database name, for example, bcmdb .The preceeding query returns the current configuration of the database for the following parameters:

• 
  
  • Parameterization
  • Read Committed Snapshot
  • Snapshot Isolation State Verify the result for these parameters and ensure that they are all set to 1.

2. (Optional) If the value for one or more parameters is set to 0, execute the following steps to activate them,

1. 
   
   1. Connect to the SQL server instance as a user with ALTER permission on the database.
   2. Ensure that there are no active connections to the database except for the connection executing the Alter database command.

   3. (Optional) Type the following command to set the Parameterization option to Forced :

      Alter database '<BCM_DB_NAME>' set PARAMETERIZATION FORCED

      Information

      Replace <BCM_DB_NAME> with the Client Management - database name, for example, bcmdb .

d. (Optional) Run the following SQL commands to turn on the Read Committed Snapshot and Snapshot Isolation State options: