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
On the computer that hosts the operational database, open SQL Server Management Studio.
In the Connect to Server dialog box, in the Server Type list, select Database Engine.
In the Server Name list, select the server and instance for your Operations Manager database (for example, computer\INSTANCE1).
In the Authentication list, select Windows Authentication, and then click Connect.
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.
In the New Query results pane, type the following three SQL commands:
use OperationsManager exec sp_updatestats DBCC FREEPROCCACHE
usecommand assumes that the name of the operational database was not changed and the default value of
Click the Query menu, and then click Execute.
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.