I am new to replication and we have database of size around 2TB and its has been set up for replication .there are 4 subscriber to it. Tables(articles) of database has been divided into 14 publishers. Issue sometime we face high latency on server with lakhs of undistributed command
so what should i check. I mean i want to check from which tables(articles) highest number of commands pending from publisher to distributor and from distributor to subscriber .where to check i mean which system tables or stored procedures to check.
As i found replication monitor to be insufficient.
I know its tea spoon feeding but as i am new to sql server replication