Post reply

aggregate canges in data

  • July 26, 2017 at 2:42 am

    #338485

    Hello All,
    i can see that there is a lot of canges in data on storage every day .
    i see ~450 GB daily change between 23:00 and 23:00 day before.
    How can i check when there is a lot of data changes, in may be users update\insert data?
    Can i aggregate this actions with profiler?

    Thanks in advance!

  • July 26, 2017 at 9:07 am

    #1952814

    Are you doing transaction log backups of this database?  If so, you might be able to narrow down when the data changes are occurring by looking at the backup history:
    SELECT bs.backup_set_id, bs.database_name, bs.backup_start_date, bs.backup_finish_date, bs.backup_size
      FROM msdb.dbo.backupset bs
        INNER JOIN msdb.dbo.backupmediafamily mf ON bs.media_set_id = mf.media_set_id
      WHERE bs.database_name = 'mydbname'
        AND bs.type = 'L'
      ORDER BY bs.backup_set_id desc

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply