Improving Upgrade Performance
Updated: May 13, 2016
Applies To: System Center 2012 R2 Operations Manager, System Center 2012 - 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
The use command assumes that the name of the operational database was not changed and the default value of OperationsManager is used.
Click the Query menu, and then click Execute.
Click the File menu, and then click Exit.