DiggerSite

How to handle excessive SOS_SCHEDULER_YIELD wait type values in SQL Server — SQL Shack — articles about database auditing, server performance, data recovery, and more

The SQL Server SOS_SCHEDULER_YIELD is a fairly common wait type and it could indicate one of two things: SQL Server CPU scheduler is utilized properly and is working efficiently There is a pressure on CPU The first thing that has to be properly understood is that the SOS_SCHEDULER_YIELD wait type, even so named, is not …

Источник: How to handle excessive SOS_SCHEDULER_YIELD wait type values in SQL Server — SQL Shack — articles about database auditing, server performance, data recovery, and more

 

Интереснейшая статья. Такое ожидание действительно наблюдается, его наличие трактуется неоднозначно

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

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