October 21, 2002 at 1:49 am
Hi All
Are there any paramaeter(logs) thru which we can come to know how much data(bytes) has been replicated b/w 2 server database from publisher -- to subscriber (using psuh replication)
we need to charge a customer for the replication on monthly basis/or per annum may be.
I have no idea how this is possible to collect from sql server ..
Regards
Deepa
October 21, 2002 at 4:08 am
Unfortunately there is nothing that states o many bytes were delivered and no replication profile that can help get this. The only thing yo have available is performance monitor to catch how much data is passed over the NIC. You could possible find an external tool to parse the packets sent to see which are related to the customer but that is more difficult I think than anyone would bother with. Best overall way to do this, is if the customer is the only replicated user, setup a second SQL server as distributor on in the same location as the publisher, it needs to have two NICs, one for th incoming publication and one for the outgoing distribution, then you record the bandwidth usage on the outgoing NIC to get that information. ANother possible way is to build an app that does a psuedo type of replication, this of course will require work but I know of no SL based way to know what bandwidth they use.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply