MS-SQL Server - GAM, SGAM, PFS & Hung Process by Blocking

GAM, SGAM, PFS & Hung Process by Blocking

https://techcommunity.microsoft.com/t5/sql-server-support-blog/sql-server-extents-pfs-gam-sgam-and-iam-and-related-corruptions/ba-p/1606011

Hung Process by Blocking

https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/performance/understand-resolve-blocking

Additionally,

Waitypes

FS_GARBAGE_COLLECTOR_SHUTDOWN

Internal Use Only

PREEMPTIVE_UNMARSHALPROPAGATIONTOKEN

FT_IFTS_CHUNK_BUFFER_CLIENT_MANAGER

Best Regards

T. Amit Vaid S.