log shipping bandwith estimation

We have a lot of sql server databases in Simple Recovery Mode. We need to move these databases on a different datacenter. These databases can not be closed (they are serving 24x7 mission critical services). We are thinking to use log shipping to create a remote standby database and then switching the remote copy to be primary.

How we can estimate the amount o transaction log written daily by each of these databases? We need to know this amount to estimate netowork bandwith and size of transaction log backup.

Regards Giovanni

I wrote a stored procedure that do the following:

• read num_of_bytes_written from sys.dm_io_virtual_file_stats
• random insert and delete rows from tables
• read num_of_bytes_written from sys.dm_io_virtual_file_stats
• calculate difference in megabytes between the two values of num_of_bytes_written
• make compressed transaction log backup
• check the difference between log backup size and the num of bytes written

After 1000 executions I'll calculate the ratio between log size and backup size

regards Giova