Rozetka UA

Troubleshooting the CXPACKET wait type in SQL Server — SQL Shack — articles about database auditing, server performance, data recovery, and more

The SQL Server CXPACKET wait type is one of the most misinterpreted wait stats. The CXPACKET term came from Class Exchange Packet, and in its essence, this can be described as data rows exchanged among two parallel threads that are the part of a single process. One thread is the “producer thread” and another thread …

Источник: Troubleshooting the CXPACKET wait type in SQL Server — SQL Shack — articles about database auditing, server performance, data recovery, and more

Интереснейшая статья. Параллелизм- основа повышения производительности сервера. Бездумное его использование может резко снизить производительность. 

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

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

Pratik UaPratik UaPratik Ua