Topic: Kol-in used processors in SQL
For me MS SQL 2016 works in VM under Hyper-V.
The processor on physical server Xeon E5-2620v4 of 8 kernels of 16 flows.
I selected 10 vCPU under this and fixed storages 20480 from them from 8192 to 16384 under SQL and remaining under the agent of the server 1 8.3 64.
At night it is fulfilled Maintenance Plan which looks as follows:
In jobs Check Database Integrity and Rebuild Index specified maxdop = 4. Measured speed of performance of jobs with step in 2 from 0 to 1.
The difference was within 10 minutes rather 2 hours of performance on value = 4.
Update Statistics with parameter column statistics only.
Actually a problem that on system of monitoring at the moment of evolution of indexes is completely loaded only 1 CPU and thus for some reason 8: https://yadi.sk/i/180qwHOr3ZrVHj
Checked up that SQL uses all "kernels":
SELECT scheduler_id, cpu_id, status, is_online FROM sys.dm_os_schedulers GO
Prompt, why so happens and whether it is possible to correct it somehow?
Thankful in advance for .