Measuring Volume of Change to Database

[Former Member]

Hi All,

We are running SAP on SQL database. We would like to measure the volume of changes made to the database everyday. Could you please le me know How do I measure volume of change to database in terms of bits/bytes?

Thanks

[Former Member]

Hi,

This will be a full database mirroring at the start and changes will be mirrored online through Network.

[Former Member]

Have you seen this OSS note?

Note 965908 - SQL Server Database Mirroring and SAP Applications

[Former Member]

Hi,

Thanks a lot for the reply, That transaction was very useful. My purpose is to size bandwidth for my online replication. so I would like to know what is the average volume change per day, per hour so that I can size the bandwidth accordingly.

It will be very usefull if you can provide the SQL statement as well.

[Former Member]

Can you clarify what online replication you are referring to?

Log Shipping?

Database Mirroring?

Are you replicating specific tables?

[Former Member]

Hi,

I think what you're asking is, how do I track DB growth?

Does DB02 give you the answer you need?

Let me know if you need a SQL Server specific measurement.