UIM Maintenance duration

Discussion created by asafy on Jan 29, 2017
Latest reply on Mar 1, 2017 by recarter



I have a UIM environment with few hundreds computers.

Running the admin maintenance of the SQL (SQL Server Enterprise 2014) is taking forever.

I see it working at the speed of one table (r/n/h/d) every 7 minutes in average.

I've increased the CPU count and Memory but nothing seems to change, the server is currently working very little (16% cpu, 12GB Memory)

Is there any way I can speed this process? and optimize the SQL/data_engine parameters for best performance.