Columbus is taking time to save the configuration settings

Columbus is taking time to save the configuration settings

 


Symptoms: 

The domain in the OS Deployment > Smart Deploy >Configure>change hardware settings, or change jobs a bit, normally the save takes about 50 seconds, so if we need to tweak 20 computers, it takes a long time.


Solution:

We have analyzed the performance issue when saving the Smart OS-Deploy configuration. In our test environment, it took about 90 seconds. Please create an index in the database from the below command. After the indexing change, it took only 6 seconds.

CREATE INDEX [COOSDCONFIG_IDX1] ON [dbo].[COOSDCONFIG] ([OSDTEMPLATEID], [OSDDEVICEID], [OSDCONFIGGROUP])

Important :

We will add that database index to the official product release (will be part of Columbus 7.6.3).


Was this article helpful? Yes No
No ratings
Version history
Revision #:
1 of 1
Last update:
‎Dec 10, 2019 03:36 AM
Updated by:
 
Contributors