SQL Server 2017 leverages up to 4 log writer workers, on hidden schedulers, to assist in transaction log processing activities. You may find the number of log write workers has been increased to 8 when running newer releases of SQL Server to accommodate larger systems. (Caution: Pre-release software may change before final release.) During SQL […]
Read MoreThese are distinct errors but I have found that many people blend them together. It really takes an entire chapter to explain these conditions so I am going try to do it in a page or two? Unresolved Deadlock An unresolved deadlock is generally a SQL Server product issue. When an unresolved deadlock is detected […]
Read More