The following query will pull all information about distribution agents
that are actively distributing transactions (in progress) and will
provide useful information such as the delivery rate (txs/sec).
SELECT da.name, da.publisher_db, da.subscription_type,
dh.runstatus, dh.delivery_rate, dh.start_time, dh.duration
FROM dbo.MSdistribution_history dh WITH (NOLOCK)
INNER JOIN dbo.msdistribution_agents da WITH (NOLOCK)
ON dh.agent_id = da.id
WHERE dh.runstatus = 3
AND dh.start_time BETWEEN DATEADD(dd,-30,GETDATE()) AND GETDATE()
ORDER BY dh.start_time DESC
More On :- http://www.mssqltips.com/sqlservertip/2853/troubleshooting-sql-server-replication/
SELECT da.name, da.publisher_db, da.subscription_type,
dh.runstatus, dh.delivery_rate, dh.start_time, dh.duration
FROM dbo.MSdistribution_history dh WITH (NOLOCK)
INNER JOIN dbo.msdistribution_agents da WITH (NOLOCK)
ON dh.agent_id = da.id
WHERE dh.runstatus = 3
AND dh.start_time BETWEEN DATEADD(dd,-30,GETDATE()) AND GETDATE()
ORDER BY dh.start_time DESC
More On :- http://www.mssqltips.com/sqlservertip/2853/troubleshooting-sql-server-replication/