Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Improving Upgrade Performance


The upgrade of a management server that hosts more than 800 agents might take more than one hour. You can significantly reduce the required time to perform an upgrade by running several SQL Server commands. Use the following procedure for each management server that hosts 800 or more agents. It can also be used if the upgrade of a particular 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 operational 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 and instance name at the top of the Object 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 operational 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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
© 2015 Microsoft