0
(0)

Below query can be used to find Sybase replication queue size pending in stable queue . query need to be run on RSSD database of replication server.

select 'Server.Database'=substring(dsname,1,30)+'.'+substring(dbname,1,20)
,'Dbid'=q_number,
case
when q_type=0 then 'Outbound —>'
when q_type=1 then 'Inbound —>'
end

,'Data (MBs)'=count() from rs_segments,rs_databases where dbid=q_number group by dsname,dbname,q_number,q_type having count() > 1
go

Sample output:

How useful was this post?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate this post.