For MSSQL is there any queries or methods for me to pull historical data of transaction logs generation?
I know that for Oracle database we can run a query to extract the amount of archivelogs generated hourly/daily.
Is it possible for MSSQL? I have an hourly TLog backups running on the database, so currently I'm using this as a benchmark but is there any other way?