May 25, 2016 at 1:47 pm
Hi Guys,
Is is possible to count or quantify the number of changes occuring to a database - i am not talking how many rows are added, or how the file sizes are changing... Nor do I mean TPS.
What I mean is "400 MB of changes have occured today" that is some inserts, some deletes, some updates that dont say alter the size of data in row, but if it replaces a single char field with another value, that's 1byte of change.
So i guess what I am really asking is how much data is going through the transaction logs!
cheers,
Alex
May 25, 2016 at 2:22 pm
Just review your logs. There are any number of blog posts out there on how to do that. See fn_dblog().
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
May 25, 2016 at 2:58 pm
Perfect! Cheers Kevin.
Alex
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply