January 9, 2008 at 3:09 am
Hi,
Can any one help me out on how to find out the Pending transactions for Subscriber in a Replication environment.
The problem is my replication is taking huge time to drain the transactions. I need to check how many and what transactions are there in pending tray.
Do SQL Server 2005 maintains any table where we can get the pending transactions to be applied in subscriber.
October 17, 2011 at 10:36 am
On the distributor run the following
SELECT *
FROM MSPUBLISHER_DATABASES
WHERE PUBLISHER_DB = 'Somedatabase'
output will look like:
Publisher Publisher_db ID Publisher_engine_edition
2 some database 3 31
Uset the Id from the output
and add it to the end of the following.
EXEC SYS.SP_BROWSEREPLCMDS @PUBLISHER_DATABASE_ID =3
That will give a listing of the pending transactions for that database.
if you have no blocking going on
maybe you would like to raise the Subscription streams
by entering the following onto the end of the comands for the
Distribution job for the database in question:
-subscriptionstreams 2 or 4
Be careful and monitor the blocking, sometimes if there are alot of pending replication comands for the same table locking and blocking can occur, in which case you will need to drop the streams.
😎
--Ron
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply