MS-SQL Server - Replication Waittype & HostName

Replication Waittype & HostName

LOGMGR_QUEUE

WRITELOG

 

Please confirm as these may be the core waittypes where replication is configured.

Additionally,

Sysprocesses is the system table to find the hostname for related SPID.

https://learn.microsoft.com/en-us/sql/relational-databases/system-compatibility-views/sys-sysprocesses-transact-sql?view=sql-server-ver16

int, bigint, smallint, and tinyint (Transact-SQL)

https://learn.microsoft.com/en-us/sql/t-sql/data-types/int-bigint-smallint-and-tinyint-transact-sql?view=sql-server-ver16

Just LAG Feature

https://learn.microsoft.com/en-us/sql/t-sql/functions/lag-transact-sql?view=sql-server-ver16

Best Regards

T. Amit Vaid S.