How to find the amount of Data replicated from Publisher to Distributor

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SS2K5 Replication » How to find the amount of Data replicated...

How to find the amount of Data replicated from Publisher to Distributor

Rate Topic

Display Mode

Topic Options

Author

Message

PAT-29666

Posted Monday, November 17, 2008 6:17 PM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, December 09, 2008 5:35 PM
Points: 4, Visits: 8

I am trying to find the amount of data replicated from publisher to Distributor in terms of Size(MBs/GBs) instead of Transactions/sec or Commands/sec; I want to know how can we track the data interms of size like Ex:

40GB of data is replicated in last 5Hrs for example; but how would you measure that.

Pat

Post #604058

Kendal Van Dyke

Posted Thursday, November 20, 2008 9:45 AM

Old Hand

Group: General Forum Members
Last Login: 2 days ago @ 10:23 AM
Points: 361, Visits: 781

I am not aware of a built-in way to do this. If you're looking for something short-term maybe try a third party tool like Wireshark. Longer term solutions probably require some kind of dedicated hardware which can do packet analysis and reporting.

Kendal Van Dyke
http://kendalvandyke.blogspot.com/

Post #605940

« Prev Topic | Next Topic »

Permissions