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.