MS-SQL Server - Hang, Threads, Fix 2705 & WaitTypes

Hang, Threads, Fix 2705 & WaitTypes

OS Hang or Out of Memory
https://techcommunity.microsoft.com/t5/sql-server-support-blog/os-hang-or-out-of-memory-due-to-sql-ser-no-wait-it-s-sql/ba-p/334014

Thread and task architecture guide
https://learn.microsoft.com/en-us/sql/relational-databases/thread-and-task-architecture-guide?view=sql-server-ver16

Max Worker Thread
https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/configure-the-max-worker-threads-server-configuration-option?view=sql-server-ver16

CPU Hyper-Thread
https://support.microsoft.com/en-us/topic/kb322385-sql-server-support-in-a-hyper-threaded-environment-a2a23c22-2400-a708-b9e3-754af6e2cd28

Fix 2705

https://support.microsoft.com/en-us/topic/kb3188160-fix-can-t-add-new-explicit-hierarchies-after-deleting-existing-explicit-hierarchies-from-an-entity-in-sql-server-2016-master-data-services-6b929380-ed50-0204-35f7-a4b6c64aaa8c

Wait Types
https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-os-wait-stats-transact-sql?view=sql-server-ver16

Additionally,

Ampersand problem

https://social.msdn.microsoft.com/Forums/en-US/93c288fb-e78d-4d43-9dea-70bf1736dbb8/ampersand-problem-in-sql?forum=aspsqlserver

Imp. Errors #

Other Topics

Database Backup, Analysis Services, integration Services

MaxDOP

Error 598, 438, 891

Any query will be considered.

T. Amit Vaid S.