1

Topic: Kol-in used processors in SQL

Good afternoon.
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:
https://yadi.sk/i/hzNLaFUL3ZrV2Z
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

Result https://yadi.sk/i/WTOFHgTH3ZrVRK
Prompt, why so happens and whether it is possible to correct it somehow?
Thankful in advance for .

2

Re: Kol-in used processors in SQL

Forgot to specify, edition Enterprise

3

Re: Kol-in used processors in SQL

And all understood)

4

Re: Kol-in used processors in SQL

h1g04, Well be pricked give, what understood :-)

5

Re: Kol-in used processors in SQL

uaggster;
Likely because in the standard it always one-continuous operation, i.e. .

6

Re: Kol-in used processors in SQL

aleksrov wrote:

uaggster;
Likely because in the standard it always one-continuous operation, i.e. .

I will tell even more, MS basically does not recommend to do  in a multi-threaded mode

7

Re: Kol-in used processors in SQL

TaPaK;
If fairly for the first time I hear, and than it is justified?
In 2016 Sp1 and 2017 by the way and in the standard can in some flows.

8

Re: Kol-in used processors in SQL

aleksrov wrote:

TaPaK;
If fairly for the first time I hear, and than it is justified?
In 2016 Sp1 and 2017 by the way and in the standard can in some flows.

If it is short, at  flows gives a fragmentation. Basically there % not such already and critical, but to whom as smile

9

Re: Kol-in used processors in SQL

TaPaK;
I and thought smile I know that it can help in cluster, means rowgroup elimination, for normal the such did not read, probably pluses outweigh minuses, knowingly in the standard of it was not.

10

Re: Kol-in used processors in SQL

Not cluster, and  meant.