//

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

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

Богатый опыт работы с Sybase Replication Server, Sybase ASE Server, MS SQL Server

Опубликовано в SQL, Серверы
2 comments on “MS SQL Server — дело тонкое… · Running SQL Server on Machines with More Than 8 CPUs per NUMA Node May Need Trace Flag 8048
  1. I know this post in a bit dated, but here I am trying to steal the SQL pertaining to sys.dm_os_waiting_tasks .

    • 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 не будет опубликован. Обязательные поля помечены *

*