MS-SQL Server - Most Hangs by RAM, Backup, Buffer Pool Extn. & Reason for Waittypes

Most Hangs by RAM

Resolve Out Of Memory issues

https://learn.microsoft.com/en-us/sql/relational-databases/in-memory-oltp/resolve-out-of-memory-issues?view=sql-server-ver16

Backup

https://learn.microsoft.com/en-us/sql/relational-databases/backup-restore/quickstart-backup-restore-database?view=sql-server-ver16

Buffer Pool Extension

https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/buffer-pool-extension?view=sql-server-ver16

Well, Reason for having Waittype analysis is another point of view for analysing performance. A thread (application's individual activity) is till the time being monitored unless it gets completed, where each waiting category is responsible to give duration of the time info it has taken. Please ensure as It's in milliseconds.

Additionally,

Warning message that contains HkHostBackupGetCheckpointFileInfoV2 and 1000016 is logged in the SQL Server error log

Related Article...

https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/backup-restore/error-backing-up-memory-database

Best Regards

T. Amit Vaid S.