How can I get a (count) of how many transactions the log reader is wating on?

I need to know if replication is running behind. I have already queried
with distribution db for this subscriber , but it's telling me there are
no transactions waiting.
the agent history on the log reader shows it moving across data to the
distributor normally, but when i try to shrink the translog its telling
me that it can't because there are transactions marked for rpelication
that have not been pushed over yet.
here's what I ran on the distrbutor to get the trasnactions waiting
Select * from dbo.MSpublisher_databases where publisher_db = 'cpk01'
(to get publisher id)
then
Select count(1) from dbo.MSrepl_transactions where
publisher_database_id = 13
(to get transaction count)
tia
-comb
Comb,
querying this view (distribution database) is what you need:
MSdistribution_status.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||In article <Ochx0lzBGHA.140@.TK2MSFTNGP12.phx.gbl>,
Paul.Ibison@.Pygmalion.Com says...
> Comb,
> querying this view (distribution database) is what you need:
> MSdistribution_status.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
Thanks Paul.
-comb