Export (0) Print
Expand All

Improving Upgrade Performance

Updated: November 1, 2013

Applies To: System Center 2012 - Operations Manager, System Center 2012 R2 Operations Manager, System Center 2012 SP1 - Operations Manager

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
    DBCC FREEPROCCACHE
    
    noteNote
    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.

-----
For additional resources, see Information and Support for System Center 2012.

Tip: Use this query to find online documentation in the TechNet Library for System Center 2012. For instructions and examples, see Search the System Center 2012 Documentation Library.
-----
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft