Improving Upgrade Performance

Applies To: Operations Manager 2007 R2, Operations Manager 2007 SP1

The upgrade of a root management server (RMS) or management server that hosts more than 800 agents might take more than one hour. You can significantly reduce the amount of time required to perform an upgrade by running several SQL commands. Use the following procedure for each RMS or management server that hosts 800 or more agents. It can also be used if the upgrade of a particular RMS or management server is taking over an hour. You can implement this procedure either before you start the upgrade or while the upgrade is running.

To improve upgrade performance

  1. On the computer that hosts the Operations Manager database, open SQL Server Management Studio.

  2. In the Connect to Server dialog box, in the Server Type list, select Database Engine.

  3. In the Server Name list, select the server and instance for your Operations Manager database (for example, computer\INSTANCE1).

  4. In the Authentication list, select Windows Authentication, and then click Connect.

  5. In the Object Explorer pane, right-click the computer\instance name at the top of the explorer tree, and then click New Query.

  6. In the New Query results pane, type the following three SQL commands:

    use OperationsManager
    exec sp_updatestats


    The use command assumes that the name of the OperationsManager database was not changed and the default value of OperationsManager is used.

  7. Click the Query menu, and then click Execute.

  8. Click the File menu, and then click Exit.