MS SQL Server – дело тонкое… · Running SQL Server on Machines with More Than 8 CPUs per NUMA Node May Need Trace Flag 8048

Блог для SQL Server DBA

Источник: MS SQL Server – дело тонкое… · Running SQL Server on Machines with More Than 8 CPUs per NUMA Node May Need Trace Flag 8048

Ноды, спинлоки- масса интересного. Флаги трассировки- читать, пробовать. 

MS SQL Server – дело тонкое… · Running SQL Server on Machines with More Than 8 CPUs per NUMA Node May Need Trace Flag 8048: 2 комментария

    1. Дмитрий Горчилин / Dmitry Gorchilin Автор записи

      Personally, I was amazed that the nodes do not affect each other. Looking at the expected lifetime of the individual stranitsy- buffers. One buffer chokes data, the other is not actually being used.
      There is a hypothesis that can be disabling node architecture to get the win due to more efficient use of the buffer. But this increases the interprocessor communication.
      It will be necessary to conduct an experiment, at the end I will let you know.

Добавить комментарий

Ваш адрес email не будет опубликован. Обязательные поля помечены *