MS-SQL Server - A PK Mandatory

A PK Mandatory

Transactional replication requires a primary key constraint on each table required to get replicated/published.

https://learn.microsoft.com/en-us/sql/relational-databases/replication/administration/frequently-asked-questions-for-replication-administrators?view=sql-server-ver16

Monitoring Distribution Database

Additionally,

Char, Varchar DataTypes & Group by Clause

Volume Maintenance Task

https://learn.microsoft.com/en-us/windows/security/threat-protection/security-policy-settings/perform-volume-maintenance-tasks

Some Important Waittypes

CXPACKET
BROKER_EVENTHANDLER
ASYNC_NETWORK_IO
AUDIT_ON_DEMAND_TARGET_LOCK

Best Regards

T. Amit Vaid S.