January 14, 2009 at 10:57 am
Hi,
How to know 'how much MB of data is getting added to our production database per an hour or 1/2 hour' .We need this inorder to set the logshipping to estimate how much bandwidth we need to send logs to other location
January 14, 2009 at 10:58 am
Take Transaction log BACKUPS and the file size of those is what you should care about.
* Noel
January 14, 2009 at 11:18 am
EXEC sp_spaceused.
Keep track of database size and unallocated space to calculate growth. And for exact info collect data for reserved, data, index_size and unused columns size in KB every half hour.
SQL DBA.
January 14, 2009 at 11:22 am
In MSDB, look at the backupset table. It has information about your backups. Since log shipping is nothing more than copying t-log backups and restoring them remotely, it should be fairly accurate.
A query like the following should give you enough information to predict log shipping requirements.
select backupset.database_name, backupset.backup_start_date,
CONVERT(numeric(18, 2), backupset.backup_size / 1048576) AS FileSizeMB
from backupset
where backupset.type = 'L' and backupset.backup_start_date >='1/1/2009'
order by backupset.database_name, backupset.backup_start_date DESC
I'll add that transaction volume is not analogous with database size growth. You could use the backupset.type of 'D' (full databases backup) in the previous to understand how much your data is actually growing over time, but that won't help with log shipping bandwidth requirements.
Kyle
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply