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

DiggerSite

Rozetka UA Rozetka UA

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

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

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

  1. 26.04.2016 at 13:04

    I know this post in a bit dated, but here I am trying to steal the SQL pertaining to sys.dm_os_waiting_tasks .

    • 02.05.2016 at 23:27

      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.

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

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

Aliexpress INTAliexpress INTAliexpress INTAliexpress INTAliexpress INTAliexpress INTAliexpress INTAliexpress INTAliexpress INTAliexpress INTAliexpress INT