EventFlow icon indicating copy to clipboard operation
EventFlow copied to clipboard

Default value for Cost Threshold For Parallelism may give deadlocks

Open rasmus opened this issue 5 years ago • 5 comments

Deadlocks for MSSQL read models have been observed in production systems and a fix seems to be increasing the "Cost Threshold For Parallelism" in SQL Server.

Consider if EventFlow should log a warning upon initialization if the default value is set.

https://www.brentozar.com/archive/2017/03/why-cost-threshold-for-parallelism-shouldnt-be-set-to-5/

rasmus avatar Dec 07 '20 09:12 rasmus

This will properly need some sections in the documentation as well.

rasmus avatar Mar 04 '22 08:03 rasmus

Hello there!

We hope you are doing well. We noticed that this issue has not seen any activity in the past 90 days. We consider this issue to be stale and will be closing it within the next seven days.

If you still require assistance with this issue, please feel free to reopen it or create a new issue.

Thank you for your understanding and cooperation.

Best regards, EventFlow

github-actions[bot] avatar Apr 08 '23 13:04 github-actions[bot]

Hello there!

We hope you are doing well. We noticed that this issue has not seen any activity in the past 90 days. We consider this issue to be stale and will be closing it within the next seven days.

If you still require assistance with this issue, please feel free to reopen it or create a new issue.

Thank you for your understanding and cooperation.

Best regards, EventFlow

github-actions[bot] avatar Jul 08 '23 09:07 github-actions[bot]